public function get_reject_id_by_pmtid($pmtid) { $dao = Model_TicketCounter::data_access(); $sql = "SELECT c.ticket_id, t.pmt_id\n\t FROM ticket_counter c\n\t LEFT JOIN ticket t on t.id = c.ticket_id\n\t WHERE c.name = 'ticket_reject' and t.pmt_id = ?"; $values = array($pmtid); $ids = $dao->native_sql($sql, $values); return $ids; }
public function insert_reassign_counter($ticket_id) { $counter_old = $this->get_reassign_counter($ticket_id); if ($counter_old) { $dao = Model_TicketCounter::data_access(); $counter = $dao->find_by_pk($counter_old[0]->id); $counter->value = intval($counter->value) + 1; } else { $counter = new Model_TicketCounter(); $counter->ticket_id = $ticket_id; $counter->name = 'ticket_change_owner'; $counter->value = 1; } $counter->updated_at = date("Y-m-d H:i:s"); $counter->save(); $counter_id = $counter->id; return $counter_id; }