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; }