本文整理汇总了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;
}