0"; echo $strSQL."
"; $objConn->query($strSQL); echo $objConn->affected_rows. " rows affected
"; $strSQL = "UPDATE IGNORE db_outreach_calls SET _answered = STR_TO_DATE(_answeredAt, '%m/%d/%Y %h:%i:%s %r')) WHERE LENGTH (_createdAt)>0"; echo $strSQL."
"; $objConn->query($strSQL); echo $objConn->affected_rows. " rows affected
"; $strSQL = "UPDATE IGNORE db_outreach_calls SET _completed= STR_TO_DATE(_completedAt, '%m/%d/%Y %h:%i:%s %r')) WHERE LENGTH (_completedAt)>0"; echo $strSQL."
"; $objConn->query($strSQL); echo $objConn->affected_rows. " rows affected
"; $strSQL = "UPDATE db_outreach_calls SET _createDT = UNIX_TIMESTAMP(_created),_answerDT = UNIX_TIMESTAMP(_answered),_completeDT = UNIX_TIMESTAMP(_completed),_hasAnswer=0, _hasInterest = 0"; echo $strSQL."
"; $objConn->query($strSQL); echo $objConn->affected_rows. " rows affected
"; $strSQL = "UPDATE db_outreach_calls SET _hasAnswer = 1 WHERE _disposition IN ('Answered - Demo Scheduled','Answered - Keep in Sequence','Answered - No Interest','Gatekeeper','Quality Call','Referred To Other Contact','Wrong Number','Wrong POC')"; echo $strSQL."
"; $objConn->query($strSQL); echo $objConn->affected_rows. " rows affected
"; $strSQL = "UPDATE db_outreach_calls SET _hasInterest = 1 WHERE _disposition IN ('Answered - Demo Scheduled','Quality Call')"; echo $strSQL."
"; $objConn->query($strSQL); echo $objConn->affected_rows. " rows affected
"; $strSQL = "UPDATE db_outreach_calls SET _caller = CONCAT(_userFirstName,' ',_userLastName) WHERE (_caller IS NULL OR LENGTH(_caller)=0)"; echo $strSQL."
"; $objConn->query($strSQL); echo $objConn->affected_rows. " rows affected
"; $strSQL = "UPDATE db_outreach_calls a INNER JOIN (SELECT _leadID, _email FROM dashboard_lead WHERE LENGTH(_email)>0) o SET a._sfdcID = o._leadID WHERE LENGTH(a._prospectEmail)>0 AND a._prospectEmail = o._email"; echo $strSQL."
"; $objConn->query($strSQL); echo $objConn->affected_rows. " rows affected
"; $strSQL = "UPDATE db_outreach_calls a INNER JOIN (SELECT _contactID, _email FROM dashboard_contact WHERE LENGTH(_email)>0) o SET a._sfdcID = o._contactID WHERE LENGTH(a._prospectEmail)>0 AND a._prospectEmail = o._email"; echo $strSQL."
"; $objConn->query($strSQL); echo $objConn->affected_rows. " rows affected
"; ?>