当前位置: 首页>>代码示例>>PHP>>正文


PHP astercrm::createTicketSqlWithStype方法代码示例

本文整理汇总了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;
 }
开发者ID:ljhcj,项目名称:IRISCC,代码行数:28,代码来源:astercrm.class.php


注:本文中的astercrm::createTicketSqlWithStype方法示例由纯净天空整理自Github/MSDocs等开源代码及文档管理平台,相关代码片段筛选自各路编程大神贡献的开源项目,源码版权归原作者所有,传播和使用请参考对应项目的License;未经允许,请勿转载。