本文整理匯總了PHP中astercrm::createTicketSqlWithStype方法的典型用法代碼示例。如果您正苦於以下問題：PHP astercrm::createTicketSqlWithStype方法的具體用法？PHP astercrm::createTicketSqlWithStype怎麽用？PHP astercrm::createTicketSqlWithStype使用的例子？那麽, 這裏精選的方法代碼示例或許可以為您提供幫助。您也可以進一步了解該方法所在類astercrm的用法示例。
在下文中一共展示了astercrm::createTicketSqlWithStype方法的1個代碼示例，這些例子默認根據受歡迎程度排序。您可以為喜歡或者感覺有用的代碼點讚，您的評價將有助於係統推薦出更棒的PHP代碼示例。
示例1: IN
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 = '" . $_SESSION['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;
}