Update function
Posted: Tue Mar 23, 2010 8:57 pm
Code: Select all
function updateHelpDeskSC($focusId, $entityIds) {
if(!is_array($entityIds)) $entityIds = array($entityIds);
$selectTicketsQuery = "SELECT ticketid FROM vtiger_troubletickets WHERE (servicecontractsid IS NULL OR servicecontractsid = 0) AND ticketid IN (" . generateQuestionMarks($entityIds) .")";
$selectTicketsResult = $this->db->pquery($selectTicketsQuery, array($entityIds));
$noOfTickets = $this->db->num_rows($selectTicketsResult);
for($i=0; $i < $noOfTickets; ++$i) {
$ticketId = $this->db->query_result($selectTicketsResult,$i,'ticketid');
$updateQuery = "UPDATE vtiger_troubletickets SET servicecontractsid=vtiger_servicecontracts.servicecontractsid" .
" WHERE vtiger_servicecontracts.servicecontractsid = ? AND vtiger_troubletickets.ticketid = ?";
$updateResult = $this->db->pquery($updateQuery, array($focusId, $ticketId));
}
}TQ