function &getTicketRecordsFilteredMorewithstype($start, $limit, $filter, $content, $stype, $order, $table, $Ctype, $Cid = 0)
{
global $db;
$joinstr = astercrm::createTicketSqlWithStype($filter, $content, $stype, 'ticket_details');
//<---- change by your function
$sql = "SELECT ticket_details.*,ticketcategory.ticketname as ticketcategoryname,tickets.ticketname as ticketname, customer,username FROM ticket_details LEFT JOIN tickets AS ticketcategory ON ticketcategory.id = ticket_details.ticketcategoryid LEFT JOIN tickets AS tickets ON tickets.id = ticket_details.ticketid LEFT JOIN customer ON customer.id = ticket_details.customerid LEFT JOIN astercrm_account ON astercrm_account.id = ticket_details.assignto WHERE ";
if ($Ctype == 'agent_tickets') {
if ($_SESSION['curuser']['usertype'] == 'admin') {
$sql .= " 1 AND ticket_details.assignto={$Cid} AND ticket_details.status IN('new','panding')";
} else {
$sql .= " (username = '******'curuser']['username'] . "' OR (ticket_details.groupid='" . $_SESSION['curuser']['groupid'] . "' AND ticket_details.assignto=0)) AND ticket_details.status IN('new','panding')";
}
} else {
if ($_SESSION['curuser']['usertype'] == 'admin') {
$sql .= " 1 AND ticket_details.customerid={$Cid}";
} else {
$sql .= " ticket_details.assignto IN (0," . $_SESSION['curuser']['accountid'] . ") AND ticket_details.customerid={$Cid}";
}
}
if ($joinstr != '') {
$joinstr = ltrim($joinstr, 'AND');
//去掉最左边的AND
$sql .= " AND " . $joinstr . " " . " ORDER BY " . $order . " " . $_SESSION['ordering'] . " LIMIT {$start}, {$limit} {$ordering}";
}
astercrm::events($sql);
$res =& $db->query($sql);
return $res;
}
