function &getRecordsFilteredMorewithstype($start, $limit, $filter, $content, $stype = null, $order, $table, $ordering = "")
{
global $db;
$joinstr = astercrm::createSqlWithStype($filter, $content, $stype);
if ($_SESSION['curuser']['usertype'] == 'admin') {
$sql = "SELECT * FROM credithistory WHERE ";
} elseif ($_SESSION['curuser']['usertype'] == 'groupadmin') {
$sql = "SELECT * FROM credithistory WHERE groupid = '" . $_SESSION['curuser']['groupid'] . "'";
} elseif ($_SESSION['curuser']['usertype'] == 'reseller') {
$sql = "SELECT * FROM credithistory WHERE resellerid = '" . $_SESSION['curuser']['resellerid'] . "'";
} elseif ($_SESSION['curuser']['usertype'] == 'clid') {
$sql = "SELECT * FROM credithistory WHERE clidid = '" . $_SESSION['curuser']['clidid'] . "'";
}
if ($joinstr != '') {
if ($_SESSION['curuser']['usertype'] == 'admin') {
$joinstr = ltrim($joinstr, 'AND');
//去掉最左边的AND
$sql .= $joinstr . " ";
} else {
$sql .= $joinstr . " ";
}
}
$sql .= " ORDER BY " . $order . " " . $_SESSION['ordering'] . " LIMIT {$start}, {$limit} {$ordering}";
Customer::events($sql);
$res =& $db->query($sql);
return $res;
}
function getCountAnswered($campaignid)
{
global $db;
$query = "SELECT COUNT(*) FROM campaigndialedlist WHERE campaignid = {$campaignid} AND answertime > '0000-00-00 00:00:00'";
Customer::events($query);
$res =& $db->getOne($query);
return $res;
}
function &getNumRowsMorewithstype($filter, $content, $stype, $table)
{
global $db;
$joinstr = astercrm::createSqlWithStype($filter, $content, $stype);
$sql = "SELECT COUNT(*) AS numRows FROM myrate LEFT JOIN accountgroup ON accountgroup.id = myrate.groupid LEFT JOIN resellergroup ON resellergroup.id = myrate.resellerid WHERE";
if ($_SESSION['curuser']['usertype'] == 'admin') {
$sql .= " 1 ";
} elseif ($_SESSION['curuser']['usertype'] == 'reseller') {
$sql .= " (myrate.resellerid = " . $_SESSION['curuser']['resellerid'] . " OR myrate.resellerid = 0) ";
} else {
$sql .= " ( (myrate.groupid = " . $_SESSION['curuser']['groupid'] . " OR myrate.groupid = 0) AND (myrate.resellerid = " . $_SESSION['curuser']['resellerid'] . " OR myrate.resellerid = 0) )";
}
if ($joinstr != '') {
$joinstr = ltrim($joinstr, 'AND');
//去掉最左边的AND
$sql .= " AND " . $joinstr . " ";
} else {
$sql .= " 1 ";
}
Customer::events($sql);
$res =& $db->getOne($sql);
return $res;
}
function &getRecordsFilteredMorewithstype($start, $limit, $filter, $content, $stype, $order, $table)
{
global $db;
$joinstr = astercrm::createSqlWithStype($filter, $content, $stype);
//<---- change by your function
$sql = "SELECT * FROM sms_sents WHERE 1 ";
if ($joinstr != '') {
$joinstr = ltrim($joinstr, 'AND');
//去掉最左边的AND
$sql .= " AND " . $joinstr . " " . " ORDER BY " . $order . " " . $_SESSION['ordering'] . " LIMIT {$start}, {$limit} {$ordering}";
}
Customer::events($sql);
$res =& $db->query($sql);
return $res;
}
function &getNumRowsMorewithstype($filter, $content, $stype, $table)
{
global $db;
$joinstr = astercrm::createSqlWithStype($filter, $content, $stype);
$sql = "SELECT COUNT(*) FROM account_log WHERE ";
if ($joinstr != '') {
$joinstr = ltrim($joinstr, 'AND');
//去掉最左边的AND
$sql .= " " . $joinstr;
} else {
$sql .= " 1";
}
Customer::events($sql);
$res =& $db->getOne($sql);
return $res;
}
function &getRecordsFilteredMorewithstype($start, $limit, $filter, $content, $stype, $order, $table)
{
global $db;
$joinstr = astercrm::createSqlWithStype($filter, $content, $stype, 'astercrm_account');
$sql = "SELECT astercrm_account.*, groupname FROM astercrm_account LEFT JOIN astercrm_accountgroup ON astercrm_accountgroup.id = astercrm_account.groupid WHERE ";
if ($_SESSION['curuser']['usertype'] == 'admin') {
$sql .= " 1 ";
} else {
$sql .= " astercrm_account.groupid = " . $_SESSION['curuser']['groupid'] . " ";
}
if ($joinstr != '') {
$joinstr = ltrim($joinstr, 'AND');
//去掉最左边的AND
$sql .= " AND " . $joinstr . " " . " ORDER BY " . $order . " " . $_SESSION['ordering'] . " LIMIT {$start}, {$limit} {$ordering}";
}
Customer::events($sql);
$res =& $db->query($sql);
return $res;
}
function &getNumRowsMorewithstype($filter, $content, $stype, $table)
{
global $db;
$joinstr = astercrm::createSqlWithStype($filter, $content, $stype);
$sql = "SELECT COUNT(*) FROM note LEFT JOIN customer ON customer.id = note.customerid LEFT JOIN contact ON contact.id = note.contactid WHERE ";
if ($_SESSION['curuser']['usertype'] == 'admin') {
$sql .= " ";
} else {
$sql .= " note.groupid = " . $_SESSION['curuser']['groupid'] . " AND ";
}
if ($joinstr != '') {
$joinstr = ltrim($joinstr, 'AND');
//去掉最左边的AND
$sql .= " " . $joinstr;
} else {
$sql .= " 1";
}
Customer::events($sql);
$res =& $db->getOne($sql);
return $res;
}
function &getNumRowsMorewithstype($filter, $content, $stype, $table)
{
global $db, $config;
$updateTimeInterval = $config['system']['update_online_interval'] * 60;
$joinstr = astercrm::createSqlWithStype($filter, $content, $stype, "diallist");
$sql = "SELECT COUNT(*) FROM astercrm_account WHERE (UNIX_TIMESTAMP(now())-UNIX_TIMESTAMP(last_update_time)) < {$updateTimeInterval} ";
if ($_SESSION['curuser']['usertype'] == 'admin') {
$sql .= " ";
} else {
$sql .= " AND groupid = " . $_SESSION['curuser']['groupid'] . " AND ";
}
if ($joinstr != '') {
$joinstr = ltrim($joinstr, 'AND');
//去掉最左边的AND
$sql .= " AND " . $joinstr;
} else {
$sql .= " 1";
}
Customer::events($sql);
$res =& $db->getOne($sql);
return $res;
}
function formDiallist($dialedlistid)
{
global $locate, $db;
$sql = "SELECT dialednumber, customername,memo,campaignid FROM dialedlist WHERE id = {$dialedlistid}";
Customer::events($sql);
$row =& $db->getRow($sql);
$html = '';
if ($row) {
$html = Table::Top($locate->Translate("Customer from Diallist"), "formDiallistPopup");
// <-- Set the title for your form.
$html .= '<table border="1" width="100%" class="adminlist" id="d" name="d">
<tr><td width="45%"> ' . $locate->Translate("Customer Name") . ': </td><td>' . $row['customername'] . '</td></tr>
<tr><td> ' . $locate->Translate("Pone Number") . ': </td><td>' . $row['dialednumber'] . '</td></tr>
<tr><td> ' . $locate->Translate("Memo") . ': </td><td>' . $row['memo'] . '</td></tr>';
if ($row['campaignid'] != 0 && $row['campaignid'] != '') {
//获取拨号计划的备注
$CampaignNote = Customer::getCampaignNote($row['campaignid']);
$html .= '<tr><td> ' . $locate->Translate("Campaign Memo") . ': </td><td>' . $CampaignNote . '</td></tr>';
}
$html .= '
</table>';
// <-- Change by your method
$html .= Table::Footer();
}
return $html;
}
function searchFormSubmit($searchFormValue, $numRows = null, $limit = null, $id = null, $type = null)
{
global $locate, $db, $config;
$objResponse = new xajaxResponse();
$searchField = array();
$searchContent = array();
$optionFlag = $searchFormValue['optionFlag'];
$searchContent = $searchFormValue['searchContent'];
//搜索内容 数组
$searchField = $searchFormValue['searchField'];
//搜索条件 数组
$searchType = $searchFormValue['searchType'];
$ordering = $searchFormValue['ordering'];
$order = $searchFormValue['order'];
// print_r($searchFormValue);exit;
$divName = "grid";
if ($optionFlag == "export" || $optionFlag == "exportcsv") {
if ($config['system']['enable_code']) {
$sql = Customer::specialGetSql($searchContent, $searchField, $searchType, 'customer', array('customer.*', 'note.note' => 'note', 'note.codes' => 'codes', 'note.creby' => 'last_note_created_by', 'note.cretime' => 'noteCretime'), array('note' => array('note.id', 'customer.last_note_id')));
//得到要导出的sql语句
} else {
$sql = Customer::specialGetSql($searchContent, $searchField, $searchType, 'customer');
//得到要导出的sql语句
}
$_SESSION['export_sql'] = $sql;
$objResponse->addAssign("hidSql", "value", $sql);
//赋值隐含域
$objResponse->addAssign("maintable", "value", 'customer');
//赋值隐含域
$objResponse->addAssign("exporttype", "value", $optionFlag);
$objResponse->addScript("document.getElementById('exportForm').submit();");
}
if ($optionFlag == "delete") {
$customer_ref =& Customer::getRecordsFilteredMorewithstype('', '', $searchField, $searchContent, $searchType, '', 'customer', 'delete');
while ($customer_ref->fetchInto($row)) {
Customer::deleteRecord($row['id'], 'customer');
Customer::deleteRecords("customerid", $row['id'], 'note');
Customer::deleteRecords("customerid", $row['id'], 'contact');
}
$html = createGrid($searchFormValue['numRows'], $searchFormValue['limit'], '', '', $order, $divName, $ordering, '');
$objResponse->addClear("msgZone", "innerHTML");
$objResponse->addAssign($divName, "innerHTML", $html);
} else {
if ($optionFlag == "move_to_customerleads" || $optionFlag == "copy_to_customerleads") {
$lead_sql = Customer::specialGetSql($searchContent, $searchField, $searchType, 'customer');
Customer::events($lead_sql);
$customer_lead =& $db->query($lead_sql);
$i = 0;
while ($customer_lead->fetchInto($row)) {
$res = astercrm::insertNewCustomerLead($row['id'], $config['system']['customer_leads'], true);
if ($res) {
$i++;
}
}
$html = createGrid($searchFormValue['numRows'], $searchFormValue['limit'], '', '', $order, $divName, $ordering, '');
//$objResponse->addClear("msgZone", "innerHTML");
$showHtml = '';
if ($config['system']['customer_leads'] == 'move' || $config['system']['customer_leads'] == 'default_move') {
$showHtml = $i . $locate->Translate(" customer was moved to customer_leads");
} else {
if ($config['system']['customer_leads'] == 'copy' || $config['system']['customer_leads'] == 'default_copy') {
$showHtml = $i . $locate->Translate(" customer was copied to customer_leads");
}
}
$objResponse->addAssign($divName, "innerHTML", $html);
$objResponse->addAssign("msgZone", "innerHTML", $showHtml);
} else {
if ($type == "delete") {
$res = Customer::deleteRecord($id, 'customer');
if ($res) {
$html = createGrid($searchFormValue['numRows'], $searchFormValue['limit'], $searchField, $searchContent, $order, $divName, $ordering, 1, $searchType);
$objResponse = new xajaxResponse();
$objResponse->addAssign("msgZone", "innerHTML", $locate->Translate("delete_rec"));
} else {
$objResponse->addAssign("msgZone", "innerHTML", $locate->Translate("rec_cannot_delete"));
}
} else {
$html = createGrid($numRows, $limit, $searchField, $searchContent, $order, $divName, $ordering, 1, $searchType);
}
$objResponse->addClear("msgZone", "innerHTML");
$objResponse->addAssign($divName, "innerHTML", $html);
}
}
return $objResponse->getXML();
}
function &getRecordsFilteredMorewithstype($start, $limit, $filter, $content, $stype, $order, $table)
{
global $db;
$joinstr = astercrm::createSqlWithStype($filter, $content, $stype);
//<---- change by your function
$sql = "SELECT sms_templates.*,campaign.campaignname,trunkinfo.trunkname FROM sms_templates LEFT JOIN campaign ON campaign.id = sms_templates.campaign_id LEFT JOIN trunkinfo ON trunkinfo.id = sms_templates.trunkinfo_id WHERE 1 ";
if ($joinstr != '') {
$joinstr = ltrim($joinstr, 'AND');
//去掉最左边的AND
$sql .= " AND " . $joinstr . " " . " ORDER BY " . $order . " " . $_SESSION['ordering'] . " LIMIT {$start}, {$limit} {$ordering}";
}
Customer::events($sql);
$res =& $db->query($sql);
return $res;
}
function deleteRate($deleteSql, $historySql)
{
global $locate, $db, $config;
$objResponse = new xajaxResponse();
if (empty($deleteSql)) {
$objResponse->addAlert($locate->Translate("Can not delete this rate"));
return $objResponse;
}
//if enable the synchronizatioin
if ($config['synchronize']['delete_by_use_history']) {
Customer::events($historySql);
$insertResult = $db->query($historySql);
if ($insertResult <= 0) {
$objResponse->addAlert($locate->Translate("delete failed synchronization"));
return $objResponse;
}
}
Customer::events($deleteSql);
$result = $db->query($deleteSql);
if ($result) {
$objResponse->addAlert($locate->Translate("Delete success") . ',' . $locate->Translate("please remember to restart asterrc"));
$objResponse->addAssign("searchRateList", "innerHTML", $locate->Translate("page_rate_tips") . ' <input type="button" value="' . $locate->Translate("restart asterrc") . '" onclick="restartAsterrc();return false;" />');
} else {
$objResponse->addAlert($locate->Translate("Delete failed"));
}
return $objResponse;
}
function &getNumRowsByCustomerid($table = 'mycdr', $customerid)
{
global $db;
$sql .= " SELECT COUNT(*) FROM " . $table . " WHERE customerid = {$customerid} AND (groupid > 0 OR resellerid > '0')";
//echo $sql;exit;
Customer::events($sql);
$res =& $db->getOne($sql);
return $res;
}
function &getNumRowsMorewithstype($filter, $content, $stype, $table)
{
global $customers_db, $config;
$joinstr = astercrm::createSqlWithStype($filter, $content, $stype);
$sql = "SELECT COUNT(*) FROM " . $config['customers']['customertable'] . " WHERE ";
//if ($_SESSION['curuser']['usertype'] == 'admin'){
$sql .= " 1 ";
//}
if ($joinstr != '') {
$joinstr = ltrim($joinstr, 'AND');
//去掉最左边的AND
$sql .= " AND " . $joinstr;
}
Customer::events($sql);
$res =& $customers_db->getOne($sql);
return $res;
}
function deletefromsearch($searchContent, $searchField, $searchType = "", $table)
{
global $db;
if (empty($_SESSION['curuser']['usertype'])) {
return;
}
$joinstr = astercrm::createSqlWithStype($searchField, $searchContent, $searchType, $table, 'delete');
if ($joinstr != '') {
$joinstr = ltrim($joinstr, 'AND');
if ($_SESSION['curuser']['usertype'] == 'admin') {
$sql = 'DELETE FROM ' . $table . ' WHERE ' . $joinstr;
} else {
$sql = 'DELETE FROM ' . $table . ' WHERE ' . $joinstr . " AND " . $table . ".groupid = '" . $_SESSION['curuser']['groupid'] . "'";
}
} else {
if ($_SESSION['curuser']['usertype'] == 'admin') {
$sql = 'TRUNCATE table ' . $table;
} else {
$sql = "DELETE FROM " . $table . " WHERE " . $table . ".groupid = '" . $_SESSION['curuser']['groupid'] . "'";
}
}
Customer::events($sql);
$res =& $db->query($sql);
return $res;
}
function &getNumRowsMore($filter = null, $content = null, $table)
{
global $db;
$i = 0;
$joinstr = '';
foreach ($content as $value) {
$value = trim($value);
if (strlen($value) != 0 && strlen($filter[$i]) != 0) {
$joinstr .= "AND {$filter[$i]} like '%" . $value . "%' ";
}
$i++;
}
$sql = "SELECT COUNT(*) FROM remindercalls LEFT JOIN astercrm_accountgroup ON astercrm_accountgroup.id = remindercalls.groupid LEFT JOIN asteriskcalls ON asteriskcalls.id = remindercalls.asteriskcallsid WHERE ";
if ($_SESSION['curuser']['usertype'] == 'admin') {
$sql .= " ";
} else {
$sql .= " remindercalls.groupid = " . $_SESSION['curuser']['groupid'] . " AND ";
}
if ($joinstr != '') {
$joinstr = ltrim($joinstr, 'AND');
//去掉最左边的AND
$sql .= " " . $joinstr;
} else {
$sql .= " 1";
}
Customer::events($sql);
$res =& $db->getOne($sql);
return $res;
}
/**
* Devuelte el numero de registros de acuerdo a los parámetros del filtro
*
* @param $filter (string) Nombre del campo para aplicar el filtro en la consulta SQL
* @param $order (string) Campo por el cual se aplicará el orden en la consulta SQL.
* @return $row['numrows'] (int) Número de registros (líneas)
*/
function &getNumRows($filter = null, $content = null)
{
global $db;
if ($_SESSION['curuser']['usertype'] == 'admin') {
$sql = " SELECT COUNT(*) FROM campaigndialedlist LEFT JOIN astercrm_accountgroup ON astercrm_accountgroup.id = campaigndialedlist.groupid LEFT JOIN customer ON customer.id = campaigndialedlist.customerid";
} else {
$sql = " SELECT COUNT(*) FROM campaigndialedlist LEFT JOIN astercrm_accountgroup ON astercrm_accountgroup.id = campaigndialedlist.groupid LEFT JOIN customer ON customer.id = campaigndialedlist.customerid WHERE campaigndialedlist.groupid = " . $_SESSION['curuser']['groupid'] . " ";
}
Customer::events($sql);
$res =& $db->getOne($sql);
return $res;
}
function &getNumRowsMorewithstype($filter, $content, $stype, $table)
{
global $db;
$joinstr = astercrm::createSqlWithStype($filter, $content, $stype);
if ($joinstr != '') {
$joinstr = ltrim($joinstr, 'AND');
//去掉最左边的AND
$sql = 'SELECT COUNT(*) AS numRows FROM resellergroup WHERE ' . $joinstr;
} else {
$sql = "SELECT COUNT(*) AS numRows FROM resellergroup";
}
Customer::events($sql);
$res =& $db->getOne($sql);
return $res;
}
function &getRecordsFilteredMorewithstype($start, $limit, $filter, $content, $stype, $order, $table)
{
global $db;
$joinstr = Customer::createSqlWithStype($filter, $content, $stype, 'ticket_details');
//<---- change by your function
$sql = "SELECT ticket_op_logs.*,AccountGroup.groupname as groupname FROM ticket_op_logs LEFT JOIN astercrm_accountgroup AS AccountGroup ON AccountGroup.id = ticket_op_logs.groupid WHERE ";
if ($_SESSION['curuser']['usertype'] == 'admin') {
$sql .= " 1";
} else {
$sql .= " ticket_op_logs.groupid = '" . $_SESSION['curuser']['groupid'] . "' ";
}
if ($joinstr != '') {
$joinstr = ltrim($joinstr, 'AND');
//去掉最左边的AND
$sql .= " AND " . $joinstr . " " . " ORDER BY " . $order . " " . $_SESSION['ordering'] . " LIMIT {$start}, {$limit} {$ordering}";
}
Customer::events($sql);
$res =& $db->query($sql);
return $res;
}
/**
* Devuelte el numero de registros de acuerdo a los parámetros del filtro
*
* @param $filter (string) Nombre del campo para aplicar el filtro en la consulta SQL
* @param $order (string) Campo por el cual se aplicará el orden en la consulta SQL.
* @return $row['numrows'] (int) Número de registros (líneas)
*/
function &getNumRows($filter = null, $content = null)
{
global $db;
if ($_SESSION['curuser']['usertype'] == 'admin') {
$sql = " SELECT COUNT(*) FROM trunkinfo LEFT JOIN accountgroup ON accountgroup.id = trunkinfo.groupid";
} else {
$sql = " SELECT COUNT(*) FROM trunkinfo LEFT JOIN accountgroup ON accountgroup.id = trunkinfo.groupid WHERE trunkinfo.groupid = " . $_SESSION['curuser']['groupid'] . " ";
}
$sql = " SELECT COUNT(*) FROM trunkinfo ";
Customer::events($sql);
$res =& $db->getOne($sql);
return $res;
}
function deleteFromSearch($searchContent, $searchField, $searchType = "", $table)
{
global $db;
$joinstr = astercrm::createSqlWithStype($searchField, $searchContent, $searchType, $table);
if ($joinstr != '') {
$joinstr = ltrim($joinstr, 'AND');
$sql = 'DELETE FROM ' . $table . ' LEFT JOIN clid ON clid.id = curcdr.userid LEFT JOIN resellergroup ON resellergroup.id = curcdr.resellerid LEFT JOIN accountgroup ON accountgroup.id = curcdr.groupid WHERE ' . $joinstr;
} else {
if ($_SESSION['curuser']['usertype'] == 'admin') {
$sql = 'TRUNCATE ' . $table;
} else {
$sql = "DELETE FROM " . $table . " WHERE " . $table . ".groupid = '" . $_SESSION['curuser']['groupid'] . "'";
}
}
//echo $sql;exit;
Customer::events($sql);
$res =& $db->query($sql);
return $res;
}
function deleteToHistoryFromSearch($searchContent, $searchField, $searchType = "", $table)
{
global $db, $config;
if (empty($_SESSION['curuser']['usertype'])) {
return;
}
$joinstr = astercrm::createSqlWithStype($searchField, $searchContent, $searchType, $table);
if ($joinstr != '') {
$joinstr = ltrim($joinstr, 'AND');
$history_sql = "INSERT INTO " . $table . "_history SELECT * FROM " . $table . " WHERE " . $joinstr;
$sql = 'DELETE FROM ' . $table . ' WHERE ' . $joinstr;
} else {
if ($_SESSION['curuser']['usertype'] == 'admin') {
$sql = 'TRUNCATE ' . $table;
$history_sql = "INSERT INTO " . $table . "_history SELECT * FROM " . $table . " ";
} else {
$sql = "DELETE FROM " . $table . " WHERE " . $table . ".groupid = '" . $_SESSION['curuser']['groupid'] . "'";
$history_sql = "INSERT INTO " . $table . "_history SELECT * FROM " . $table . " WHERE " . $table . ".groupid = '" . $_SESSION['curuser']['groupid'] . "' ";
}
}
Customer::events($history_sql);
$result =& $db->query($history_sql);
if ($result) {
Customer::events($sql);
$res =& $db->query($sql);
return $res;
} else {
return false;
}
}
function &getNumRowsMorewithstype($filter = null, $content = null, $stype, $table)
{
global $db;
$joinstr = astercrm::createSqlWithStype($filter, $content, $stype);
$sql = "SELECT COUNT(*) AS numRows FROM surveyresult LEFT JOIN customer ON customer.id = surveyresult.customerid LEFT JOIN contact ON contact.id = surveyresult.contactid LEFT JOIN survey ON survey.id = surveyresult.surveyid LEFT JOIN campaign ON campaign.id = surveyresult.campaignid WHERE ";
if ($_SESSION['curuser']['usertype'] == 'admin') {
$sql .= " ";
} else {
$sql .= " surveyresult.groupid = " . $_SESSION['curuser']['groupid'] . " AND ";
}
if ($joinstr != '') {
$joinstr = ltrim($joinstr, 'AND');
//去掉最左边的AND
$sql .= " " . $joinstr;
} else {
$sql .= " 1";
}
Customer::events($sql);
$res =& $db->getOne($sql);
// print $sql;
// print "\n";
// print $res;
// exit;
return $res;
}
function &getNumRowsMorewithstype($filter, $content, $stype, $table)
{
global $db;
$joinstr = astercrm::createSqlWithStype($filter, $content, $stype, "worktimepackages");
$sql = "SELECT COUNT(*) FROM worktimepackages LEFT JOIN astercrm_accountgroup ON astercrm_accountgroup.id = worktimepackages.groupid WHERE ";
if ($_SESSION['curuser']['usertype'] == 'admin') {
$sql .= " ";
} else {
$sql .= " worktimepackages.groupid = " . $_SESSION['curuser']['groupid'] . " AND ";
}
if ($joinstr != '') {
$joinstr = ltrim($joinstr, 'AND');
//去掉最左边的AND
$sql .= " " . $joinstr;
} else {
$sql .= " 1";
}
Customer::events($sql);
$res =& $db->getOne($sql);
return $res;
}
function &getNumRowsMorewithstype($filter, $content, $stype, $table)
{
global $db;
$joinstr = astercrm::createSqlWithStype($filter, $content, $stype, "campaign");
$sql = "SELECT COUNT(*) FROM campaignresult LEFT JOIN astercrm_accountgroup ON astercrm_accountgroup.groupid = campaignresult.groupid LEFT JOIN campaign ON campaign.id = campaignresult.campaignid LEFT JOIN campaignresult AS presult ON presult.id = campaignresult.parentid WHERE ";
if ($_SESSION['curuser']['usertype'] == 'admin') {
$sql .= " ";
} else {
$sql .= " campaignresult.groupid = " . $_SESSION['curuser']['groupid'] . " AND ";
}
if ($joinstr != '') {
$joinstr = ltrim($joinstr, 'AND');
//去掉最左边的AND
$sql .= " " . $joinstr;
} else {
$sql .= " 1";
}
Customer::events($sql);
$res =& $db->getOne($sql);
return $res;
}
/**
* Borra un registro de la tabla.
*
* @param $id (int) Identificador del registro a ser borrado.
* @return $res (object) Devuelve el objeto con la respuesta de la sentencia SQL ejecutada del DELETE.
*/
function deleteRecord($id)
{
global $db;
//backup all datas
//delete all customers
$sql = "DELETE FROM contact WHERE id = {$id}";
Customer::events($sql);
$res =& $db->query($sql);
//delete all note
$sql = "DELETE FROM note WHERE contactid = {$id}";
Customer::events($sql);
$res =& $db->query($sql);
return $res;
}
function searchRateHtml($table, $type, $object)
{
global $db, $locate, $config;
if ($table == 'resellerrate') {
$sql = "SELECT {$table}.*,resellergroup.resellername FROM {$table} LEFT JOIN resellergroup ON resellergroup.id = {$table}.resellerid WHERE 1";
} else {
$sql = "SELECT {$table}.*,resellergroup.resellername,accountgroup.groupname FROM {$table} LEFT JOIN resellergroup ON resellergroup.id = {$table}.resellerid LEFT JOIN accountgroup ON accountgroup.id = {$table}.groupid WHERE 1";
}
$totalSql = "SELECT count(*) FROM {$table} WHERE 1 ";
$insertSql = "INSERT INTO {$table}_history SELECT * FROM {$table} WHERE 1 ";
$deleteSql = "DELETE FROM {$table} WHERE 1 ";
$tmpSql = '';
if ($type == 'all') {
$tmpSql .= " ";
} else {
if ($type == 'system') {
$tmpSql .= " AND {$table}.resellerid = 0 ";
} else {
if ($type == 'reseller') {
$tmpSql .= " AND {$table}.resellerid = '{$object}' ";
} else {
if ($type == 'group') {
if ($object == 'default') {
$tmpSql .= " AND {$table}.groupid = 0 ";
} else {
$tmpSql .= " AND {$table}.groupid = '{$object}' ";
}
}
}
}
}
$insertSql .= $tmpSql;
//search total rate by this conditions
Customer::events($totalSql . $tmpSql);
$totalRes =& $db->query($totalSql . $tmpSql);
$totalRes->fetchInto($totalResult, DB_FETCHMODE_ORDERED);
$deleteSql = $deleteSql . $tmpSql;
//delete sql
$sql = $sql . $tmpSql . " limit 20 ; ";
//show 20 data on the page
Customer::events($sql);
$result =& $db->query($sql);
// <input type="button" value="'.$locate->Translate("delete").'" onclick="if (confirm(\''.$locate->Translate("Are you sure you want to delete this rate").'?\')) xajax_deleteRate(document.getElementById(\'deleteSql\').value);return false;" />
$dataHtml = '<div>' . $locate->Translate('Rate Amount is') . ' ' . $totalResult[0] . ',' . $locate->Translate('default show 20 data') . '</div>
<table border="1" class="adminlist">
<tr>
<th width="" class="title">' . $locate->Translate('id') . '</th>
<th width="" class="title">' . $locate->Translate('prefix') . '</th>
<th width="" class="title">' . $locate->Translate('length') . '</th>
<th width="" class="title">' . $locate->Translate('destination') . '</th>
<th width="" class="title">' . $locate->Translate('connect_charge') . '</th>
<th width="" class="title">' . $locate->Translate('init_block') . '</th>
<th width="" class="title">' . $locate->Translate('rate') . '</th>
<th width="" class="title">' . $locate->Translate('billing_block') . '</th>
<th width="" class="title">' . $locate->Translate('group') . '</th>
<th width="" class="title">' . $locate->Translate('reseller') . '</th>
<th width="" class="title">' . $locate->Translate('addtime') . '</th>
</tr>';
$i = 0;
while ($result->fetchInto($row)) {
$j = 0;
if ($i % 2 == 0) {
$j = 1;
}
if ($config['synchronize']['display_synchron_server']) {
$html .= astercrm::getSynchronDisplay($row['id'], $row['id']);
}
$dataHtml .= '<tr class="row' . $j . '" id="gridRow' . $i . '">
<td style="cursor: pointer;" id="gridRow1Col1">' . $row['id'] . '</td>
<td style="cursor: pointer;" id="gridRow1Col2">' . $row['dialprefix'] . '</td>
<td style="cursor: pointer;" id="gridRow1Col3">' . $row['numlen'] . '</td>
<td style="cursor: pointer;" id="gridRow1Col4">' . $row['destination'] . '</td>
<td style="cursor: pointer;" id="gridRow1Col5">' . $row['connectcharge'] . '</td>
<td style="cursor: pointer;" id="gridRow1Col6">' . $row['initblock'] . '</td>
<td style="cursor: pointer;" id="gridRow1Col7">' . $row['rateinitial'] . '</td>
<td style="cursor: pointer;" id="gridRow1Col8">' . $row['billingblock'] . '</td>
<td style="cursor: pointer;" id="gridRow1Col9">' . $row['groupname'] . '</td>
<td style="cursor: pointer;" id="gridRow1Col10">' . $row['resellername'] . '</td>
<td style="cursor: pointer;" id="gridRow1Col11">' . $row['addtime'] . '</td>
</tr>';
}
$dataHtml .= '</table><input type="hidden" id="deleteSql" value="' . $deleteSql . '" /><input type="hidden" id="historySql" value="' . $insertSql . '" />';
return $dataHtml;
}
