function searchFormSubmit($searchFormValue, $numRows = null, $limit = null, $id = null, $type = null) { global $locate, $db, $config; $objResponse = new xajaxResponse(); $searchField = array(); $searchContent = array(); $searchContent = $searchFormValue['searchContent']; //搜索内容 数组 $searchField = $searchFormValue['searchField']; //搜索条件 数组 $searchType = $searchFormValue['searchType']; $divName = "grid"; if ($type == "delete") { if ($config['system']['portal_display_type'] == "note") { $res = Customer::deleteRecord($id, 'note'); } else { $res = Customer::deleteRecord($id, 'customer'); } if ($res) { $html = createGrid($searchFormValue['numRows'], $searchFormValue['limit'], $searchField, $searchContent, $searchField, $divName, ""); $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, $searchField, $divName, "", $searchType); } $objResponse->addClear("msgZone", "innerHTML"); $objResponse->addAssign($divName, "innerHTML", $html); return $objResponse->getXML(); }
function searchFormSubmit($searchFormValue, $numRows = null, $limit = null, $id = null, $type = null) { global $locate, $db; $objResponse = new xajaxResponse(); $searchField = array(); $searchContent = array(); $optionFlag = $searchFormValue['optionFlag']; $exportFlag = $searchFormValue['exportFlag']; $searchContent = $searchFormValue['searchContent']; //搜索内容 数组 $searchField = $searchFormValue['searchField']; //搜索条件 数组 $searchType = $searchFormValue['searchType']; $ordering = $searchFormValue['ordering']; $order = $searchFormValue['order']; $divName = "grid"; if ($optionFlag == "export" || $optionFlag == "exportcsv") { $sql = astercrm::getSql($searchContent, $searchField, $searchType, 'diallist'); //得到要导出的sql语句 $joinstr = astercrm::createSqlWithStype($searchField, $searchContent, $searchType, 'diallist'); $joinstr = ltrim($joinstr, 'AND'); $sql = "SELECT diallist.dialnumber, customer.customer,diallist.customername,diallist.dialtime, diallist.assign,diallist.status,groupname,campaignname,diallist.cretime,diallist.creby,diallist.memo FROM diallist LEFT JOIN astercrm_accountgroup ON astercrm_accountgroup.groupid = diallist.groupid LEFT JOIN campaign ON campaign.id = diallist.campaignid LEFT JOIN customer ON customer.id = diallist.customerid"; if ($joinstr != '') { $sql .= " WHERE " . $joinstr; } $_SESSION['export_sql'] = $sql; $objResponse->addAssign("hidSql", "value", $sql); //赋值隐含域 $objResponse->addAssign("maintable", "value", 'diallist'); //赋值隐含域 $objResponse->addAssign("exporttype", "value", $optionFlag); $objResponse->addScript("document.getElementById('exportForm').submit();"); } elseif ($optionFlag == "delete") { astercrm::deletefromsearch($searchContent, $searchField, $searchType, 'diallist'); $html = createGrid($searchFormValue['numRows'], $searchFormValue['limit'], '', '', $order, $divName, $ordering, ''); $objResponse->addClear("msgZone", "innerHTML"); $objResponse->addAssign($divName, "innerHTML", $html); } else { if ($type == "delete") { $res = Customer::deleteRecord($id, 'diallist'); if ($res) { $html = createGrid($searchFormValue['numRows'], $searchFormValue['limit'], $searchField, $searchContent, $order, $divName, $ordering, $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, $searchType); } $objResponse->addClear("msgZone", "innerHTML"); $objResponse->addAssign($divName, "innerHTML", $html); } return $objResponse->getXML(); }
function searchFormSubmit($searchFormValue, $numRows, $limit, $id, $type) { global $locate, $db, $config; $objResponse = new xajaxResponse(); $searchField = array(); $searchContent = array(); $optionFlag = $searchFormValue['optionFlag']; $searchContent = $searchFormValue['searchContent']; //搜索内容 数组 $searchField = $searchFormValue['searchField']; //搜索条件 数组 $searchType = $searchFormValue['searchType']; //搜索方式 数组 $divName = "grid"; if ($optionFlag == "export") { $sql = astercrm::getSql($searchContent, $searchField, $searchType, 'accountgroup'); //得到要导出的sql语句 $_SESSION['export_sql'] = $sql; $objResponse->addAssign("hidSql", "value", $sql); //赋值隐含域 $objResponse->addScript("document.getElementById('exportForm').submit();"); } elseif ($type == "delete") { if ($config['synchronize']['delete_by_use_history']) { $res = Customer::deleteRecordToHistory('groupid', $id, 'clid'); $res = Customer::deleteRecordToHistory('groupid', $id, 'myrate'); $res = Customer::deleteRecordToHistory('groupid', $id, 'callshoprate'); $res = Customer::deleteRecordToHistory('groupid', $id, 'account'); $res = Customer::deleteRecordToHistory('id', $id, 'accountgroup'); } else { $res = Customer::deleteRecords('groupid', $id, 'clid'); $res = Customer::deleteRecords('groupid', $id, 'myrate'); $res = Customer::deleteRecords('groupid', $id, 'callshoprate'); $res = Customer::deleteRecords('groupid', $id, 'account'); $res = Customer::deleteRecord($id, 'accountgroup'); } if ($res) { $html = createGrid($searchFormValue['numRows'], $searchFormValue['limit'], $searchField, $searchContent, $searchField, $divName, "", $searchType); $objResponse = new xajaxResponse(); $objResponse->addAssign("msgZone", "innerHTML", $locate->Translate("delete_rec")); $objResponse->addClear("msgZone", "innerHTML"); $objResponse->addAssign($divName, "innerHTML", $html); } else { $objResponse->addAssign("msgZone", "innerHTML", $locate->Translate("rec_cannot_delete")); } } else { $html = createGrid($numRows, $limit, $searchField, $searchContent, $searchField, $divName, "", $searchType); $objResponse->addClear("msgZone", "innerHTML"); $objResponse->addAssign($divName, "innerHTML", $html); } return $objResponse->getXML(); }
function searchFormSubmit($searchFormValue, $numRows, $limit, $id, $type) { global $locate, $db, $config; $objResponse = new xajaxResponse(); $searchField = array(); $searchContent = array(); $optionFlag = $searchFormValue['optionFlag']; $searchContent = $searchFormValue['searchContent']; //搜索内容 数组 $searchField = $searchFormValue['searchField']; //搜索条件 数组 $searchType = $searchFormValue['searchType']; //搜索方式 数组 $divName = "grid"; if ($optionFlag == "export") { $sql = astercrm::getSql($searchContent, $searchField, $searchType, 'clid'); //得到要导出的sql语句 $_SESSION['export_sql'] = $sql; $objResponse->addAssign("hidSql", "value", $sql); //赋值隐含域 $objResponse->addScript("document.getElementById('exportForm').submit();"); } elseif ($optionFlag == "delete") { if (empty($_SESSION['curuser']['usertype'])) { $objResponse->addAlert($locate->Translate("Session time out,please try again")); return $objResponse->getXML(); } if ($_SESSION['curuser']['usertype'] == 'groupadmin') { $searchContent[] = $_SESSION['curuser']['groupid']; $searchField[] = 'groupid'; $searchType[] = 'equal'; } elseif ($_SESSION['curuser']['usertype'] == 'reseller') { $searchContent[] = $_SESSION['curuser']['resellerid']; $searchField[] = 'resellerid'; $searchType[] = 'equal'; } if ($config['synchronize']['delete_by_use_history']) { astercrm::deleteToHistoryFromSearch($searchContent, $searchField, $searchType, 'clid'); } else { astercrm::deletefromsearch($searchContent, $searchField, $searchType, 'clid'); } $html = createGrid($numRows, $limit, '', '', '', $divName, "", $searchType); $objResponse->addClear("msgZone", "innerHTML"); $objResponse->addAssign($divName, "innerHTML", $html); } elseif ($type == "delete") { if (empty($_SESSION['curuser']['usertype'])) { $objResponse->addAlert($locate->Translate("Session time out,please try again")); return $objResponse->getXML(); } if ($config['synchronize']['delete_by_use_history']) { $res = Customer::deleteRecordToHistory('id', $id, 'clid'); } else { $res = Customer::deleteRecord($id, 'clid'); } if ($res) { $html = createGrid($searchFormValue['numRows'], $searchFormValue['limit'], $searchField, $searchContent, $searchField, $divName, "", $searchType); $objResponse->addAssign("msgZone", "innerHTML", $locate->Translate("record deleted")); $objResponse->addAssign($divName, "innerHTML", $html); } else { $objResponse->addAssign("msgZone", "innerHTML", $locate->Translate("record cannot be deleted")); } } else { $html = createGrid($numRows, $limit, $searchField, $searchContent, $searchField, $divName, "", $searchType); $objResponse->addClear("msgZone", "innerHTML"); $objResponse->addAssign($divName, "innerHTML", $html); } return $objResponse->getXML(); }
function searchFormSubmit($searchFormValue, $numRows, $limit, $id, $type) { global $locate, $db; $objResponse = new xajaxResponse(); $searchField = array(); $searchContent = array(); $optionFlag = $searchFormValue['optionFlag']; $deleteFlag = $searchFormValue['deleteFlag']; $exportFlag = $searchFormValue['exportFlag']; $searchContent = $searchFormValue['searchContent']; //搜索内容 数组 $searchField = $searchFormValue['searchField']; //搜索条件 数组 $searchType = $searchFormValue['searchType']; //搜索方式 数组 $divName = "grid"; if ($exportFlag == "1" || $optionFlag == "export") { $sql = astercrm::getSql($searchContent, $searchField, $searchType, 'curcdr'); //得到要导出的sql语句 $_SESSION['export_sql'] = $sql; $objResponse->addAssign("hidSql", "value", $sql); //赋值隐含域 $objResponse->addScript("document.getElementById('exportForm').submit();"); } elseif ($deleteFlag == "1" || $optionFlag == "delete") { Customer::deleteFromSearch($searchContent, $searchField, $searchType, 'curcdr'); $html = createGrid($searchFormValue['numRows'], $searchFormValue['limit'], '', '', '', $divName, "", 1, $searchType); $objResponse->addClear("msgZone", "innerHTML"); $objResponse->addAssign($divName, "innerHTML", $html); } else { if ($type == "delete") { $res = Customer::deleteRecord($id, 'curcdr'); if ($res) { $html = createGrid($searchFormValue['numRows'], $searchFormValue['limit'], $searchField, $searchContent, $searchField, $divName, "", 1, $searchType); $objResponse->addAssign("msgZone", "innerHTML", $locate->Translate("record deleted")); } else { $objResponse->addAssign("msgZone", "innerHTML", $locate->Translate("record cannot be deleted")); } } else { $html = createGrid($numRows, $limit, $searchField, $searchContent, $searchField, $divName, "", 1, $searchType); } $objResponse->addClear("msgZone", "innerHTML"); $objResponse->addAssign($divName, "innerHTML", $html); } return $objResponse->getXML(); }
function searchFormSubmit($searchFormValue, $numRows = null, $limit = null, $id = null, $type = null) { global $locate, $db, $config; //根据后台设置导出的customer字段,来导出diallist关联的customer数据 $customerField = ''; if ($config['system']['export_customer_fields_in_dialedlist'] != '') { $relateCustomerFieldArr = explode(',', $config['system']['export_customer_fields_in_dialedlist']); foreach ($relateCustomerFieldArr as $tmp) { $customerField .= 'customer.' . $tmp . ','; } } $objResponse = new xajaxResponse(); $searchField = array(); $searchContent = array(); $optionFlag = $searchFormValue['optionFlag']; $exportFlag = $searchFormValue['exportFlag']; $searchContent = $searchFormValue['searchContent']; //搜索内容 数组 $searchField = $searchFormValue['searchField']; //搜索条件 数组 $searchType = $searchFormValue['searchType']; $ordering = $searchFormValue['ordering']; $order = $searchFormValue['order']; $divName = "grid"; if ($optionFlag == "export" || $optionFlag == "exportcsv") { $joinstr = astercrm::createSqlWithStype($searchField, $searchContent, $searchType, 'campaigndialedlist'); $joinstr = ltrim($joinstr, 'AND'); if ($customerField != '') { $sql = "SELECT campaigndialedlist.dialednumber,customer.customer,campaigndialedlist.customername,campaigndialedlist.dialtime,campaigndialedlist.answertime,campaigndialedlist.duration,campaigndialedlist.billsec,campaigndialedlist.billsec_leg_a as total_billsec,campaigndialedlist.campaignresult,campaigndialedlist.response,campaigndialedlist.detect,campaigndialedlist.transfertime,campaigndialedlist.transfertarget,campaigndialedlist.resultby,campaigndialedlist.dialedby, groupname, campaignname,campaigndialedlist.dialedtime," . rtrim($customerField, ',') . " FROM campaigndialedlist LEFT JOIN astercrm_accountgroup ON astercrm_accountgroup.groupid = campaigndialedlist.groupid LEFT JOIN campaign ON campaign.id = campaigndialedlist.campaignid LEFT JOIN customer ON customer.id = campaigndialedlist.customerid "; } else { $sql = "SELECT campaigndialedlist.dialednumber,customer.customer,campaigndialedlist.customername,campaigndialedlist.dialtime,campaigndialedlist.answertime,campaigndialedlist.duration,campaigndialedlist.billsec,campaigndialedlist.billsec_leg_a as total_billsec,campaigndialedlist.campaignresult,campaigndialedlist.response,campaigndialedlist.detect,campaigndialedlist.transfertime,campaigndialedlist.transfertarget,campaigndialedlist.resultby,campaigndialedlist.dialedby, groupname, campaignname,campaigndialedlist.dialedtime FROM campaigndialedlist LEFT JOIN astercrm_accountgroup ON astercrm_accountgroup.groupid = campaigndialedlist.groupid LEFT JOIN campaign ON campaign.id = campaigndialedlist.campaignid LEFT JOIN customer ON customer.id = campaigndialedlist.customerid "; } if ($joinstr != '') { $sql .= " WHERE " . $joinstr; } $_SESSION['export_sql'] = $sql; $objResponse->addAssign("hidSql", "value", $sql); //赋值隐含域 $objResponse->addAssign("maintable", "value", 'campaigndialedlist'); //赋值隐含域 $objResponse->addAssign("exporttype", "value", $optionFlag); $objResponse->addScript("document.getElementById('exportForm').submit();"); } elseif ($optionFlag == "delete") { astercrm::deletefromsearch($searchContent, $searchField, $searchType, 'campaigndialedlist'); $html = createGrid($searchFormValue['numRows'], $searchFormValue['limit'], '', '', '', $divName, "", ''); $objResponse->addClear("msgZone", "innerHTML"); $objResponse->addAssign($divName, "innerHTML", $html); } elseif ($optionFlag == "recycle") { $num = Customer::recyclefromsearch($searchContent, $searchField, $searchType, 'campaigndialedlist'); $html = createGrid($searchFormValue['numRows'], $searchFormValue['limit'], '', '', $order, $divName, $ordering, ''); $objResponse->addClear("msgZone", "innerHTML"); $objResponse->addALert($num . " " . $locate->Translate("number have been recycled")); $objResponse->addAssign($divName, "innerHTML", $html); $noanswer = Customer::getNoanswerCallsNumber(); $objResponse->addAssign("spanRecycleUp", "innerHTML", "No answer calls and never recycle: {$noanswer}"); $objResponse->addAssign("spanRecycleDown", "innerHTML", "No answer calls and never recycle: {$noanswer}"); } else { if ($type == "delete") { $res = Customer::deleteRecord($id, 'campaigndialedlist'); if ($res) { $html = createGrid($searchFormValue['numRows'], $searchFormValue['limit'], $searchField, $searchContent, $order, $divName, $ordering, $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, $searchType); } $objResponse->addClear("msgZone", "innerHTML"); $objResponse->addAssign($divName, "innerHTML", $html); } return $objResponse->getXML(); }
function searchFormSubmit($searchFormValue, $numRows = null, $limit = null, $id = null, $type = null, $order = '') { global $locate, $db; #print_r($searchFormValue);exit; $objResponse = new xajaxResponse(); $searchField = array(); $searchContent = array(); $searchType = array(); $optionFlag = $searchFormValue['optionFlag']; $searchContent = $searchFormValue['searchContent']; //搜索内容 数组 $searchField = $searchFormValue['searchField']; //搜索条件 数组 $searchType = $searchFormValue['searchType']; //搜索方式 数组 $ordering = $searchFormValue['ordering']; $order = $searchFormValue['order']; $divName = "grid"; $allOrAnswer = $searchFormValue['allOrAnswer']; #选中的radio值 if ($optionFlag == "export" || $optionFlag == "exportcsv") { $fieldArray = array('mycdr.*', 'astercrm_accountgroup.groupname', 'astercrm_account.username'); $leftjoinArray = array('astercrm_accountgroup' => array('astercrm_accountgroup.id', 'mycdr.astercrm_groupid'), 'astercrm_account' => array('astercrm_account.id', 'mycdr.accountid')); if ($searchFormValue['allOrAnswer'] == 'answered') { $searchContent[] = '0'; $searchField[] = 'billsec'; $searchType[] = 'more'; } $sql = astercrm::getSql($searchContent, $searchField, $searchType, 'mycdr', $fieldArray, $leftjoinArray); //得到要导出的sql语句 $_SESSION['export_sql'] = $sql; $objResponse->addAssign("hidSql", "value", $sql); //赋值隐含域 $objResponse->addAssign("exporttype", "value", $optionFlag); $objResponse->addScript("document.getElementById('exportForm').submit();"); } else { if ($type == "delete") { $res = Customer::deleteRecord($id, 'account'); if ($res) { $html = createGrid('', '', $searchFormValue['numRows'], $searchFormValue['limit'], $searchField, $searchContent, $order, $divName, $ordering, $searchType, $allOrAnswer); $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, $searchType, $allOrAnswer); } $objResponse->addClear("msgZone", "innerHTML"); $objResponse->addAssign($divName, "innerHTML", $html); } return $objResponse->getXML(); }
function searchFormSubmit($searchFormValue, $numRows = null, $limit = null, $id = null, $type = null) { global $locate, $db; $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']; $divName = "grid"; if ($optionFlag == "export" || $optionFlag == "exportcsv") { $fields = array(); $fields[] = 'campaignresult.id'; $fields[] = 'campaignresult.resultname'; $fields[] = 'campaignresult.resultnote'; $fields[] = 'campaignresult.status'; $fields[] = 'presult.resultname AS parentresult'; $fields[] = 'groupname'; $fields[] = 'campaignname'; $sql =& Customer::getRecordsFilteredMorewithstype('', '', $searchField, $searchContent, $searchType, $order, $table, $fields, 'export'); //得到要导出的sql语句 $_SESSION['export_sql'] = $sql; $objResponse->addAssign("hidSql", "value", $sql); //赋值隐含域 $objResponse->addAssign("exporttype", "value", $optionFlag); $objResponse->addScript("document.getElementById('exportForm').submit();"); } elseif ($type == "delete") { $res = Customer::deleteRecord($id, 'campaignresult'); if ($res) { $html = createGrid($searchFormValue['numRows'], $searchFormValue['limit'], $searchField, $searchContent, $order, $divName, $ordering, $searchType); $objResponse = new xajaxResponse(); $objResponse->addAssign("msgZone", "innerHTML", $locate->Translate("delete_rec")); $objResponse->addAssign($divName, "innerHTML", $html); } else { $objResponse->addAssign("msgZone", "innerHTML", $locate->Translate("rec_cannot_delete")); } } else { $html = createGrid($numRows, $limit, $searchField, $searchContent, $order, $divName, $ordering, $searchType); $objResponse->addClear("msgZone", "innerHTML"); $objResponse->addAssign($divName, "innerHTML", $html); } return $objResponse->getXML(); }
function searchFormSubmit($searchFormValue, $numRows = null, $limit = null, $id = null, $type = null) { global $locate, $db; $objResponse = new xajaxResponse(); $searchField = array(); $searchContent = array(); $optionFlag = $searchFormValue['optionFlag']; $exportFlag = $searchFormValue['exportFlag']; //导出标记 $searchContent = $searchFormValue['searchContent']; //搜索内容 数组 $searchField = $searchFormValue['searchField']; //搜索条件 数组 $searchType = $searchFormValue['searchType']; $ordering = $searchFormValue['ordering']; $order = $searchFormValue['order']; $divName = "grid"; if ($optionFlag == "export" || $optionFlag == "exportcsv") { //$sql = astercrm::getSql($searchContent,$searchField,$searchType,'contact'); //得到要导出的sql语句 $sql = astercrm::getSql($searchContent, $searchField, $searchType, 'contact', array('contact.*', 'note.note'), array('note' => array('contact.id', 'note.contactid'))); $_SESSION['export_sql'] = $sql; $objResponse->addAssign("hidSql", "value", $sql); //赋值隐含域 $objResponse->addAssign("exporttype", "value", $optionFlag); $objResponse->addAssign("maintable", "value", 'contact'); $objResponse->addScript("document.getElementById('exportForm').submit();"); } elseif ($optionFlag == "delete") { astercrm::deletefromsearch($searchContent, $searchField, $searchType, 'contact'); $html = createGrid($searchFormValue['numRows'], $searchFormValue['limit'], '', '', '', $divName, "", ''); $objResponse->addClear("msgZone", "innerHTML"); $objResponse->addAssign($divName, "innerHTML", $html); } else { if ($type == "delete") { $res = Customer::deleteRecord($id, 'contact'); if ($res) { $html = createGrid($searchFormValue['numRows'], $searchFormValue['limit'], $searchField, $searchContent, $order, $divName, $ordering, $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, $searchType); } $objResponse->addClear("msgZone", "innerHTML"); $objResponse->addAssign($divName, "innerHTML", $html); } return $objResponse->getXML(); }
function searchFormSubmit($searchFormValue, $numRows = null, $limit = null, $id = null, $type = null) { global $locate, $db; $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']; $divName = "grid"; if ($optionFlag == "export" || $optionFlag == "exportcsv") { $sql = astercrm::getSql($searchContent, $searchField, $searchType, 'astercrm_account'); //得到要导出的sql语句 $_SESSION['export_sql'] = $sql; $objResponse->addAssign("hidSql", "value", $sql); //赋值隐含域 $objResponse->addAssign("maintable", "value", 'astercrm_account'); //赋值隐含域 $objResponse->addAssign("exporttype", "value", $optionFlag); $objResponse->addScript("document.getElementById('exportForm').submit();"); } elseif ($optionFlag == "delete") { astercrm::deletefromsearch($searchContent, $searchField, $searchType, 'astercrm_account'); $html = createGrid($searchFormValue['numRows'], $searchFormValue['limit'], '', '', $order, $divName, $ordering, ''); $objResponse->addClear("msgZone", "innerHTML"); $objResponse->addAssign($divName, "innerHTML", $html); } elseif ($type == "delete") { $myrow = astercrm::getRecordByField('username', $_SESSION['curuser']['username'], 'astercrm_account'); $myid = $myrow['id']; //echo $myid;exit; if ($myid == $id) { $objResponse->addAlert($locate->Translate("Can not delete your own account")); return $objResponse->getXML(); } $res = Customer::deleteRecord($id, 'astercrm_account'); if ($res) { $html = createGrid($searchFormValue['numRows'], $searchFormValue['limit'], $searchField, $searchContent, $order, $divName, $ordering, $searchType); $objResponse = new xajaxResponse(); $objResponse->addAssign("msgZone", "innerHTML", $locate->Translate("delete_rec")); $objResponse->addAssign($divName, "innerHTML", $html); } else { $objResponse->addAssign("msgZone", "innerHTML", $locate->Translate("rec_cannot_delete")); } } else { $html = createGrid($numRows, $limit, $searchField, $searchContent, $order, $divName, $ordering, $searchType); $objResponse->addClear("msgZone", "innerHTML"); $objResponse->addAssign($divName, "innerHTML", $html); } return $objResponse->getXML(); }
function searchRecordsFormSubmit($searchFormValue, $numRows, $limit, $id = '', $type = '') { global $locate, $db; $objResponse = new xajaxResponse(); $searchField = array(); $searchContent = array(); $searchType = array(); $customerid = $searchFormValue['customerid']; $searchContent = $searchFormValue['searchContent']; //搜索内容 数组 $searchField = $searchFormValue['searchField']; //搜索条件 数组 $searchType = $searchFormValue['searchType']; //搜索方式 数组 $divName = "formRecords"; $html = Table::Top($locate->Translate("Monitors"), "formRecords"); if ($type == "delete") { $res = Customer::deleteRecord($id, 'account'); if ($res) { $html = Customer::createRecordsGrid($customerid, $searchFormValue['numRows'], $searchFormValue['limit'], $searchField, $searchContent, $searchField, $divName, ""); $objResponse = new xajaxResponse(); $objResponse->addAssign("msgZone", "innerHTML", $locate->Translate("delete_rec")); } else { $objResponse->addAssign("msgZone", "innerHTML", $locate->Translate("rec_cannot_delete")); } } else { $html .= Customer::createRecordsGrid($customerid, $numRows, $limit, $searchField, $searchContent, $searchField[count($searchField) - 1], $divName, "", $searchType); } $html .= Table::Footer(); $objResponse->addClear("msgZone", "innerHTML"); $objResponse->addAssign($divName, "innerHTML", $html); return $objResponse->getXML(); }
function searchFormSubmit($searchFormValue, $numRows = null, $limit = null, $id = null, $type = null) { global $locate, $db; $objResponse = new xajaxResponse(); $searchField = array(); $searchContent = array(); $optionFlag = $searchFormValue['optionFlag']; $exportFlag = $searchFormValue['exportFlag']; $searchContent = $searchFormValue['searchContent']; //搜索内容 数组 $searchField = $searchFormValue['searchField']; //搜索条件 数组 $divName = "grid"; $searchType = $searchFormValue['searchType']; $ordering = $searchFormValue['ordering']; $order = $searchFormValue['order']; if ($exportFlag == "1" || $optionFlag == "export") { // 需要特殊处理 // $sql = astercrm::getSql($searchContent,$searchField,$searchType,'surveyresult'); //得到要导出的sql语句 $joinstr = astercrm::createSqlWithStype($searchField, $searchContent, $searchType, 'surveyresult'); $objResponse->addAssign("hidSql", "value", $joinstr); //赋值隐含域 $objResponse->addScript("document.getElementById('exportForm').submit();"); } elseif ($optionFlag == "delete") { astercrm::deletefromsearch($searchContent, $searchField, $searchType, 'surveyresult'); $html = createGrid($searchFormValue['numRows'], $searchFormValue['limit'], '', '', $order, $divName, $ordering, 1, 1, ''); $objResponse->addClear("msgZone", "innerHTML"); $objResponse->addAssign($divName, "innerHTML", $html); } else { if ($type == "delete") { $res = Customer::deleteRecord($id, 'surveyresult'); if ($res) { $html = createGrid($searchFormValue['numRows'], $searchFormValue['limit'], $searchField, $searchContent, $order, $divName, $ordering, "", $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, "", $searchType); } $objResponse = new xajaxResponse(); $objResponse->addClear("msgZone", "innerHTML"); $objResponse->addAssign($divName, "innerHTML", $html); } return $objResponse->getXML(); }
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 searchFormSubmit($searchFormValue, $numRows, $limit, $id, $type) { global $locate, $db, $config; $objResponse = new xajaxResponse(); $searchField = array(); $searchContent = array(); $optionFlag = $searchFormValue['optionFlag']; $deleteFlag = $searchFormValue['deleteFlag']; $exportFlag = $searchFormValue['exportFlag']; $searchContent = $searchFormValue['searchContent']; //搜索内容 数组 $searchField = $searchFormValue['searchField']; //搜索条件 数组 $searchType = $searchFormValue['searchType']; //搜索方式 数组 $divName = "grid"; if ($exportFlag == "1" || $optionFlag == "export") { $sql = astercrm::getSql($searchContent, $searchField, $searchType, 'resellerrate'); //得到要导出的sql语句 $_SESSION['export_sql'] = $sql; $objResponse->addAssign("hidSql", "value", $sql); //赋值隐含域 $objResponse->addScript("document.getElementById('exportForm').submit();"); } elseif ($deleteFlag == "1" || $optionFlag == "delete") { if (empty($_SESSION['curuser']['usertype'])) { $objResponse->addAlert($locate->Translate("Session time out,please try again")); return $objResponse->getXML(); } if ($config['synchronize']['delete_by_use_history']) { astercrm::deleteToHistoryFromSearch($searchContent, $searchField, $searchType, 'resellerrate'); } else { astercrm::deletefromsearch($searchContent, $searchField, $searchType, 'resellerrate'); } $html = createGrid($searchFormValue['numRows'], $searchFormValue['limit'], '', '', '', $divName, "", 1, $searchType); $objResponse->addClear("msgZone", "innerHTML"); $objResponse->addAssign($divName, "innerHTML", $html); } elseif ($optionFlag == "multiEdit") { $html = createGrid($numRows, $limit, $searchField, $searchContent, $searchField, $divName, "", 1, 1, $searchType); $showMutiEdit = Table::Top($locate->Translate("Multi Edit"), "formDiv"); $showMutiEdit .= astercrm::formMutiEdit($searchContent, $searchField, $searchType, 'resellerrate'); $showMutiEdit .= Table::Footer(); $objResponse->addClear("msgZone", "innerHTML"); $objResponse->addAssign($divName, "innerHTML", $html); $objResponse->addAssign('formDiv', "innerHTML", $showMutiEdit); $objResponse->addAssign('formDiv', "style.visibility", 'visible'); } else { if ($type == "delete") { if (empty($_SESSION['curuser']['usertype'])) { $objResponse->addAlert($locate->Translate("Session time out,please try again")); return $objResponse->getXML(); } if ($config['synchronize']['delete_by_use_history']) { $res = Customer::deleteRecordToHistory('id', $id, 'resellerrate'); } else { $res = Customer::deleteRecord($id, 'resellerrate'); } if ($res) { $html = createGrid($searchFormValue['numRows'], $searchFormValue['limit'], $searchField, $searchContent, $searchField, $divName, "", 1, $searchType); $objResponse->addAssign("msgZone", "innerHTML", $locate->Translate("record deleted")); } else { $objResponse->addAssign("msgZone", "innerHTML", $locate->Translate("record cannot be deleted")); } } else { $html = createGrid($numRows, $limit, $searchField, $searchContent, $searchField, $divName, "", 1, $searchType); } $objResponse->addClear("msgZone", "innerHTML"); $objResponse->addAssign($divName, "innerHTML", $html); } return $objResponse->getXML(); }
function searchFormSubmit($searchFormValue, $numRows = null, $limit = null, $id = null, $type = null) { global $locate, $db; $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']; $divName = "grid"; if ($optionFlag == "export") { $sql = astercrm::getSql($searchContent, $searchField, $searchType, 'worktimes'); //得到要导出的sql语句 $_SESSION['export_sql'] = $sql; $objResponse->addAssign("hidSql", "value", $sql); //赋值隐含域 $objResponse->addScript("document.getElementById('exportForm').submit();"); } elseif ($type == "delete") { $row = Customer::getRecordByField('worktime_id', $id, 'worktimepackage_worktimes'); if ($row['id'] != '') { $objResponse->addAlert($locate->Translate("this worktime in one or more package, can not delete")); return $objResponse->getXML(); } $res = Customer::deleteRecord($id, 'worktimes'); if ($res) { $html = createGrid($searchFormValue['numRows'], $searchFormValue['limit'], $searchField, $searchContent, $order, $divName, $ordering, $searchType); $objResponse = new xajaxResponse(); $objResponse->addAssign("msgZone", "innerHTML", $locate->Translate("delete_rec")); $objResponse->addAssign($divName, "innerHTML", $html); } else { $objResponse->addAssign("msgZone", "innerHTML", $locate->Translate("rec_cannot_delete")); } } else { $html = createGrid($numRows, $limit, $searchField, $searchContent, $order, $divName, $ordering, $searchType); $objResponse->addClear("msgZone", "innerHTML"); $objResponse->addAssign($divName, "innerHTML", $html); } return $objResponse->getXML(); }
function searchFormSubmit($searchFormValue, $numRows = null, $limit = null, $id = null, $type = null) { global $locate, $db; $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']; $divName = "grid"; if ($optionFlag == "export" || $optionFlag == "exportcsv") { $sql = Customer::specialGetSql($searchContent, $searchField, $searchType, 'customer_leads', array('customer_leads.*', 'note_leads.note' => 'note', 'note_leads.codes' => 'codes', 'note_leads.creby' => 'last_note_created_by', 'note_leads.cretime' => 'noteLeadCsretime'), array('note_leads' => array('note_leads.id', 'customer_leads.last_note_id'))); //得到要导出的sql语句 $_SESSION['export_sql'] = $sql; $objResponse->addAssign("hidSql", "value", $sql); //赋值隐含域 $objResponse->addAssign("maintable", "value", 'customer_leads'); //赋值隐含域 $objResponse->addAssign("exporttype", "value", $optionFlag); $objResponse->addScript("document.getElementById('exportForm').submit();"); } if ($optionFlag == "delete") { $customer_ref =& Customer::getRecordsFilteredMorewithstype('', '', $searchField, $searchContent, $searchType, '', 'customer_leads', 'delete'); while ($customer_ref->fetchInto($row)) { Customer::deleteRecord($row['id'], 'customer_leads'); } $html = createGrid($searchFormValue['numRows'], $searchFormValue['limit'], '', '', $order, $divName, $ordering, ''); $objResponse->addClear("msgZone", "innerHTML"); $objResponse->addAssign($divName, "innerHTML", $html); } else { if ($type == "delete") { $res = Customer::deleteRecord($id, 'customer_leads'); 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(); }
/** * update account record * @param accountid int account id * @return objResponse object xajax response object */ function delete($id = null) { global $locate; $res = Customer::deleteRecord($accountid, 'astercrm_account'); if ($res) { $html = createGrid(0, ROWSXPAGE); $objResponse = new xajaxResponse(); $objResponse->addAssign("grid", "innerHTML", $html); $objResponse->addAssign("msgZone", "innerHTML", $locate->Translate("delete_rec")); } else { $objResponse->addAssign("msgZone", "innerHTML", $locate->Translate("rec_cannot_delete")); } return $objResponse->getXML(); }
function delTrunk($trunkid, $order, $rid = 0) { global $db; //echo $rid;exit; $objResponse = new xajaxResponse(); $trunk =& Customer::deleteRecord($trunkid, 'trunks'); if ($order == 1) { $objResponse->addAssign('trunkname1c', "innerHTML", ''); $objResponse->addAssign('routetype1', "value", 'auto'); $objResponse->addAssign('trunk1_id', "value", 0); $objResponse->addAssign('tmptrunk1id', "value", 0); if ($rid > 0) { $query = "UPDATE resellergroup SET trunk1_id = '0' WHERE id='{$rid}'"; $res =& $db->query($query); } } else { $objResponse->addAssign('trunkname2c', "innerHTML", ''); $objResponse->addAssign('routetype2', "value", 'auto'); $objResponse->addAssign('trunk2_id', "value", 0); $objResponse->addAssign('tmptrunk2id', "value", 0); if ($rid > 0) { $query = "UPDATE resellergroup SET trunk2_id = '0' WHERE id='{$rid}'"; $res =& $db->query($query); } } //print_r($trunk); //echo $trunkid;exit; $objResponse->addScript('document.getElementById(\'trunk\').style.display=\'none\''); return $objResponse; }