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;
}
