function createGrid($start = 0, $limit = 1, $filter = null, $content = null, $order = null, $divName = "grid", $ordering = "", $stype = array())
{
global $locate;
$_SESSION['ordering'] = $ordering;
if ($filter == null or $content == null or $content == 'Array' or $filter == 'Array') {
$numRows =& Customer::getNumRows();
$arreglo =& Customer::getAllRecords($start, $limit, $order);
$content = null;
$filter = null;
} else {
foreach ($content as $value) {
if (trim($value) != "") {
//搜索内容有值
$flag = "1";
break;
}
}
foreach ($filter as $value) {
if (trim($value) != "") {
//搜索条件有值
$flag2 = "1";
break;
}
}
foreach ($stype as $value) {
if (trim($value) != "") {
//搜索方式有值
$flag3 = "1";
break;
}
}
if ($flag != "1" || $flag2 != "1") {
//无值
if (is_array($order) || $order == '') {
$order = null;
}
$numRows =& Customer::getNumRows();
$arreglo =& Customer::getAllRecords($start, $limit, $order);
} elseif ($flag3 != 1) {
$order = "id";
$numRows =& Customer::getNumRowsMore($filter, $content, "diallist");
$arreglo =& Customer::getRecordsFilteredMore($start, $limit, $filter, $content, $order, "diallist");
} else {
$order = "id";
$numRows =& Customer::getNumRowsMorewithstype($filter, $content, $stype, $table);
$arreglo =& Customer::getRecordsFilteredMorewithstype($start, $limit, $filter, $content, $stype, $order, $table);
}
}
// Select Box: type table.
$typeFromSearch = array();
$typeFromSearch[] = 'like';
$typeFromSearch[] = 'equal';
$typeFromSearch[] = 'more';
$typeFromSearch[] = 'less';
// Selecct Box: Labels showed on searchtype select box.
$typeFromSearchShowAs = array();
$typeFromSearchShowAs[] = $locate->Translate("like");
$typeFromSearchShowAs[] = '=';
$typeFromSearchShowAs[] = '>';
$typeFromSearchShowAs[] = '<';
// Editable zone
// Databse Table: fields
$fields = array();
$fields[] = 'dialnumber';
$fields[] = 'customer';
$fields[] = 'assign';
$fields[] = 'dialtime';
$fields[] = 'groupname';
$fields[] = 'campaignname';
$fields[] = 'customername';
$fields[] = 'callOrder';
$fields[] = 'creby';
$fields[] = 'memo';
// HTML table: Headers showed
$headers = array();
$headers[] = $locate->Translate("ALL") . "<input type='checkbox' onclick=\"ckbAllOnClick(this);\"><BR \\>";
$headers[] = $locate->Translate("Number");
$headers[] = $locate->Translate("Customer");
$headers[] = $locate->Translate("Assign to");
$headers[] = $locate->Translate("Dialtime");
$headers[] = $locate->Translate("Group Name");
$headers[] = $locate->Translate("Campaign Name");
$headers[] = $locate->Translate("Name");
$headers[] = $locate->Translate("Call Order");
$headers[] = $locate->Translate("Create by");
$headers[] = $locate->Translate("Memo");
// HTML table: hearders attributes
$attribsHeader = array();
$attribsHeader[] = 'width="';
$attribsHeader[] = 'width=""';
$attribsHeader[] = 'width=""';
$attribsHeader[] = 'width=""';
$attribsHeader[] = 'width=""';
$attribsHeader[] = 'width=""';
$attribsHeader[] = 'width=""';
$attribsHeader[] = 'width=""';
$attribsHeader[] = 'width=""';
$attribsHeader[] = 'width=""';
$attribsHeader[] = 'width=""';
// HTML Table: columns attributes
$attribsCols = array();
$attribsCols[] = 'style="text-align: left"';
$attribsCols[] = 'style="text-align: left"';
$attribsCols[] = 'style="text-align: left"';
$attribsCols[] = 'style="text-align: left"';
$attribsCols[] = 'style="text-align: left"';
$attribsCols[] = 'style="text-align: left"';
$attribsCols[] = 'style="text-align: left"';
// HTML Table: If you want ascendent and descendent ordering, set the Header Events.
$eventHeader = array();
$eventHeader[] = '';
$eventHeader[] = 'onClick=\'xajax_showGrid(0,' . $limit . ',"' . $filter . '","' . $content . '","dialnumber","' . $divName . '","ORDERING");return false;\'';
$eventHeader[] = 'onClick=\'xajax_showGrid(0,' . $limit . ',"' . $filter . '","' . $content . '","customer","' . $divName . '","ORDERING");return false;\'';
$eventHeader[] = 'onClick=\'xajax_showGrid(0,' . $limit . ',"' . $filter . '","' . $content . '","assign","' . $divName . '","ORDERING");return false;\'';
$eventHeader[] = 'onClick=\'xajax_showGrid(0,' . $limit . ',"' . $filter . '","' . $content . '","dialtime","' . $divName . '","ORDERING");return false;\'';
$eventHeader[] = 'onClick=\'xajax_showGrid(0,' . $limit . ',"' . $filter . '","' . $content . '","groupname","' . $divName . '","ORDERING");return false;\'';
$eventHeader[] = 'onClick=\'xajax_showGrid(0,' . $limit . ',"' . $filter . '","' . $content . '","campaignname","' . $divName . '","ORDERING");return false;\'';
$eventHeader[] = 'onClick=\'xajax_showGrid(0,' . $limit . ',"' . $filter . '","' . $content . '","customername","' . $divName . '","ORDERING");return false;\'';
$eventHeader[] = 'onClick=\'xajax_showGrid(0,' . $limit . ',"' . $filter . '","' . $content . '","callOrder","' . $divName . '","ORDERING");return false;\'';
$eventHeader[] = 'onClick=\'xajax_showGrid(0,' . $limit . ',"' . $filter . '","' . $content . '","creby","' . $divName . '","ORDERING");return false;\'';
// Select Box: fields table.
$fieldsFromSearch = array();
$fieldsFromSearch[] = 'diallist.dialnumber';
$fieldsFromSearch[] = 'customer';
$fieldsFromSearch[] = 'diallist.assign';
$fieldsFromSearch[] = 'diallist.dialtime';
$fieldsFromSearch[] = 'groupname';
$fieldsFromSearch[] = 'campaignname';
$fieldsFromSearch[] = 'customername';
$fieldsFromSearch[] = 'diallist.cretime';
$fieldsFromSearch[] = 'diallist.creby';
// Selecct Box: Labels showed on search select box.
$fieldsFromSearchShowAs = array();
$fieldsFromSearchShowAs[] = $locate->Translate("number");
$fieldsFromSearchShowAs[] = $locate->Translate("Customer");
$fieldsFromSearchShowAs[] = $locate->Translate("assign_to");
$fieldsFromSearchShowAs[] = $locate->Translate("dialtime");
$fieldsFromSearchShowAs[] = $locate->Translate("Group Name");
$fieldsFromSearchShowAs[] = $locate->Translate("Campaign Name");
$fieldsFromSearchShowAs[] = $locate->Translate("Name");
$fieldsFromSearchShowAs[] = $locate->Translate("Create By");
// Create object whit 5 cols and all data arrays set before.
$table = new ScrollTable(6, $start, $limit, $filter, $numRows, $content, $order);
//$table->addRowSearch("diallist",$fieldsFromSearch,$fieldsFromSearchShowAs);
$table->exportFlag = '2';
//对导出标记进行赋值
$table->deleteFlag = '1';
//对删除标记进行赋值
$table->ordering = $ordering;
$editFlag = 1;
$deleteFlag = 1;
$delteBtnFlag = 1;
if ($_SESSION['curuser']['usertype'] != 'admin' && $_SESSION['curuser']['usertype'] != 'groupadmin') {
if ($_SESSION['curuser']['privileges']['diallist']['delete']) {
$deleteFlag = 1;
$delteBtnFlag = 1;
$table->deleteFlag = '1';
} else {
$deleteFlag = 0;
$delteBtnFlag = 0;
$table->deleteFlag = '0';
}
if ($_SESSION['curuser']['privileges']['diallist']['edit']) {
$editFlag = 1;
} else {
$editFlag = 0;
}
}
$table->setHeader('title', $headers, $attribsHeader, $eventHeader, $editFlag, $deleteFlag, 0);
$table->setAttribsCols($attribsCols);
$table->addRowSearchMore("diallist", $fieldsFromSearch, $fieldsFromSearchShowAs, $filter, $content, $start, $limit, 1, $delteBtnFlag, $typeFromSearch, $typeFromSearchShowAs, $stype);
while ($arreglo->fetchInto($row)) {
// Change here by the name of fields of its database table
$rowc = array();
$rowc[] = $row['id'];
$rowc['select_id'] = $row['id'];
$rowc[] = $row['dialnumber'];
$rowc[] = $row['customer'];
$rowc[] = $row['assign'];
$rowc[] = $row['dialtime'];
$rowc[] = $row['groupname'];
$rowc[] = $row['campaignname'];
$rowc[] = $row['customername'];
$rowc[] = $row['callOrder'];
$rowc[] = $row['creby'];
$rowc[] = $row['memo'];
$table->addRow("diallist", $rowc, $editFlag, $deleteFlag, 0, $divName, $fields);
}
// End Editable Zone
$html = $table->render('delGrid');
return $html;
}
/**
* generate grid HTML code
* @param start int record start
* @param limit int how many records need
* @param filter string the field need to search
* @param content string the contect want to match
* @param divName string which div grid want to be put
* @param order string data order
* @return html string grid HTML code
*/
function createGrid($start = 0, $limit = 1, $filter = null, $content = null, $order = null, $divName = "grid", $ordering = "", $stype = array())
{
global $locate, $config;
$_SESSION['ordering'] = $ordering;
if ($filter == null or $content == null || !is_array($content) && $content == 'Array' || !is_array(filter) && $filter == 'Array') {
$content = null;
$filter = null;
$numRows =& Customer::getNumRows();
$arreglo =& Customer::getAllRecords($start, $limit, $order);
} else {
foreach ($content as $value) {
if (trim($value) != "") {
//搜索内容有值
$flag = "1";
break;
}
}
foreach ($filter as $value) {
if (trim($value) != "") {
//搜索条件有值
$flag2 = "1";
break;
}
}
foreach ($stype as $value) {
if (trim($value) != "") {
//搜索方式有值
$flag3 = "1";
break;
}
}
if ($flag != "1" || $flag2 != "1") {
//无值
$order = null;
$numRows =& Customer::getNumRows();
$arreglo =& Customer::getAllRecords($start, $limit, $order);
} elseif ($flag3 != 1) {
$order = "id";
$numRows =& Customer::getNumRowsMore($filter, $content, "accountgroup");
$arreglo =& Customer::getRecordsFilteredMore($start, $limit, $filter, $content, $order, "accountgroup");
} else {
$order = "id";
$numRows =& Customer::getNumRowsMorewithstype($filter, $content, $stype, $table);
$arreglo =& Customer::getRecordsFilteredMorewithstype($start, $limit, $filter, $content, $stype, $order, $table);
}
}
// Select Box: type table.
$typeFromSearch = array();
$typeFromSearch[] = 'like';
$typeFromSearch[] = 'equal';
$typeFromSearch[] = 'more';
$typeFromSearch[] = 'less';
// Selecct Box: Labels showed on searchtype select box.
$typeFromSearchShowAs = array();
$typeFromSearchShowAs[] = $locate->Translate("like");
$typeFromSearchShowAs[] = '=';
$typeFromSearchShowAs[] = '>';
$typeFromSearchShowAs[] = '<';
// Editable zone
// Databse Table: fields
$fields = array();
$fields[] = 'id';
$fields[] = 'groupname';
$fields[] = 'resellername';
$fields[] = 'accountcode';
$fields[] = 'callback';
$fields[] = 'creditlimit';
$fields[] = 'limittype';
$fields[] = 'curcredit';
$fields[] = 'credit_clid';
$fields[] = 'credit_group';
$fields[] = 'credit_reseller';
$fields[] = 'group_multiple';
// HTML table: Headers showed
$headers = array();
$headers[] = $locate->Translate("ID") . '<br/>';
$headers[] = $locate->Translate("Name") . '<br/>';
$headers[] = $locate->Translate("Reseller") . '<br/>';
$headers[] = $locate->Translate("Callback") . '<br/>';
$headers[] = $locate->Translate("Credit Limit") . '<br/>';
$headers[] = $locate->Translate("Limit Type") . '<br/>';
$headers[] = $locate->Translate("Cur Credit") . '<br/>';
$headers[] = $locate->Translate("Clid Credit") . '<br/>';
$headers[] = $locate->Translate("Group Credit") . '<br/>';
$headers[] = $locate->Translate("Reseller Credit") . '<br/>';
$headers[] = $locate->Translate("Group Billsec Multiple") . '<br/>';
// HTML table: hearders attributes
$attribsHeader = array();
$attribsHeader[] = 'width=""';
$attribsHeader[] = 'width=""';
$attribsHeader[] = 'width=""';
$attribsHeader[] = 'width=""';
$attribsHeader[] = 'width=""';
$attribsHeader[] = 'width=""';
$attribsHeader[] = 'width=""';
$attribsHeader[] = 'width=""';
$attribsHeader[] = 'width=""';
$attribsHeader[] = 'width=""';
$attribsHeader[] = 'width=""';
// HTML Table: columns attributes
$attribsCols = array();
$attribsCols[] = 'style="text-align: left"';
$attribsCols[] = 'style="text-align: left"';
$attribsCols[] = 'style="text-align: left"';
$attribsCols[] = 'style="text-align: left"';
$attribsCols[] = 'style="text-align: left"';
$attribsCols[] = 'style="text-align: left"';
$attribsCols[] = 'style="text-align: left"';
$attribsCols[] = 'style="text-align: left"';
$attribsCols[] = 'style="text-align: left"';
$attribsCols[] = 'style="text-align: left"';
$attribsCols[] = 'style="text-align: left"';
// HTML Table: If you want ascendent and descendent ordering, set the Header Events.
$eventHeader = array();
$eventHeader[] = 'onClick=\'xajax_showGrid(0,' . $limit . ',"' . $filter . '","' . $content . '","id","' . $divName . '","ORDERING");return false;\'';
$eventHeader[] = 'onClick=\'xajax_showGrid(0,' . $limit . ',"' . $filter . '","' . $content . '","groupname","' . $divName . '","ORDERING");return false;\'';
$eventHeader[] = 'onClick=\'xajax_showGrid(0,' . $limit . ',"' . $filter . '","' . $content . '","resellername","' . $divName . '","ORDERING");return false;\'';
$eventHeader[] = 'onClick=\'xajax_showGrid(0,' . $limit . ',"' . $filter . '","' . $content . '","allowcallback","' . $divName . '","ORDERING");return false;\'';
$eventHeader[] = 'onClick=\'xajax_showGrid(0,' . $limit . ',"' . $filter . '","' . $content . '","creditlimit","' . $divName . '","ORDERING");return false;\'';
$eventHeader[] = 'onClick=\'xajax_showGrid(0,' . $limit . ',"' . $filter . '","' . $content . '","limittype","' . $divName . '","ORDERING");return false;\'';
$eventHeader[] = 'onClick=\'xajax_showGrid(0,' . $limit . ',"' . $filter . '","' . $content . '","curcredit","' . $divName . '","ORDERING");return false;\'';
$eventHeader[] = 'onClick=\'xajax_showGrid(0,' . $limit . ',"' . $filter . '","' . $content . '","credit_clid","' . $divName . '","ORDERING");return false;\'';
$eventHeader[] = 'onClick=\'xajax_showGrid(0,' . $limit . ',"' . $filter . '","' . $content . '","credit_group","' . $divName . '","ORDERING");return false;\'';
$eventHeader[] = 'onClick=\'xajax_showGrid(0,' . $limit . ',"' . $filter . '","' . $content . '","credit_reseller","' . $divName . '","ORDERING");return false;\'';
$eventHeader[] = 'onClick=\'xajax_showGrid(0,' . $limit . ',"' . $filter . '","' . $content . '","group_multiple","' . $divName . '","ORDERING");return false;\'';
// Select Box: fields table.
$fieldsFromSearch = array();
$fieldsFromSearch[] = 'groupname';
$fieldsFromSearch[] = 'resellername';
$fieldsFromSearch[] = 'accountgroup.accountcode';
$fieldsFromSearch[] = 'accountgroup.allowcallback';
$fieldsFromSearch[] = 'accountgroup.creditlimit';
$fieldsFromSearch[] = 'accountgroup.limittype';
$fieldsFromSearch[] = 'accountgroup.curcredit';
$fieldsFromSearch[] = 'accountgroup.credit_clid';
$fieldsFromSearch[] = 'accountgroup.credit_group';
$fieldsFromSearch[] = 'accountgroup.credit_reseller';
$fieldsFromSearch[] = 'accountgroup.group_multiple';
$fieldsFromSearch[] = 'accountgroup.customer_multiple';
$fieldsFromSearch[] = 'accountgroup.addtime';
// Selecct Box: Labels showed on search select box.
$fieldsFromSearchShowAs = array();
$fieldsFromSearchShowAs[] = $locate->Translate("Group Name");
$fieldsFromSearchShowAs[] = $locate->Translate("Reseller Name");
$fieldsFromSearchShowAs[] = $locate->Translate("Account Code");
$fieldsFromSearchShowAs[] = $locate->Translate("Callback");
$fieldsFromSearchShowAs[] = $locate->Translate("Credit Limit");
$fieldsFromSearchShowAs[] = $locate->Translate("Limit Type");
$fieldsFromSearchShowAs[] = $locate->Translate("Cur Credit");
$fieldsFromSearchShowAs[] = $locate->Translate("Clid Credit");
$fieldsFromSearchShowAs[] = $locate->Translate("Group Credit");
$fieldsFromSearchShowAs[] = $locate->Translate("Reseller Credit");
$fieldsFromSearchShowAs[] = $locate->Translate("Group Billsec Multiple");
$fieldsFromSearchShowAs[] = $locate->Translate("Customer Billsec Multiple");
$fieldsFromSearchShowAs[] = $locate->Translate("Last Update");
// Create object whit 5 cols and all data arrays set before.
$table = new ScrollTable(6, $start, $limit, $filter, $numRows, $content, $order);
$table->setHeader('title', $headers, $attribsHeader, $eventHeader, 1, 1, 0);
$table->setAttribsCols($attribsCols);
$table->exportFlag = '1';
//对导出标记进行赋值
$table->addRowSearchMore("accountgroup", $fieldsFromSearch, $fieldsFromSearchShowAs, $filter, $content, $start, $limit, 1, $typeFromSearch, $typeFromSearchShowAs, $stype);
if ($config['synchronize']['display_synchron_server']) {
$otherHost = $config['synchronize_host']['Host'];
$hostArray = explode(',', trim($otherHost, ','));
}
while ($arreglo->fetchInto($row)) {
// Change here by the name of fields of its database table
$rowc = array();
$rowc[] = $row['id'];
if ($config['synchronize']['display_synchron_server']) {
$existFlag = false;
foreach ($hostArray as $tmp) {
if ($row['id'] >= $config['synchronize_host'][$tmp . '_minId'] && $row['id'] <= $config['synchronize_host'][$tmp . '_maxId']) {
$rowc[] = $row['id'] . '(' . $config['synchronize_host'][$tmp] . ')';
$existFlag = true;
}
}
if (!$existFlag) {
$rowc[] = $row['id'] . '(' . $locate->Translate("Local") . ')';
}
} else {
$rowc[] = $row['id'];
}
$rowc[] = $row['groupname'];
$rowc[] = $row['resellername'];
$rowc[] = $row['allowcallback'];
$rowc[] = $row['creditlimit'];
$rowc[] = $row['limittype'];
$rowc[] = $row['curcredit'];
$rowc[] = $row['credit_clid'];
$rowc[] = $row['credit_group'];
$rowc[] = $row['credit_reseller'];
//astercc::readAmount($row['id'],null,$row['billingtime'],null,'callshopcredit');
$rowc[] = $row['group_multiple'];
if (!empty($row['limittype']) && $row['creditlimit'] - $row['curcredit'] < 0) {
//|| $row['curcredit'] < 0)
$trstyle = 'style="background-color:red;"';
} else {
$trstyle = '';
}
$table->addRow("accountgroup", $rowc, 1, 1, 0, $divName, $fields, $trstyle);
}
// End Editable Zone
$html = $table->render();
return $html;
}
/**
* generate grid HTML code
* @param start int record start
* @param limit int how many records need
* @param filter string the field need to search
* @param content string the contect want to match
* @param stype string the matching type for search
* @param divName string which div grid want to be put
* @param order string data order
* @return html string grid HTML code
*/
function createGrid($start = 0, $limit = 1, $filter = null, $content = null, $order = null, $divName = "grid", $ordering = "", $stype = array(), $customerid = '', $allOrAnswer = null)
{
global $locate, $config;
//print_R($filter);
//print_r($content);exit;
if ($config['system']['useHistoryCdr'] == 1) {
$table = 'historycdr';
} else {
$table = 'mycdr';
}
//echo $config['system']['useHistoryCdr'];
//echo $table;exit;
$_SESSION['ordering'] = $ordering;
if (is_numeric($customerid) && $customerid != 0 && $_SESSION['curuser']['usertype'] != 'clid') {
$filter['0'] = 'customerid';
$content['0'] = $customerid;
$stype['0'] = 'equal';
}
if ($filter == null || $content == null || !is_array($content) && $content == 'Array' || !is_array(filter) && $filter == 'Array') {
$content = null;
$filter = null;
$numRows =& Customer::getNumRows($table);
$arreglo =& Customer::getAllRecords($start, $limit, $order, '', $table);
} else {
foreach ($content as $value) {
if (trim($value) != "") {
//搜索内容有值
$flag = "1";
break;
}
}
foreach ($filter as $value) {
if (trim($value) != "") {
//搜索条件有值
$flag2 = "1";
break;
}
}
foreach ($stype as $value) {
if (trim($value) != "") {
//搜索方式有值
$flag3 = "1";
break;
}
}
if ($flag != "1" || $flag2 != "1") {
//无值
$order = null;
$numRows =& Customer::getNumRows($table, $allOrAnswer);
$arreglo =& Customer::getAllRecords($start, $limit, $order, '', $table, $allOrAnswer);
} elseif ($flag3 != 1) {
//未选择搜索方式
$order = "calldate";
$numRows =& Customer::getNumRowsMore($filter, $content, $table, $allOrAnswer);
$arreglo =& Customer::getRecordsFilteredMore($start, $limit, $filter, $content, $order, $table, '', $allOrAnswer);
} else {
$order = "calldate";
$numRows =& Customer::getNumRowsMorewithstype($filter, $content, $stype, $table, $allOrAnswer);
$arreglo =& Customer::getRecordsFilteredMorewithstype($start, $limit, $filter, $content, $stype, $order, $table, '', $allOrAnswer);
}
}
// Editable zone
// Databse Table: fields
$fields = array();
$fields[] = 'calldate';
$fields[] = 'src';
$fields[] = 'dst';
$fields[] = 'duration';
$fields[] = 'billsec';
$fields[] = 'disposition';
$fields[] = 'credit';
$fileds[] = 'destination';
$fileds[] = 'memo';
$fileds[] = 'discount';
$fileds[] = 'note';
// HTML table: Headers showed
$headers = array();
$headers[] = $locate->Translate("Calldate");
$headers[] = $locate->Translate("Src");
$headers[] = $locate->Translate("Dst");
$headers[] = $locate->Translate("Duration");
$headers[] = $locate->Translate("Billsec");
$headers[] = $locate->Translate("Disposition");
$headers[] = $locate->Translate("credit");
$headers[] = $locate->Translate("destination");
$headers[] = $locate->Translate("memo");
$headers[] = $locate->Translate("discount");
$headers[] = $locate->Translate("note");
// HTML table: hearders attributes
$attribsHeader = array();
$attribsHeader[] = 'width="13%"';
$attribsHeader[] = 'width="10%"';
$attribsHeader[] = 'width="13%"';
$attribsHeader[] = 'width="10%"';
$attribsHeader[] = 'width="10%"';
$attribsHeader[] = 'width="12%"';
$attribsHeader[] = 'width="10%"';
$attribsHeader[] = 'width="12%"';
$attribsHeader[] = 'width="10%"';
$attribsHeader[] = 'width="10%"';
// HTML Table: columns attributes
$attribsCols = array();
$attribsCols[] = 'style="text-align: left"';
$attribsCols[] = 'style="text-align: left"';
$attribsCols[] = 'style="text-align: left"';
$attribsCols[] = 'style="text-align: left"';
$attribsCols[] = 'style="text-align: left"';
$attribsCols[] = 'style="text-align: left"';
$attribsCols[] = 'style="text-align: left"';
$attribsCols[] = 'style="text-align: left"';
$attribsCols[] = 'style="text-align: left"';
$attribsCols[] = 'style="text-align: left"';
// HTML Table: If you want ascendent and descendent ordering, set the Header Events.
$eventHeader = array();
$eventHeader[] = 'onClick=\'xajax_showGrid(0,' . $limit . ',"' . $filter . '","' . $content . '","calldate","' . $divName . '","ORDERING","' . $stype . '");return false;\'';
$eventHeader[] = 'onClick=\'xajax_showGrid(0,' . $limit . ',"' . $filter . '","' . $content . '","src","' . $divName . '","ORDERING","' . $stype . '");return false;\'';
$eventHeader[] = 'onClick=\'xajax_showGrid(0,' . $limit . ',"' . $filter . '","' . $content . '","dst","' . $divName . '","ORDERING","' . $stype . '");return false;\'';
$eventHeader[] = 'onClick=\'xajax_showGrid(0,' . $limit . ',"' . $filter . '","' . $content . '","duration","' . $divName . '","ORDERING");return false;\'';
$eventHeader[] = 'onClick=\'xajax_showGrid(0,' . $limit . ',"' . $filter . '","' . $content . '","billsec","' . $divName . '","ORDERING","' . $stype . '");return false;\'';
$eventHeader[] = 'onClick=\'xajax_showGrid(0,' . $limit . ',"' . $filter . '","' . $content . '","disposition","' . $divName . '","ORDERING","' . $stype . '");return false;\'';
$eventHeader[] = 'onClick=\'xajax_showGrid(0,' . $limit . ',"' . $filter . '","' . $content . '","credit","' . $divName . '","ORDERING","' . $stype . '");return false;\'';
$eventHeader[] = 'onClick=\'xajax_showGrid(0,' . $limit . ',"' . $filter . '","' . $content . '","destination","' . $divName . '","ORDERING","' . $stype . '");return false;\'';
$eventHeader[] = 'onClick=\'xajax_showGrid(0,' . $limit . ',"' . $filter . '","' . $content . '","memo","' . $divName . '","ORDERING","' . $stype . '");return false;\'';
$eventHeader[] = 'onClick=\'xajax_showGrid(0,' . $limit . ',"' . $filter . '","' . $content . '","discount","' . $divName . '","ORDERING","' . $stype . '");return false;\'';
$eventHeader[] = '';
// Select Box: type table.
$typeFromSearch = array();
$typeFromSearch[] = 'like';
$typeFromSearch[] = 'equal';
$typeFromSearch[] = 'more';
$typeFromSearch[] = 'less';
// Selecct Box: Labels showed on searchtype select box.
$typeFromSearchShowAs = array();
$typeFromSearchShowAs[] = $locate->Translate("like");
$typeFromSearchShowAs[] = '=';
$typeFromSearchShowAs[] = '>';
$typeFromSearchShowAs[] = '<';
// Select Box: fields table.
$fieldsFromSearch = array();
$fieldsFromSearch[] = 'src';
$fieldsFromSearch[] = 'calldate';
$fieldsFromSearch[] = 'dst';
$fieldsFromSearch[] = 'billsec';
$fieldsFromSearch[] = 'disposition';
$fieldsFromSearch[] = 'credit';
$fieldsFromSearch[] = 'destination';
$fieldsFromSearch[] = 'customerid';
$fieldsFromSearch[] = 'memo';
$fieldsFromSearch[] = 'discount';
// Selecct Box: Labels showed on search select box.
$fieldsFromSearchShowAs = array();
$fieldsFromSearchShowAs[] = $locate->Translate("src");
$fieldsFromSearchShowAs[] = $locate->Translate("calldate");
$fieldsFromSearchShowAs[] = $locate->Translate("dst");
$fieldsFromSearchShowAs[] = $locate->Translate("billsec");
$fieldsFromSearchShowAs[] = $locate->Translate("disposition");
$fieldsFromSearchShowAs[] = $locate->Translate("credit");
$fieldsFromSearchShowAs[] = $locate->Translate("destination");
$fieldsFromSearchShowAs[] = $locate->Translate("customer id");
$fieldsFromSearchShowAs[] = $locate->Translate("memo");
$fieldsFromSearchShowAs[] = $locate->Translate("discount");
// Create object whit 5 cols and all data arrays set before.
$specArchive = false;
if ($_SESSION['curuser']['usertype'] == 'admin') {
$specArchive = 1;
}
$tableGrid = new ScrollTable(9, $start, $limit, $filter, $numRows, $content, $order, $specArchive);
$tableGrid->setHeader('title', $headers, $attribsHeader, $eventHeader, $edit = false, $delete = false, $detail = false);
$tableGrid->setAttribsCols($attribsCols);
$tableGrid->exportFlag = '1';
//对导出标记进行赋值
if ($_SESSION['curuser']['usertype'] == 'admin') {
$tableGrid->deleteFlag = '1';
//对导出标记进行赋值
}
$tableGrid->addRowSearchMore($table, $fieldsFromSearch, $fieldsFromSearchShowAs, $filter, $content, $start, $limit, 0, $typeFromSearch, $typeFromSearchShowAs, $stype, '', $allOrAnswer);
while ($arreglo->fetchInto($row)) {
// Change here by the name of fields of its database table
$rowc = array();
$trstyle = '';
$rowc[] = $row['id'];
$rowc[] = $row['calldate'];
$rowc[] = $row['src'];
$rowc[] = $row['dst'];
$rowc[] = astercrm::FormatSec($row['duration']);
$rowc[] = astercrm::FormatSec($row['billsec']);
$rowc[] = $row['disposition'];
$rowc[] = $row['credit'];
$rowc[] = $row['destination'];
$rowc[] = $row['memo'];
$rowc[] = $row['discount'];
$rowc[] = $row['note'];
if ($row['userfield'] == 'UNBILLED') {
$trstyle = 'style="background:#EED5D2;"';
}
if ($row['setfreecall'] == 'yes') {
$trstyle = 'style="background:#d5c59f;"';
}
$tableGrid->addRow($table, $rowc, false, false, false, $divName, $fields, $trstyle);
}
// End Editable Zone
$html = $tableGrid->render();
return $html;
}
/**
* generate grid HTML code
* @param start int record start
* @param limit int how many records need
* @param filter string the field need to search
* @param content string the contect want to match
* @param divName string which div grid want to be put
* @param order string data order
* @return html string grid HTML code
*/
function createGrid($start = 0, $limit = 1, $filter = null, $content = null, $order = null, $divName = "grid", $ordering = "", $exportFlag = "", $stype = array())
{
global $locate;
$_SESSION['ordering'] = $ordering;
if ($filter == null or $content == null || !is_array($content) && $content == 'Array' || !is_array(filter) && $filter == 'Array') {
$content = null;
$filter = null;
$numRows =& Customer::getNumRows();
$arreglo =& Customer::getAllRecords($start, $limit, $order);
} else {
foreach ($content as $value) {
if (trim($value) != "") {
//搜索内容有值
$flag = "1";
break;
}
}
foreach ($filter as $value) {
if (trim($value) != "") {
//搜索条件有值
$flag2 = "1";
break;
}
}
foreach ($stype as $value) {
if (trim($value) != "") {
//搜索方式有值
$flag3 = "1";
break;
}
}
if ($flag != "1" || $flag2 != "1") {
//无值
$order = null;
$numRows =& Customer::getNumRows();
$arreglo =& Customer::getAllRecords($start, $limit, $order);
} elseif ($flag3 != 1) {
$order = "id";
$numRows =& Customer::getNumRowsMore($filter, $content, "curcdr");
$arreglo =& Customer::getRecordsFilteredMore($start, $limit, $filter, $content, $order, "curcdr");
} else {
$order = "id";
$numRows =& Customer::getNumRowsMorewithstype($filter, $content, $stype, $table);
$arreglo =& Customer::getRecordsFilteredMorewithstype($start, $limit, $filter, $content, $stype, $order, $table);
}
}
// Select Box: type table.
$typeFromSearch = array();
$typeFromSearch[] = 'like';
$typeFromSearch[] = 'equal';
$typeFromSearch[] = 'more';
$typeFromSearch[] = 'less';
// Selecct Box: Labels showed on searchtype select box.
$typeFromSearchShowAs = array();
$typeFromSearchShowAs[] = $locate->Translate("like");
$typeFromSearchShowAs[] = '=';
$typeFromSearchShowAs[] = '>';
$typeFromSearchShowAs[] = '<';
// Editable zone
// Databse Table: fields
$fields = array();
$fields[] = 'curcdr.src';
$fields[] = 'curcdr.dst';
$fields[] = 'curcdr.srcname';
$fields[] = 'curcdr.starttime';
$fields[] = 'curcdr.answertime';
//$fields[] = 'clid.clid';
$fields[] = 'accountgroup.groupname';
$fields[] = 'resellergroup.resellername';
// HTML table: Headers showed
$headers = array();
$headers[] = $locate->Translate("Src") . '<br>';
$headers[] = $locate->Translate("Dst") . '<br>';
$headers[] = $locate->Translate("Srcname") . '<br>';
$headers[] = $locate->Translate("Starttime") . '<br>';
$headers[] = $locate->Translate("Answertime") . '<br>';
//$headers[] = $locate->Translate("Clid").'<br>';
$headers[] = $locate->Translate("Groupname") . '<br>';
$headers[] = $locate->Translate("Resellername") . '<br>';
// HTML table: fieldsFromSearch showed
$fieldsFromSearch = array();
$fieldsFromSearch[] = 'curcdr.src';
$fieldsFromSearch[] = 'curcdr.dst';
$fieldsFromSearch[] = 'curcdr.srcname';
$fieldsFromSearch[] = 'curcdr.starttime';
$fieldsFromSearch[] = 'curcdr.answertime';
//$fieldsFromSearch[] = 'clid.clid';
$fieldsFromSearch[] = 'accountgroup.groupname';
$fieldsFromSearch[] = 'resellergroup.resellername';
// HTML table: hearders attributes
$attribsHeader = array();
$attribsHeader[] = 'width=""';
$attribsHeader[] = 'width=""';
$attribsHeader[] = 'width=""';
$attribsHeader[] = 'width=""';
$attribsHeader[] = 'width=""';
$attribsHeader[] = 'width=""';
$attribsHeader[] = 'width=""';
$attribsHeader[] = 'width=""';
// HTML Table: columns attributes
$attribsCols = array();
$attribsCols[] = 'style="text-align: left"';
$attribsCols[] = 'style="text-align: left"';
$attribsCols[] = 'style="text-align: left"';
$attribsCols[] = 'style="text-align: left"';
$attribsCols[] = 'style="text-align: left"';
$attribsCols[] = 'style="text-align: left"';
$attribsCols[] = 'style="text-align: left"';
$attribsCols[] = 'style="text-align: left"';
// HTML Table: If you want ascendent and descendent ordering, set the Header Events.
$eventHeader = array();
$eventHeader[] = 'onClick=\'xajax_showGrid(0,' . $limit . ',"' . $filter . '","' . $content . '","curcdr.src","' . $divName . '","ORDERING");return false;\'';
$eventHeader[] = 'onClick=\'xajax_showGrid(0,' . $limit . ',"' . $filter . '","' . $content . '","curcdr.dst","' . $divName . '","ORDERING");return false;\'';
$eventHeader[] = 'onClick=\'xajax_showGrid(0,' . $limit . ',"' . $filter . '","' . $content . '","curcdr.srcname","' . $divName . '","ORDERING");return false;\'';
$eventHeader[] = 'onClick=\'xajax_showGrid(0,' . $limit . ',"' . $filter . '","' . $content . '","curcdr.starttime","' . $divName . '","ORDERING");return false;\'';
$eventHeader[] = 'onClick=\'xajax_showGrid(0,' . $limit . ',"' . $filter . '","' . $content . '","curcdr.answertime","' . $divName . '","ORDERING");return false;\'';
//$eventHeader[]= 'onClick=\'xajax_showGrid(0,'.$limit.',"'.$filter.'","'.$content.'","clid.clid","'.$divName.'","ORDERING");return false;\'';
$eventHeader[] = 'onClick=\'xajax_showGrid(0,' . $limit . ',"' . $filter . '","' . $content . '","accountgroup.groupname","' . $divName . '","ORDERING");return false;\'';
$eventHeader[] = 'onClick=\'xajax_showGrid(0,' . $limit . ',"' . $filter . '","' . $content . '","resellergroup.resellername","' . $divName . '","ORDERING");return false;\'';
// Select Box: fields table.
$fieldsFromSearch = array();
$fieldsFromSearch[] = 'curcdr.src';
$fieldsFromSearch[] = 'curcdr.dst';
$fieldsFromSearch[] = 'curcdr.srcname';
$fieldsFromSearch[] = 'curcdr.starttime';
$fieldsFromSearch[] = 'curcdr.answertime';
//$fieldsFromSearch[] = 'clid.clid';
$fieldsFromSearch[] = 'accountgroup.groupname';
$fieldsFromSearch[] = 'resellergroup.resellername';
// Selecct Box: Labels showed on search select box.
$fieldsFromSearchShowAs = array();
$fieldsFromSearchShowAs[] = $locate->Translate("Src");
$fieldsFromSearchShowAs[] = $locate->Translate("Dst");
$fieldsFromSearchShowAs[] = $locate->Translate("Srcname");
$fieldsFromSearchShowAs[] = $locate->Translate("Starttime");
$fieldsFromSearchShowAs[] = $locate->Translate("Answertime");
//$fieldsFromSearchShowAs[] = $locate->Translate("Clid");
$fieldsFromSearchShowAs[] = $locate->Translate("Groupname");
$fieldsFromSearchShowAs[] = $locate->Translate("Resellername");
// Create object whit 5 cols and all data arrays set before.
$table = new ScrollTable(6, $start, $limit, $filter, $numRows, $content, $order);
$table->setHeader('title', $headers, $attribsHeader, $eventHeader, 0, 1, 0);
$table->setAttribsCols($attribsCols);
$table->deleteFlag = '1';
//对导出标记进行赋值
$table->exportFlag = '0';
//对导出标记进行赋值
$table->multiEditFlag = '0';
//对批量修改标记进行赋值
$table->addRowSearchMore("curcdr", $fieldsFromSearch, $fieldsFromSearchShowAs, $filter, $content, $start, $limit, 0, $typeFromSearch, $typeFromSearchShowAs, $stype);
while ($arreglo->fetchInto($row)) {
// Change here by the name of fields of its database table
$rowc = array();
$rowc[] = $row['id'];
$rowc[] = $row['src'];
$rowc[] = $row['dst'];
$rowc[] = $row['srcname'];
$rowc[] = $row['starttime'];
$rowc[] = $row['answertime'];
//$rowc[] = $row['clid'];
$rowc[] = $row['groupname'];
$rowc[] = $row['resellername'];
$table->addRow("curcdr", $rowc, 0, 1, 0, $divName, $fields);
}
// End Editable Zone
$html = $table->render();
return $html;
}
/**
* generate grid HTML code
* @param start int record start
* @param limit int how many records need
* @param filter string the field need to search
* @param content string the contect want to match
* @param divName string which div grid want to be put
* @param order string data order
* @return html string grid HTML code
*/
function createGrid($start = 0, $limit = 1, $filter = null, $content = null, $order = null, $divName = "grid", $ordering = "", $exportFlag = "", $stype = array())
{
global $locate, $config;
//echo $ordering.$order;exit;
$_SESSION['ordering'] = $ordering;
if ($filter == null or $content == null or $content == 'Array' or $filter == 'Array') {
$numRows =& Customer::getNumRows();
$arreglo =& Customer::getAllRecords($start, $limit, $order);
$content = null;
$filter = null;
} else {
foreach ($content as $value) {
if (trim($value) != "") {
//搜索内容有值
$flag = "1";
break;
}
}
foreach ($filter as $value) {
if (trim($value) != "") {
//搜索条件有值
$flag2 = "1";
break;
}
}
foreach ($stype as $value) {
if (trim($value) != "") {
//搜索方式有值
$flag3 = "1";
break;
}
}
if ($flag != "1" || $flag2 != "1") {
//无值
$numRows =& Customer::getNumRows();
$arreglo =& Customer::getAllRecords($start, $limit, $order);
} elseif ($flag3 != 1) {
$order = "id";
$numRows =& Customer::getNumRowsMore($filter, $content, "customer_leads");
$arreglo =& Customer::getRecordsFilteredMore($start, $limit, $filter, $content, $order, "customer_leads");
} else {
$order = "id";
$numRows =& Customer::getNumRowsMorewithstype($filter, $content, $stype, $table);
$arreglo =& Customer::getRecordsFilteredMorewithstype($start, $limit, $filter, $content, $stype, $order, $table);
}
}
// Select Box: type table.
$typeFromSearch = array();
$typeFromSearch[] = 'like';
$typeFromSearch[] = 'equal';
$typeFromSearch[] = 'more';
$typeFromSearch[] = 'less';
// Selecct Box: Labels showed on searchtype select box.
$typeFromSearchShowAs = array();
$typeFromSearchShowAs[] = $locate->Translate("like");
$typeFromSearchShowAs[] = '=';
$typeFromSearchShowAs[] = '>';
$typeFromSearchShowAs[] = '<';
// Editable zone
// Databse Table: fields
$fields = array();
$fields[] = 'customer';
$fields[] = 'state';
if ($config['system']['enable_code']) {
$fields[] = 'note';
$fields[] = 'codes';
$fields[] = 'note_leads.cretime';
}
$fields[] = 'city';
$fields[] = 'phone';
$fields[] = 'contact';
$fields[] = 'website';
$fields[] = 'category';
$fields[] = 'cretime';
$fields[] = 'creby';
// HTML table: Headers showed
$headers = array();
$headers[] = $locate->Translate("ALL") . "<input type='checkbox' onclick=\"ckbAllOnClick(this);\"><BR \\>";
//"select all for delete";
$headers[] = $locate->Translate("customer_name") . "<BR \\>";
//"Customer Name";
$headers[] = $locate->Translate("state") . "<BR \\>";
//"state";
if ($config['system']['enable_code']) {
$headers[] = $locate->Translate("note") . "<BR \\>";
$headers[] = $locate->Translate("codes") . "<BR \\>";
$headers[] = $locate->Translate("note_cretime") . "<BR \\>";
}
$headers[] = $locate->Translate("city") . "<BR \\>";
//"Category";
$headers[] = $locate->Translate("phone") . "<BR \\>";
//"Contact";
$headers[] = $locate->Translate("contact") . "<BR \\>";
//"Category";
$headers[] = $locate->Translate("website") . "<BR \\>";
//"Note";
$headers[] = $locate->Translate("category") . "<BR \\>";
//"Create Time";
$headers[] = $locate->Translate("create_time") . "<BR \\>";
//"Create By";
$headers[] = $locate->Translate("create_by") . "<BR \\>";
// HTML table: hearders attributes
$attribsHeader = array();
$attribsHeader[] = 'width="5%"';
$attribsHeader[] = 'width="12%"';
$attribsHeader[] = 'width="8%"';
if ($config['system']['enable_code']) {
$attribsHeader[] = 'width="8%"';
$attribsHeader[] = 'width="8%"';
}
$attribsHeader[] = 'width="7%"';
$attribsHeader[] = 'width="8%"';
$attribsHeader[] = 'width="10%"';
$attribsHeader[] = 'width="10%"';
$attribsHeader[] = 'width="12%"';
$attribsHeader[] = 'width="8%"';
$attribsHeader[] = 'width="9%"';
$attribsHeader[] = 'width="7%"';
// $attribsHeader[] = 'width="5%"';
// HTML Table: columns attributes
$attribsCols = array();
$attribsCols[] = 'style="text-align: left"';
$attribsCols[] = 'style="text-align: left"';
if ($config['system']['enable_code']) {
$attribsCols[] = 'style="text-align: left"';
$attribsCols[] = 'style="text-align: left"';
}
$attribsCols[] = 'style="text-align: left"';
$attribsCols[] = 'style="text-align: left"';
$attribsCols[] = 'style="text-align: left"';
$attribsCols[] = 'nowrap style="text-align: left"';
$attribsCols[] = 'style="text-align: left"';
$attribsCols[] = 'style="text-align: left"';
$attribsCols[] = 'style="text-align: left"';
// HTML Table: If you want ascendent and descendent ordering, set the Header Events.
$eventHeader = array();
$eventHeader[] = '';
$eventHeader[] = 'onClick=\'xajax_showGrid(0,' . $limit . ',"' . $filter . '","' . $content . '","customer","' . $divName . '","ORDERING");return false;\'';
$eventHeader[] = 'onClick=\'xajax_showGrid(0,' . $limit . ',"' . $filter . '","' . $content . '","state","' . $divName . '","ORDERING");return false;\'';
if ($config['system']['enable_code']) {
$eventHeader[] = 'onClick=\'xajax_showGrid(0,' . $limit . ',"' . $filter . '","' . $content . '","note","' . $divName . '","ORDERING");return false;\'';
$eventHeader[] = 'onClick=\'xajax_showGrid(0,' . $limit . ',"' . $filter . '","' . $content . '","codes","' . $divName . '","ORDERING");return false;\'';
$eventHeader[] = 'onClick=\'xajax_showGrid(0,' . $limit . ',"' . $filter . '","' . $content . '","noteCretime","' . $divName . '","ORDERING");return false;\'';
}
$eventHeader[] = 'onClick=\'xajax_showGrid(0,' . $limit . ',"' . $filter . '","' . $content . '","city","' . $divName . '","ORDERING");return false;\'';
$eventHeader[] = 'onClick=\'xajax_showGrid(0,' . $limit . ',"' . $filter . '","' . $content . '","phone","' . $divName . '","ORDERING");return false;\'';
$eventHeader[] = 'onClick=\'xajax_showGrid(0,' . $limit . ',"' . $filter . '","' . $content . '","contact","' . $divName . '","ORDERING");return false;\'';
$eventHeader[] = 'onClick=\'xajax_showGrid(0,' . $limit . ',"' . $filter . '","' . $content . '","website","' . $divName . '","ORDERING");return false;\'';
$eventHeader[] = 'onClick=\'xajax_showGrid(0,' . $limit . ',"' . $filter . '","' . $content . '","category","' . $divName . '","ORDERING");return false;\'';
$eventHeader[] = 'onClick=\'xajax_showGrid(0,' . $limit . ',"' . $filter . '","' . $content . '","customer_leads.cretime","' . $divName . '","ORDERING");return false;\'';
$eventHeader[] = 'onClick=\'xajax_showGrid(0,' . $limit . ',"' . $filter . '","' . $content . '","customer_leads.creby","' . $divName . '","ORDERING");return false;\'';
// Select Box: fields table.
$fieldsFromSearch = array();
$fieldsFromSearch[] = 'customer';
$fieldsFromSearch[] = 'state';
if ($config['system']['enable_code']) {
$fieldsFromSearch[] = 'note';
$fieldsFromSearch[] = 'codes';
$fieldsFromSearch[] = 'note_leads.cretime';
}
$fieldsFromSearch[] = 'city';
$fieldsFromSearch[] = 'phone';
$fieldsFromSearch[] = 'fax';
$fieldsFromSearch[] = 'contact';
$fieldsFromSearch[] = 'website';
$fieldsFromSearch[] = 'category';
$fieldsFromSearch[] = 'customer_leads.cretime';
$fieldsFromSearch[] = 'customer_leads.creby';
// Selecct Box: Labels showed on search select box.
$fieldsFromSearchShowAs = array();
$fieldsFromSearchShowAs[] = $locate->Translate("customer_name");
$fieldsFromSearchShowAs[] = $locate->Translate("state");
if ($config['system']['enable_code']) {
$fieldsFromSearchShowAs[] = $locate->Translate("note");
$fieldsFromSearchShowAs[] = $locate->Translate("codes");
$fieldsFromSearchShowAs[] = $locate->Translate("note_cretime");
}
$fieldsFromSearchShowAs[] = $locate->Translate("city");
$fieldsFromSearchShowAs[] = $locate->Translate("phone");
$fieldsFromSearchShowAs[] = $locate->Translate("fax");
$fieldsFromSearchShowAs[] = $locate->Translate("contact");
$fieldsFromSearchShowAs[] = $locate->Translate("website");
$fieldsFromSearchShowAs[] = $locate->Translate("category");
$fieldsFromSearchShowAs[] = $locate->Translate("create_time");
$fieldsFromSearchShowAs[] = $locate->Translate("create_by");
// Create object whit 5 cols and all data arrays set before.
$table = new ScrollTable(7, $start, $limit, $filter, $numRows, $content, $order);
$table->exportFlag = '2';
//对导出标记进行赋值
$table->deleteFlag = '1';
$table->ordering = $ordering;
$deleteFlag = 1;
$deleteBtnFlag = 1;
if ($_SESSION['curuser']['usertype'] != 'admin' && $_SESSION['curuser']['usertype'] != 'groupadmin') {
if ($_SESSION['curuser']['privileges']['customer_leads']['delete']) {
$deleteFlag = 1;
$table->deleteFlag = '1';
$deleteBtnFlag = 1;
} else {
$deleteFlag = 0;
$table->deleteFlag = '0';
$deleteBtnFlag = 0;
}
}
$table->setHeader('title', $headers, $attribsHeader, $eventHeader, 0, $deleteFlag, 0);
$table->setAttribsCols($attribsCols);
$table->addRowSearchMore("customer_leads", $fieldsFromSearch, $fieldsFromSearchShowAs, $filter, $content, $start, $limit, 0, $deleteBtnFlag, $typeFromSearch, $typeFromSearchShowAs, $stype);
while ($arreglo->fetchInto($row)) {
// Change here by the name of fields of its database table
$rowc = array();
$rowc[] = $row['id'];
$rowc['select_id'] = $row['id'];
$rowc[] = '<a href=? onclick="xajax_showDetail(\'' . $row['id'] . '\');return false;">' . $row['customer'] . '</a>';
$rowc[] = $row['state'];
if ($config['system']['enable_code']) {
$rowc[] = $row['note'];
$rowc[] = $row['codes'];
$rowc[] = $row['noteCretime'];
}
$rowc[] = $row['city'];
$rowc[] = $row['phone'];
$rowc[] = $row['contact'];
$rowc[] = $row['website'];
$rowc[] = $row['category'];
$rowc[] = $row['cretime'];
$rowc[] = $row['creby'];
// $rowc[] = 'Detail';
$table->addRow("customer", $rowc, 0, $deleteFlag, 0, $divName, $fields);
}
$html = $table->render('delGrid');
return $html;
// End Editable Zone
}
/**
* generate grid HTML code
* @param start int record start
* @param limit int how many records need
* @param filter string the field need to search
* @param content string the contect want to match
* @param divName string which div grid want to be put
* @param order string data order
* @return html string grid HTML code
*/
function createGrid($start = 0, $limit = 1, $filter = null, $content = null, $order = null, $divName = "grid", $ordering = "", $stype = array())
{
global $locate;
$_SESSION['ordering'] = $ordering;
if ($filter == null or $content == null or $content == 'Array' or $filter == 'Array') {
$numRows =& Customer::getNumRows();
$arreglo =& Customer::getAllRecords($start, $limit, $order);
$content = null;
$filter = null;
} else {
foreach ($content as $value) {
if (trim($value) != "") {
//搜索内容有值
$flag = "1";
break;
}
}
foreach ($filter as $value) {
if (trim($value) != "") {
//搜索条件有值
$flag2 = "1";
break;
}
}
foreach ($stype as $value) {
if (trim($value) != "") {
//搜索方式有值
$flag3 = "1";
break;
}
}
if ($flag != "1" || $flag2 != "1") {
//无值
$numRows =& Customer::getNumRows();
$arreglo =& Customer::getAllRecords($start, $limit, $order);
} elseif ($flag3 != 1) {
$order = "id";
$numRows =& Customer::getNumRowsMore($filter, $content, "campaign");
$arreglo =& Customer::getRecordsFilteredMore($start, $limit, $filter, $content, $order, "campaign");
} else {
$order = "id";
$numRows =& Customer::getNumRowsMorewithstype($filter, $content, $stype, $table);
$arreglo =& Customer::getRecordsFilteredMorewithstype($start, $limit, $filter, $content, $stype, $order, $table);
}
}
// Select Box: type table.
$typeFromSearch = array();
$typeFromSearch[] = 'like';
$typeFromSearch[] = 'equal';
$typeFromSearch[] = 'more';
$typeFromSearch[] = 'less';
// Selecct Box: Labels showed on searchtype select box.
$typeFromSearchShowAs = array();
$typeFromSearchShowAs[] = $locate->Translate("like");
$typeFromSearchShowAs[] = '=';
$typeFromSearchShowAs[] = '>';
$typeFromSearchShowAs[] = '<';
// Editable zone
// Databse Table: fields
$fields = array();
$fields[] = 'id';
$fields[] = 'campaignname';
$fields[] = 'campaignnote';
$fields[] = 'groupname';
$fields[] = 'servername';
$fields[] = 'balance';
$fields[] = 'creby';
$fields[] = 'cretime';
// HTML table: Headers showed
$headers = array();
$headers[] = $locate->Translate("Campaign Name");
$headers[] = $locate->Translate("Campaign Note");
$headers[] = $locate->Translate("Group Name");
$headers[] = $locate->Translate("Server Name");
$headers[] = $locate->Translate("Remaining") . '/' . $locate->Translate("Dialed ") . '/' . $locate->Translate("Answered");
$headers[] = $locate->Translate("Balance");
$headers[] = $locate->Translate("Creby");
$headers[] = $locate->Translate("Cretime");
// HTML table: hearders attributes
$attribsHeader = array();
$attribsHeader[] = 'width=""';
$attribsHeader[] = 'width=""';
$attribsHeader[] = 'width=""';
$attribsHeader[] = 'width=""';
$attribsHeader[] = 'width=""';
$attribsHeader[] = 'width=""';
$attribsHeader[] = 'width=""';
$attribsHeader[] = 'width=""';
// HTML Table: columns attributes
$attribsCols = array();
$attribsCols[] = 'style="text-align: left"';
$attribsCols[] = 'style="text-align: left"';
$attribsCols[] = 'style="text-align: left"';
$attribsCols[] = 'style="text-align: left"';
$attribsCols[] = 'style="text-align: left"';
$attribsCols[] = 'style="text-align: left"';
$attribsCols[] = 'style="text-align: left"';
$attribsCols[] = 'style="text-align: left"';
// HTML Table: If you want ascendent and descendent ordering, set the Header Events.
$eventHeader = array();
$eventHeader[] = 'onClick=\'xajax_showGrid(0,' . $limit . ',"' . $filter . '","' . $content . '","campaignname","' . $divName . '","ORDERING");return false;\'';
$eventHeader[] = 'onClick=\'xajax_showGrid(0,' . $limit . ',"' . $filter . '","' . $content . '","campaignnote","' . $divName . '","ORDERING");return false;\'';
$eventHeader[] = 'onClick=\'xajax_showGrid(0,' . $limit . ',"' . $filter . '","' . $content . '","groupname","' . $divName . '","ORDERING");return false;\'';
$eventHeader[] = 'onClick=\'xajax_showGrid(0,' . $limit . ',"' . $filter . '","' . $content . '","servers.name","' . $divName . '","ORDERING");return false;\'';
$eventHeader[] = 'onClick=\'\'';
$eventHeader[] = 'onClick=\'xajax_showGrid(0,' . $limit . ',"' . $filter . '","' . $content . '","balance","' . $divName . '","ORDERING");return false;\'';
$eventHeader[] = 'onClick=\'xajax_showGrid(0,' . $limit . ',"' . $filter . '","' . $content . '","creby","' . $divName . '","ORDERING");return false;\'';
$eventHeader[] = 'onClick=\'xajax_showGrid(0,' . $limit . ',"' . $filter . '","' . $content . '","cretime","' . $divName . '","ORDERING");return false;\'';
// Select Box: fields table.
$fieldsFromSearch = array();
$fieldsFromSearch[] = 'campaignname';
$fieldsFromSearch[] = 'campaignnote';
$fieldsFromSearch[] = 'groupname';
$fieldsFromSearch[] = 'servers.name';
$fieldsFromSearch[] = 'balance';
$fieldsFromSearch[] = 'campaign.creby';
$fieldsFromSearch[] = 'campaign.cretime';
// Selecct Box: Labels showed on search select box.
$fieldsFromSearchShowAs = array();
$fieldsFromSearchShowAs[] = $locate->Translate("Campaign Name");
$fieldsFromSearchShowAs[] = $locate->Translate("Campaign Note");
$fieldsFromSearchShowAs[] = $locate->Translate("Group Name");
$fieldsFromSearchShowAs[] = $locate->Translate("Server Name");
$fieldsFromSearchShowAs[] = $locate->Translate("Balance");
$fieldsFromSearchShowAs[] = $locate->Translate("Creby");
$fieldsFromSearchShowAs[] = $locate->Translate("Cretime");
//echo 'dddddddddddddd';
// Create object whit 5 cols and all data arrays set before.
$table = new ScrollTable(6, $start, $limit, $filter, $numRows, $content, $order);
$table->exportFlag = '2';
//对导出标记进行赋值
$table->ordering = $ordering;
$editFlag = 1;
$deleteFlag = 1;
$addFlag = 1;
if ($_SESSION['curuser']['usertype'] != 'admin' && $_SESSION['curuser']['usertype'] != 'groupadmin') {
if ($_SESSION['curuser']['privileges']['campaign']['delete']) {
$deleteFlag = 1;
} else {
$deleteFlag = 0;
}
if ($_SESSION['curuser']['privileges']['campaign']['edit']) {
$editFlag = 1;
} else {
$editFlag = 0;
}
}
//如果是groupoperator 就没有添加 编辑和删除的功能
if ($_SESSION['curuser']['usertype'] == 'groupoperator') {
$addFlag = 0;
$editFlag = 0;
$deleteFlag = 0;
}
$table->setHeader('title', $headers, $attribsHeader, $eventHeader, $editFlag, $deleteFlag, 0);
$table->setAttribsCols($attribsCols);
$table->addRowSearchMore("campaign", $fieldsFromSearch, $fieldsFromSearchShowAs, $filter, $content, $start, $limit, $addFlag, 0, $typeFromSearch, $typeFromSearchShowAs, $stype);
while ($arreglo->fetchInto($row)) {
// Change here by the name of fields of its database table
$rowc = array();
$rowc[] = $row['id'];
$rowc[] = "<a href=? onclick=\"xajax_showDetail('" . $row['id'] . "');return false;\">" . $row['campaignname'] . "</a>";
$rowc[] = $row['campaignnote'];
$rowc[] = $row['groupname'];
if ($row['serverid'] != 0) {
$rowc[] = $row['servername'];
} else {
$rowc[] = $locate->Translate("Default server");
}
$total = astercrm::getCountByField('campaignid', $row['id'], 'diallist');
#$dialed = $row['dialed'];
#$answered = customer::getCountAnswered($row['id']);
$rowc[] = $total . '/' . $row['dialed'] . '/' . $row['answered'];
$rowc[] = $row['balance'];
$rowc[] = $row['creby'];
$rowc[] = $row['cretime'];
$table->addRow("campaign", $rowc, $editFlag, $deleteFlag, 0, $divName, $fields);
}
// End Editable Zone
$html = $table->render();
return $html;
}
/**
* generate grid HTML code
* @param start int record start
* @param limit int how many records need
* @param filter string the field need to search
* @param content string the contect want to match
* @param divName string which div grid want to be put
* @param order string data order
* @return html string grid HTML code
*/
function createGrid($start = 0, $limit = 1, $filter = null, $content = null, $order = null, $divName = "grid", $ordering = "", $stype = array())
{
global $locate;
$_SESSION['ordering'] = $ordering;
if ($filter == null or $content == null or $content == 'Array' or $filter == 'Array') {
$numRows =& Customer::getNumRows();
$arreglo =& Customer::getAllRecords($start, $limit, $order);
$content = null;
$filter = null;
} else {
foreach ($content as $value) {
if (trim($value) != "") {
//搜索内容有值
$flag = "1";
break;
}
}
foreach ($filter as $value) {
if (trim($value) != "") {
//搜索条件有值
$flag2 = "1";
break;
}
}
foreach ($stype as $value) {
if (trim($value) != "") {
//搜索方式有值
$flag3 = "1";
break;
}
}
if ($flag != "1" || $flag2 != "1") {
//无值
if (is_array($order) || $order == '') {
$order = null;
}
$numRows =& Customer::getNumRows();
$arreglo =& Customer::getAllRecords($start, $limit, $order);
} elseif ($flag3 != 1) {
$order = "id";
$numRows =& Customer::getNumRowsMore($filter, $content);
$arreglo =& Customer::getRecordsFilteredMore($start, $limit, $filter, $content, $order);
} else {
$order = "id";
$numRows =& Customer::getNumRowsMorewithstype($filter, $content, $stype, $table);
$arreglo =& Customer::getRecordsFilteredMorewithstype($start, $limit, $filter, $content, $stype, $order, $table);
}
}
// Select Box: type table.
$typeFromSearch = array();
$typeFromSearch[] = 'like';
$typeFromSearch[] = 'equal';
$typeFromSearch[] = 'more';
$typeFromSearch[] = 'less';
// Selecct Box: Labels showed on searchtype select box.
$typeFromSearchShowAs = array();
$typeFromSearchShowAs[] = $locate->Translate("like");
$typeFromSearchShowAs[] = '=';
$typeFromSearchShowAs[] = '>';
$typeFromSearchShowAs[] = '<';
// Editable zone
// Databse Table: fields
$fields = array();
$fields[] = 'name';
$fields[] = 'ip';
$fields[] = 'port';
$fields[] = 'username';
$fields[] = 'secret';
$fields[] = 'note';
// HTML table: Headers showed
$headers = array();
$headers[] = $locate->Translate("Server name");
$headers[] = $locate->Translate("IP");
$headers[] = $locate->Translate("Port");
$headers[] = $locate->Translate("Username");
$headers[] = $locate->Translate("Secret");
$headers[] = $locate->Translate("Note");
// HTML table: hearders attributes
$attribsHeader = array();
$attribsHeader[] = 'width=""';
$attribsHeader[] = 'width=""';
$attribsHeader[] = 'width=""';
$attribsHeader[] = 'width=""';
$attribsHeader[] = 'width=""';
$attribsHeader[] = 'width=""';
// HTML Table: columns attributes
$attribsCols = array();
$attribsCols[] = 'style="text-align: left"';
$attribsCols[] = 'style="text-align: left"';
$attribsCols[] = 'style="text-align: left"';
$attribsCols[] = 'style="text-align: left"';
$attribsCols[] = 'style="text-align: left"';
$attribsCols[] = 'style="text-align: left"';
// HTML Table: If you want ascendent and descendent ordering, set the Header Events.
$eventHeader = array();
$eventHeader[] = 'onClick=\'xajax_showGrid(0,' . $limit . ',"' . $filter . '","' . $content . '","name","' . $divName . '","ORDERING");return false;\'';
$eventHeader[] = 'onClick=\'xajax_showGrid(0,' . $limit . ',"' . $filter . '","' . $content . '","ip","' . $divName . '","ORDERING");return false;\'';
$eventHeader[] = 'onClick=\'xajax_showGrid(0,' . $limit . ',"' . $filter . '","' . $content . '","port","' . $divName . '","ORDERING");return false;\'';
$eventHeader[] = 'onClick=\'xajax_showGrid(0,' . $limit . ',"' . $filter . '","' . $content . '","username","' . $divName . '","ORDERING");return false;\'';
$eventHeader[] = 'onClick=\'xajax_showGrid(0,' . $limit . ',"' . $filter . '","' . $content . '","secret","' . $divName . '","ORDERING");return false;\'';
$eventHeader[] = 'onClick=\'xajax_showGrid(0,' . $limit . ',"' . $filter . '","' . $content . '","note","' . $divName . '","ORDERING");return false;\'';
// Select Box: fields table.
$fieldsFromSearch = array();
$fieldsFromSearch[] = 'name';
$fieldsFromSearch[] = 'ip';
$fieldsFromSearch[] = 'port';
$fieldsFromSearch[] = 'username';
$fieldsFromSearch[] = 'secret';
$fieldsFromSearch[] = 'note';
// Selecct Box: Labels showed on search select box.
$fieldsFromSearchShowAs = array();
$fieldsFromSearchShowAs[] = $locate->Translate("Server name");
$fieldsFromSearchShowAs[] = $locate->Translate("IP");
$fieldsFromSearchShowAs[] = $locate->Translate("Port");
$fieldsFromSearchShowAs[] = $locate->Translate("Username");
$fieldsFromSearchShowAs[] = $locate->Translate("Secret");
$fieldsFromSearchShowAs[] = $locate->Translate("Note");
// Create object whit 5 cols and all data arrays set before.
$table = new ScrollTable(6, $start, $limit, $filter, $numRows, $content, $order);
$table->setHeader('title', $headers, $attribsHeader, $eventHeader);
$table->setAttribsCols($attribsCols);
$table->exportFlag = '1';
//对导出标记进行赋值
$table->deleteFlag = '1';
//对删除标记进行赋值
$table->ordering = $ordering;
$table->addRowSearchMore("servers", $fieldsFromSearch, $fieldsFromSearchShowAs, $filter, $content, $start, $limit, 1, 0, $typeFromSearch, $typeFromSearchShowAs, $stype);
while ($arreglo->fetchInto($row)) {
// Change here by the name of fields of its database table
$rowc = array();
$rowc[] = $row['id'];
$rowc[] = $row['name'];
$rowc[] = $row['ip'];
$rowc[] = $row['port'];
$rowc[] = $row['username'];
$rowc[] = $row['secret'];
$rowc[] = $row['note'];
$table->addRow("servers", $rowc, 1, 1, 1, $divName, $fields);
}
// End Editable Zone
$html = $table->render();
return $html;
}
/**
* generate grid HTML code
* @param start int record start
* @param limit int how many records need
* @param filter string the field need to search
* @param content string the contect want to match
* @param stype string the matching type for search
* @param divName string which div grid want to be put
* @param order string data order
* @return html string grid HTML code
*/
function createGrid($start = 0, $limit = 1, $filter = null, $content = null, $stype = null, $order = null, $divName = "grid", $ordering = "", $stype = array())
{
global $locate;
$_SESSION['ordering'] = $ordering;
if ($filter == null || $content == null || !is_array($content) && $content == 'Array' || !is_array(filter) && $filter == 'Array') {
$content = null;
$filter = null;
$numRows =& Customer::getNumRows();
$arreglo =& Customer::getAllRecords($start, $limit, $order);
} else {
foreach ($content as $value) {
if (trim($value) != "") {
//搜索内容有值
$flag = "1";
break;
}
}
foreach ($filter as $value) {
if (trim($value) != "") {
//搜索条件有值
$flag2 = "1";
break;
}
}
foreach ($stype as $value) {
if (trim($value) != "") {
//搜索方式有值
$flag3 = "1";
break;
}
}
if ($flag != "1" || $flag2 != "1") {
//无值
$order = null;
$numRows =& Customer::getNumRows();
$arreglo =& Customer::getAllRecords($start, $limit, $order);
} elseif ($flag3 != 1) {
//未选择搜索方式
$order = "modifytime";
$numRows =& Customer::getNumRowsMore($filter, $content, "credithistory");
$arreglo =& Customer::getRecordsFilteredMore($start, $limit, $filter, $content, $order, "credithistory");
} else {
$order = "modifytime";
$numRows =& Customer::getNumRowsMorewithstype($filter, $content, $stype, "credithistory");
$arreglo =& Customer::getRecordsFilteredMorewithstype($start, $limit, $filter, $content, $stype, $order, "credithistory");
}
}
// Select Box: type table.
$typeFromSearch = array();
$typeFromSearch[] = 'like';
$typeFromSearch[] = 'equal';
$typeFromSearch[] = 'more';
$typeFromSearch[] = 'less';
// Selecct Box: Labels showed on searchtype select box.
$typeFromSearchShowAs = array();
$typeFromSearchShowAs[] = $locate->Translate("like");
$typeFromSearchShowAs[] = '=';
$typeFromSearchShowAs[] = '>';
$typeFromSearchShowAs[] = '<';
// Editable zone
if ($_SESSION['curuser']['usertype'] == 'clid') {
// Database Table: fields
$fields = array();
$fields[] = 'modifytime';
$fields[] = 'clidid';
$fields[] = 'srccredit';
$fields[] = 'modifystatus';
$fields[] = 'modifyamount';
$fields[] = 'comment';
// HTML table: Headers showed
$headers = array();
$headers[] = $locate->Translate("Modifytime");
$headers[] = $locate->Translate("Clid");
$headers[] = $locate->Translate("Srccredit");
$headers[] = $locate->Translate("Modifystatus");
$headers[] = $locate->Translate("Modifyamount");
$headers[] = $locate->Translate("Comment");
// HTML table: hearders attributes
$attribsHeader = array();
$attribsHeader[] = 'width=""';
$attribsHeader[] = 'width=""';
$attribsHeader[] = 'width=""';
$attribsHeader[] = 'width=""';
$attribsHeader[] = 'width=""';
$attribsHeader[] = 'width=""';
// HTML Table: columns attributes
$attribsCols = array();
$attribsCols[] = 'style="text-align: left"';
$attribsCols[] = 'style="text-align: left"';
$attribsCols[] = 'style="text-align: left"';
$attribsCols[] = 'style="text-align: left"';
$attribsCols[] = 'style="text-align: left"';
$attribsCols[] = 'style="text-align: left"';
// HTML Table: If you want ascendent and descendent ordering, set the Header Events.
$eventHeader = array();
$eventHeader[] = 'onClick=\'xajax_showGrid(0,' . $limit . ',"' . $filter . '","' . $content . '","modifytime","' . $divName . '","ORDERING","' . $stype . '");return false;\'';
$eventHeader[] = 'onClick=\'xajax_showGrid(0,' . $limit . ',"' . $filter . '","' . $content . '","clidid","' . $divName . '","ORDERING","' . $stype . '");return false;\'';
$eventHeader[] = 'onClick=\'xajax_showGrid(0,' . $limit . ',"' . $filter . '","' . $content . '","srccredit","' . $divName . '","ORDERING");return false;\'';
$eventHeader[] = 'onClick=\'xajax_showGrid(0,' . $limit . ',"' . $filter . '","' . $content . '","modifystatus","' . $divName . '","ORDERING","' . $stype . '");return false;\'';
$eventHeader[] = 'onClick=\'xajax_showGrid(0,' . $limit . ',"' . $filter . '","' . $content . '","modifyamount","' . $divName . '","ORDERING","' . $stype . '");return false;\'';
$eventHeader[] = 'onClick=\'xajax_showGrid(0,' . $limit . ',"' . $filter . '","' . $content . '","comment","' . $divName . '","ORDERING","' . $stype . '");return false;\'';
// Select Box: fields table.
$fieldsFromSearch = array();
$fieldsFromSearch[] = 'modifytime';
$fieldsFromSearch[] = 'clidid';
$fieldsFromSearch[] = 'srccredit';
$fieldsFromSearch[] = 'modifystatus';
$fieldsFromSearch[] = 'modifyamount';
$fieldsFromSearch[] = 'comment';
// Selecct Box: Labels showed on search select box.
$fieldsFromSearchShowAs = array();
$fieldsFromSearchShowAs[] = $locate->Translate("modifytime");
$fieldsFromSearchShowAs[] = $locate->Translate("clidid");
$fieldsFromSearchShowAs[] = $locate->Translate("srccredit");
$fieldsFromSearchShowAs[] = $locate->Translate("modifystatus");
$fieldsFromSearchShowAs[] = $locate->Translate("modifyamount");
$fieldsFromSearchShowAs[] = $locate->Translate("comment");
// Create object whit 5 cols and all data arrays set before.
$table = new ScrollTable(6, $start, $limit, $filter, $numRows, $content, $order);
$table->setHeader('title', $headers, $attribsHeader, $eventHeader, $edit = false, $delete = false, $detail = false);
$table->setAttribsCols($attribsCols);
$table->addRowSearchMore("credithistory", $fieldsFromSearch, $fieldsFromSearchShowAs, $filter, $content, $start, $limit, 0, $typeFromSearch, $typeFromSearchShowAs, $stype);
while ($arreglo->fetchInto($row)) {
// Change here by the name of fields of its database table
$name =& Customer::getNames($row['operator'], $row['resellerid'], $row['groupid'], $row['clidid']);
$rowc = array();
$rowc[] = $row['id'];
$rowc[] = $row['modifytime'];
$rowc[] = $name['clidname'];
$rowc[] = $row['srccredit'];
if ($row['modifystatus'] == 'add') {
$rowc['modifystatus'] = 'refund';
} else {
$rowc['modifystatus'] = 'charge';
}
$rowc['modifyamount'] = $row['modifyamount'];
$rowc['comment'] = $row['comment'];
$table->addRow("credithistory", $rowc, false, false, false, $divName, $fields);
}
} else {
// Database Table: fields
$fields = array();
$fields[] = 'modifytime';
$fields[] = 'resellerid';
$fields[] = 'groupid';
$fields[] = 'clidid';
$fields[] = 'srccredit';
$fields[] = 'modifystatus';
$fields[] = 'modifyamount';
$fields[] = 'comment';
$fields[] = 'operator';
// HTML table: Headers showed
$headers = array();
$headers[] = $locate->Translate("Modifytime");
$headers[] = $locate->Translate("Resellername");
$headers[] = $locate->Translate("Group");
$headers[] = $locate->Translate("Clid");
$headers[] = $locate->Translate("Srccredit");
$headers[] = $locate->Translate("Modifystatus");
$headers[] = $locate->Translate("Modifyamount");
$headers[] = $locate->Translate("Comment");
$headers[] = $locate->Translate("Modifyby");
// HTML table: hearders attributes
$attribsHeader = array();
$attribsHeader[] = 'width=""';
$attribsHeader[] = 'width=""';
$attribsHeader[] = 'width=""';
$attribsHeader[] = 'width=""';
$attribsHeader[] = 'width=""';
$attribsHeader[] = 'width=""';
$attribsHeader[] = 'width=""';
$attribsHeader[] = 'width=""';
$attribsHeader[] = 'width=""';
// HTML Table: columns attributes
$attribsCols = array();
$attribsCols[] = 'style="text-align: left"';
$attribsCols[] = 'style="text-align: left"';
$attribsCols[] = 'style="text-align: left"';
$attribsCols[] = 'style="text-align: left"';
$attribsCols[] = 'style="text-align: left"';
$attribsCols[] = 'style="text-align: left"';
$attribsCols[] = 'style="text-align: left"';
$attribsCols[] = 'style="text-align: left"';
$attribsCols[] = 'style="text-align: left"';
// HTML Table: If you want ascendent and descendent ordering, set the Header Events.
$eventHeader = array();
$eventHeader[] = 'onClick=\'xajax_showGrid(0,' . $limit . ',"' . $filter . '","' . $content . '","modifytime","' . $divName . '","ORDERING","' . $stype . '");return false;\'';
$eventHeader[] = 'onClick=\'xajax_showGrid(0,' . $limit . ',"' . $filter . '","' . $content . '","resellerid","' . $divName . '","ORDERING","' . $stype . '");return false;\'';
$eventHeader[] = 'onClick=\'xajax_showGrid(0,' . $limit . ',"' . $filter . '","' . $content . '","groupid","' . $divName . '","ORDERING","' . $stype . '");return false;\'';
$eventHeader[] = 'onClick=\'xajax_showGrid(0,' . $limit . ',"' . $filter . '","' . $content . '","clidid","' . $divName . '","ORDERING","' . $stype . '");return false;\'';
$eventHeader[] = 'onClick=\'xajax_showGrid(0,' . $limit . ',"' . $filter . '","' . $content . '","srccredit","' . $divName . '","ORDERING");return false;\'';
$eventHeader[] = 'onClick=\'xajax_showGrid(0,' . $limit . ',"' . $filter . '","' . $content . '","modifystatus","' . $divName . '","ORDERING","' . $stype . '");return false;\'';
$eventHeader[] = 'onClick=\'xajax_showGrid(0,' . $limit . ',"' . $filter . '","' . $content . '","modifyamount","' . $divName . '","ORDERING","' . $stype . '");return false;\'';
$eventHeader[] = 'onClick=\'xajax_showGrid(0,' . $limit . ',"' . $filter . '","' . $content . '","comment","' . $divName . '","ORDERING","' . $stype . '");return false;\'';
$eventHeader[] = 'onClick=\'xajax_showGrid(0,' . $limit . ',"' . $filter . '","' . $content . '","operator","' . $divName . '","ORDERING","' . $stype . '");return false;\'';
// Select Box: fields table.
$fieldsFromSearch = array();
$fieldsFromSearch[] = 'modifytime';
$fieldsFromSearch[] = 'resellerid';
$fieldsFromSearch[] = 'groupid';
$fieldsFromSearch[] = 'clidid';
$fieldsFromSearch[] = 'srccredit';
$fieldsFromSearch[] = 'modifystatus';
$fieldsFromSearch[] = 'modifyamount';
$fieldsFromSearch[] = 'comment';
$fieldsFromSearch[] = 'epayment_txn_id';
$fieldsFromSearch[] = 'operator';
// Selecct Box: Labels showed on search select box.
$fieldsFromSearchShowAs = array();
$fieldsFromSearchShowAs[] = $locate->Translate("modifytime");
$fieldsFromSearchShowAs[] = $locate->Translate("resellerid");
$fieldsFromSearchShowAs[] = $locate->Translate("groupid");
$fieldsFromSearchShowAs[] = $locate->Translate("clidid");
$fieldsFromSearchShowAs[] = $locate->Translate("srccredit");
$fieldsFromSearchShowAs[] = $locate->Translate("modifystatus");
$fieldsFromSearchShowAs[] = $locate->Translate("modifyamount");
$fieldsFromSearchShowAs[] = $locate->Translate("comment");
$fieldsFromSearchShowAs[] = $locate->Translate("txn id");
$fieldsFromSearchShowAs[] = $locate->Translate("operator");
// Create object whit 5 cols and all data arrays set before.
$table = new ScrollTable(10, $start, $limit, $filter, $numRows, $content, $order);
$table->setHeader('title', $headers, $attribsHeader, $eventHeader, $edit = false, $delete = false, $detail = false);
if ($_SESSION['curuser']['usertype'] == 'admin') {
$table->deleteFlag = '1';
}
//对删除标记进行赋值
$table->exportFlag = '1';
//对导出标记进行赋值
$table->setAttribsCols($attribsCols);
$table->addRowSearchMore("credithistory", $fieldsFromSearch, $fieldsFromSearchShowAs, $filter, $content, $start, $limit, 0, $typeFromSearch, $typeFromSearchShowAs, $stype);
while ($arreglo->fetchInto($row)) {
// Change here by the name of fields of its database table
$name =& Customer::getNames($row['operator'], $row['resellerid'], $row['groupid'], $row['clidid']);
$rowc = array();
$rowc[] = $row['id'];
$rowc[] = $row['modifytime'];
$rowc[] = $name['resellername'] . "(" . $row['resellerid'] . ")";
$rowc[] = $name['groupname'] . "(" . $row['groupid'] . ")";
$rowc[] = $name['clidname'] . "(" . $row['clidid'] . ")";
$rowc[] = $row['srccredit'];
if ($row['modifystatus'] == 'add') {
$rowc['modifystatus'] = 'refund';
} else {
$rowc['modifystatus'] = 'charge';
}
$rowc['modifyamount'] = $row['modifyamount'];
if ($row['epayment_txn_id'] != '') {
$rowc['comment'] = $row['comment'] . '(' . $row['epayment_txn_id'] . ')';
} else {
$rowc['comment'] = $row['comment'];
}
$rowc[] = $name['username'];
$table->addRow("credithistory", $rowc, false, false, false, $divName, $fields);
}
}
// End Editable Zone
$html = $table->render();
return $html;
}
/**
* generate grid HTML code
* @param start int record start
* @param limit int how many records need
* @param filter string the field need to search
* @param content string the contect want to match
* @param divName string which div grid want to be put
* @param order string data order
* @return html string grid HTML code
*/
function createGrid($start = 0, $limit = 1, $filter = null, $content = null, $order = null, $divName = "grid", $ordering = "", $exportFlag = "", $stype = array())
{
//print_r($stype);exit;
global $locate;
$_SESSION['ordering'] = $ordering;
if ($filter == null or $content == null or $content == 'Array' or $filter == 'Array') {
$numRows =& Customer::getNumRows();
$arreglo =& Customer::getAllRecords($start, $limit, $order);
$content = null;
$filter = null;
} else {
foreach ($content as $value) {
if (trim($value) != "") {
//搜索内容有值
$flag = "1";
break;
}
}
foreach ($filter as $value) {
if (trim($value) != "") {
//搜索条件有值
$flag2 = "1";
break;
}
}
foreach ($stype as $value) {
if (trim($value) != "") {
//搜索方式有值
$flag3 = "1";
break;
}
}
if ($flag != "1" || $flag2 != "1") {
//无值
if (is_array($order) || $order == '') {
$order = null;
}
$numRows =& Customer::getNumRows();
$arreglo =& Customer::getAllRecords($start, $limit, $order);
} elseif ($flag3 != 1) {
$order = "id";
$numRows =& Customer::getNumRowsMore($filter, $content, "surveyresult");
$arreglo =& Customer::getRecordsFilteredMore($start, $limit, $filter, $content, $order, "surveyresult");
} else {
$order = "id";
$numRows =& Customer::getNumRowsMorewithstype($filter, $content, $stype, "surveyresult");
$arreglo =& Customer::getRecordsFilteredMorewithstype($start, $limit, $filter, $content, $stype, $order, "surveyresult");
}
}
// Select Box: type table.
$typeFromSearch = array();
$typeFromSearch[] = 'like';
$typeFromSearch[] = 'equal';
$typeFromSearch[] = 'more';
$typeFromSearch[] = 'less';
// Selecct Box: Labels showed on searchtype select box.
$typeFromSearchShowAs = array();
$typeFromSearchShowAs[] = $locate->Translate('like');
$typeFromSearchShowAs[] = '=';
$typeFromSearchShowAs[] = '>';
$typeFromSearchShowAs[] = '<';
// Editable zone
// Databse Table: fields
$fields = array();
$fields[] = 'surveytitle';
$fields[] = 'surveyoption';
$fields[] = 'surveynote';
$fields[] = 'customer';
$fields[] = 'contact';
$fields[] = 'phonenumber';
$fields[] = 'campaignname';
$fields[] = 'cretime';
// HTML table: Headers showed
$headers = array();
$headers[] = $locate->Translate("Survey Title");
$headers[] = $locate->Translate("Survey Option");
$headers[] = $locate->Translate("Survey Item");
$headers[] = $locate->Translate("Survey Note");
$headers[] = $locate->Translate("customer");
$headers[] = $locate->Translate("contact");
$headers[] = $locate->Translate("Phone Number");
$headers[] = $locate->Translate("Campaign Name");
$headers[] = $locate->Translate("create_time");
// HTML table: hearders attributes
$attribsHeader = array();
$attribsHeader[] = 'width=""';
$attribsHeader[] = 'width=""';
$attribsHeader[] = 'width=""';
$attribsHeader[] = 'width=""';
$attribsHeader[] = 'width=""';
$attribsHeader[] = 'width=""';
$attribsHeader[] = 'width=""';
$attribsHeader[] = 'width=""';
// HTML Table: columns attributes
$attribsCols = array();
$attribsCols[] = 'style="text-align: left"';
$attribsCols[] = 'style="text-align: left"';
$attribsCols[] = 'style="text-align: left"';
$attribsCols[] = 'style="text-align: left"';
$attribsCols[] = 'style="text-align: left"';
$attribsCols[] = 'style="text-align: left"';
$attribsCols[] = 'style="text-align: left"';
$attribsCols[] = 'style="text-align: left"';
// HTML Table: If you want ascendent and descendent ordering, set the Header Events.
$eventHeader = array();
$eventHeader[] = 'onClick=\'xajax_showGrid(0,' . $limit . ',"' . $filter . '","' . $content . '","surveyname","' . $divName . '","ORDERING");return false;\'';
$eventHeader[] = 'onClick=\'xajax_showGrid(0,' . $limit . ',"' . $filter . '","' . $content . '","surveyoption","' . $divName . '","ORDERING");return false;\'';
$eventHeader[] = 'onClick=\'xajax_showGrid(0,' . $limit . ',"' . $filter . '","' . $content . '","itemcontent","' . $divName . '","ORDERING");return false;\'';
$eventHeader[] = 'onClick=\'xajax_showGrid(0,' . $limit . ',"' . $filter . '","' . $content . '","surveynote","' . $divName . '","ORDERING");return false;\'';
$eventHeader[] = 'onClick=\'xajax_showGrid(0,' . $limit . ',"' . $filter . '","' . $content . '","customer","' . $divName . '","ORDERING");return false;\'';
$eventHeader[] = 'onClick=\'xajax_showGrid(0,' . $limit . ',"' . $filter . '","' . $content . '","contact","' . $divName . '","ORDERING");return false;\'';
$eventHeader[] = 'onClick=\'xajax_showGrid(0,' . $limit . ',"' . $filter . '","' . $content . '","phonenumber","' . $divName . '","ORDERING");return false;\'';
$eventHeader[] = 'onClick=\'xajax_showGrid(0,' . $limit . ',"' . $filter . '","' . $content . '","campaignname","' . $divName . '","ORDERING");return false;\'';
$eventHeader[] = 'onClick=\'xajax_showGrid(0,' . $limit . ',"' . $filter . '","' . $content . '","cretime","' . $divName . '","ORDERING");return false;\'';
// Select Box: fields table.
$fieldsFromSearch = array();
$fieldsFromSearch[] = 'surveytitle';
$fieldsFromSearch[] = 'surveyoption';
$fieldsFromSearch[] = 'itemcontent';
$fieldsFromSearch[] = 'surveyresult.surveynote';
$fieldsFromSearch[] = 'customer';
$fieldsFromSearch[] = 'contact.contact';
$fieldsFromSearch[] = 'surveyresult.phonenumber';
$fieldsFromSearch[] = 'campaign.campaignname';
//$fieldsFromSearch[] = 'survey.id';
$fieldsFromSearch[] = 'surveyresult.cretime';
$fieldsFromSearch[] = 'surveyresult.creby';
// Selecct Box: Labels showed on search select box.
$fieldsFromSearchShowAs = array();
$fieldsFromSearchShowAs[] = $locate->Translate("survey_title");
$fieldsFromSearchShowAs[] = $locate->Translate("survey_option");
$fieldsFromSearchShowAs[] = $locate->Translate("survey_item");
$fieldsFromSearchShowAs[] = $locate->Translate("survey_note");
$fieldsFromSearchShowAs[] = $locate->Translate("customer");
$fieldsFromSearchShowAs[] = $locate->Translate("contact");
$fieldsFromSearchShowAs[] = $locate->Translate("Phone Number");
$fieldsFromSearchShowAs[] = $locate->Translate("Campaign Name");
//$fieldsFromSearchShowAs[] = $locate->Translate("Survey ID");
$fieldsFromSearchShowAs[] = $locate->Translate("create_time");
$fieldsFromSearchShowAs[] = $locate->Translate("create_by");
// Create object whit 5 cols and all data arrays set before.
$table = new ScrollTable(6, $start, $limit, $filter, $numRows, $content, $order);
$table->exportFlag = '1';
//对导出标记进行赋值
$table->deleteFlag = '1';
//对删除标记进行赋值
$deleteFlag = 1;
if ($_SESSION['curuser']['usertype'] != 'admin' && $_SESSION['curuser']['usertype'] != 'groupadmin') {
if ($_SESSION['curuser']['privileges']['surveyresult']['delete']) {
$deleteFlag = 1;
$table->deleteFlag = '1';
} else {
$deleteFlag = 0;
$table->deleteFlag = '0';
}
}
$table->setHeader('title', $headers, $attribsHeader, $eventHeader, 0, $deleteFlag, 0);
$table->setAttribsCols($attribsCols);
$table->ordering = $ordering;
$table->addRowSearchMore("surveyresult", $fieldsFromSearch, $fieldsFromSearchShowAs, $filter, $content, $start, $limit, 0, 0, $typeFromSearch, $typeFromSearchShowAs, $stype);
while ($arreglo->fetchInto($row)) {
// Change here by the name of fields of its database table
$rowc = array();
$rowc[] = $row['id'];
$rowc[] = $row['surveyname'];
$rowc[] = $row['surveyoption'];
$rowc[] = $row['itemcontent'];
$rowc[] = $row['surveynote'];
$rowc[] = "<a href=? onclick='xajax_showCustomer(" . $row['customerid'] . ");return false;'>" . $row['customer'] . "</a>";
$rowc[] = "<a href=? onclick='xajax_showContact(" . $row['contactid'] . ");return false;'>" . $row['contact'] . "</a>";
$rowc[] = $row['phonenumber'];
$rowc[] = $row['campaignname'];
$rowc[] = $row['cretime'];
$table->addRow("surveyresult", $rowc, 0, $deleteFlag, 0, $divName, $fields);
}
// End Editable Zone
$html = $table->render();
return $html;
}
/**
* generate grid HTML code
* @param start int record start
* @param limit int how many records need
* @param filter string the field need to search
* @param content string the contect want to match
* @param divName string which div grid want to be put
* @param order string data order
* @return html string grid HTML code
*/
function createGrid($start = 0, $limit = 1, $filter = null, $content = null, $order = null, $divName = "grid", $ordering = "", $stype = array())
{
global $locate, $config;
$_SESSION['ordering'] = $ordering;
if ($filter == null or $content == null || !is_array($content) && $content == 'Array' || !is_array(filter) && $filter == 'Array') {
$content = null;
$filter = null;
$numRows =& Customer::getNumRows();
$arreglo =& Customer::getAllRecords($start, $limit, $order);
} else {
foreach ($content as $value) {
if (trim($value) != "") {
//搜索内容有值
$flag = "1";
break;
}
}
foreach ($filter as $value) {
if (trim($value) != "") {
//搜索条件有值
$flag2 = "1";
break;
}
}
foreach ($stype as $value) {
if (trim($value) != "") {
//搜索方式有值
$flag3 = "1";
break;
}
}
if ($flag != "1" || $flag2 != "1") {
//无值
$order = null;
$numRows =& Customer::getNumRows();
$arreglo =& Customer::getAllRecords($start, $limit, $order);
} elseif ($flag3 != 1) {
$order = "id";
$numRows =& Customer::getNumRowsMore($filter, $content, "account");
$arreglo =& Customer::getRecordsFilteredMore($start, $limit, $filter, $content, $order, "account");
} else {
$order = "id";
$numRows =& Customer::getNumRowsMorewithstype($filter, $content, $stype, $table);
$arreglo =& Customer::getRecordsFilteredMorewithstype($start, $limit, $filter, $content, $stype, $order, $table);
}
}
// Select Box: type table.
$typeFromSearch = array();
$typeFromSearch[] = 'like';
$typeFromSearch[] = 'equal';
$typeFromSearch[] = 'more';
$typeFromSearch[] = 'less';
// Selecct Box: Labels showed on searchtype select box.
$typeFromSearchShowAs = array();
$typeFromSearchShowAs[] = $locate->Translate("like");
$typeFromSearchShowAs[] = '=';
$typeFromSearchShowAs[] = '>';
$typeFromSearchShowAs[] = '<';
// Editable zone
// Databse Table: fields
$fields = array();
$fields[] = 'username';
$fields[] = 'ip';
$fields[] = 'usertype';
$fields[] = 'action';
$fields[] = 'status';
$fields[] = 'failedcause';
$fields[] = 'cretime';
// HTML table: Headers showed
$headers = array();
$headers[] = $locate->Translate("Username");
$headers[] = $locate->Translate("IP");
$headers[] = $locate->Translate("Usertype");
$headers[] = $locate->Translate("Action");
$headers[] = $locate->Translate("Status");
$headers[] = $locate->Translate("Failed cause");
$headers[] = $locate->Translate("Cretime");
$headers[] = $locate->Translate("Option");
// HTML table: hearders attributes
$attribsHeader = array();
$attribsHeader[] = 'width=""';
$attribsHeader[] = 'width=""';
$attribsHeader[] = 'width=""';
$attribsHeader[] = 'width=""';
$attribsHeader[] = 'width=""';
$attribsHeader[] = 'width=""';
$attribsHeader[] = 'width=""';
// HTML Table: columns attributes
$attribsCols = array();
$attribsCols[] = 'style="text-align: left"';
$attribsCols[] = 'style="text-align: left"';
$attribsCols[] = 'style="text-align: left"';
$attribsCols[] = 'style="text-align: left"';
$attribsCols[] = 'style="text-align: left"';
$attribsCols[] = 'style="text-align: left"';
$attribsCols[] = 'style="text-align: left"';
// HTML Table: If you want ascendent and descendent ordering, set the Header Events.
$eventHeader = array();
$eventHeader[] = 'onClick=\'xajax_showGrid(0,' . $limit . ',"' . $filter . '","' . $content . '","username","' . $divName . '","ORDERING");return false;\'';
$eventHeader[] = 'onClick=\'xajax_showGrid(0,' . $limit . ',"' . $filter . '","' . $content . '","ip","' . $divName . '","ORDERING");return false;\'';
$eventHeader[] = 'onClick=\'xajax_showGrid(0,' . $limit . ',"' . $filter . '","' . $content . '","usertype","' . $divName . '","ORDERING");return false;\'';
$eventHeader[] = 'onClick=\'xajax_showGrid(0,' . $limit . ',"' . $filter . '","' . $content . '","action","' . $divName . '","ORDERING");return false;\'';
$eventHeader[] = 'onClick=\'xajax_showGrid(0,' . $limit . ',"' . $filter . '","' . $content . '","status","' . $divName . '","ORDERING");return false;\'';
$eventHeader[] = 'onClick=\'xajax_showGrid(0,' . $limit . ',"' . $filter . '","' . $content . '","failedcause","' . $divName . '","ORDERING");return false;\'';
$eventHeader[] = 'onClick=\'xajax_showGrid(0,' . $limit . ',"' . $filter . '","' . $content . '","cretime","' . $divName . '","ORDERING");return false;\'';
// Select Box: fields table.
$fieldsFromSearch = array();
$fieldsFromSearch[] = 'username';
$fieldsFromSearch[] = 'ip';
$fieldsFromSearch[] = 'usertype';
$fieldsFromSearch[] = 'action';
$fieldsFromSearch[] = 'status';
$fieldsFromSearch[] = 'failedcause';
$fieldsFromSearch[] = 'cretime';
// Selecct Box: Labels showed on search select box.
$fieldsFromSearchShowAs = array();
$fieldsFromSearchShowAs[] = $locate->Translate("Username");
$fieldsFromSearchShowAs[] = $locate->Translate("IP");
$fieldsFromSearchShowAs[] = $locate->Translate("Usertype");
$fieldsFromSearchShowAs[] = $locate->Translate("Action");
$fieldsFromSearchShowAs[] = $locate->Translate("status");
$fieldsFromSearchShowAs[] = $locate->Translate("failedcause");
$fieldsFromSearchShowAs[] = $locate->Translate("cretime");
// Create object whit 5 cols and all data arrays set before.
$table = new ScrollTable(7, $start, $limit, $filter, $numRows, $content, $order);
$table->setHeader('title', $headers, $attribsHeader, $eventHeader, 0, 0, 0);
$table->setAttribsCols($attribsCols);
$table->exportFlag = '1';
//对导出标记进行赋值
$table->addRowSearchMore("account_log", $fieldsFromSearch, $fieldsFromSearchShowAs, $filter, $content, $start, $limit, 0, $typeFromSearch, $typeFromSearchShowAs, $stype);
while ($arreglo->fetchInto($row)) {
// Change here by the name of fields of its database table
$rowc = array();
$rowc[] = $row['id'];
$rowc[] = $row['username'];
$rowc[] = $row['ip'];
$rowc[] = $row['usertype'];
$rowc[] = $row['action'];
$rowc[] = $row['status'];
$rowc[] = $row['failedcause'];
$rowc[] = $row['cretime'];
if ($row['failedtimes'] >= $config['system']['max_incorrect_login'] && $config['system']['max_incorrect_login'] > 0) {
$rowc[] = '<a onclick="xajax_unlock(\'' . $row['ip'] . '\',xajax.getFormValues(\'searchForm\'))">' . $locate->Translate("Unlock") . '</a>';
$trstyle = 'style="background:#d5c59f;"';
} else {
$trstyle = '';
}
$table->addRow("account_log", $rowc, 0, 0, 0, $divName, $fields, $trstyle);
}
// End Editable Zone
$html = $table->render();
return $html;
}
/**
* generate grid HTML code
* @param start int record start
* @param limit int how many records need
* @param filter string the field need to search
* @param content string the contect want to match
* @param divName string which div grid want to be put
* @param order string data order
* @return html string grid HTML code
*/
function createGrid($start = 0, $limit = 1, $filter = null, $content = null, $order = null, $divName = "grid", $ordering = "", $stype = array())
{
global $locate, $config;
$_SESSION['ordering'] = $ordering;
if ($filter == null or $content == null or $content == 'Array' or $filter == 'Array') {
$numRows =& Customer::getNumRows();
$arreglo =& Customer::getAllRecords($start, $limit, $order);
$content = null;
$filter = null;
} else {
foreach ($content as $value) {
if (trim($value) != "") {
//搜索内容有值
$flag = "1";
break;
}
}
foreach ($filter as $value) {
if (trim($value) != "") {
//搜索条件有值
$flag2 = "1";
break;
}
}
foreach ($stype as $value) {
if (trim($value) != "") {
//搜索方式有值
$flag3 = "1";
break;
}
}
if ($flag != "1" || $flag2 != "1") {
//无值
if (is_array($order) || $order == '') {
$order = null;
}
$numRows =& Customer::getNumRows();
$arreglo =& Customer::getAllRecords($start, $limit, $order);
} elseif ($flag3 != 1) {
$order = "id";
$numRows =& Customer::getNumRowsMore($filter, $content, "astercrm_accout");
$arreglo =& Customer::getRecordsFilteredMore($start, $limit, $filter, $content, $order, "astercrm_accout");
} else {
$order = "id";
$numRows =& Customer::getNumRowsMorewithstype($filter, $content, $stype, $table);
$arreglo =& Customer::getRecordsFilteredMorewithstype($start, $limit, $filter, $content, $stype, $order, $table);
}
}
// Select Box: type table.
$typeFromSearch = array();
$typeFromSearch[] = 'like';
$typeFromSearch[] = 'equal';
$typeFromSearch[] = 'more';
$typeFromSearch[] = 'less';
// Selecct Box: Labels showed on searchtype select box.
$typeFromSearchShowAs = array();
$typeFromSearchShowAs[] = $locate->Translate("like");
$typeFromSearchShowAs[] = '=';
$typeFromSearchShowAs[] = '>';
$typeFromSearchShowAs[] = '<';
// Editable zone
// Databse Table: fields
$fields = array();
$fields[] = 'username';
$fields[] = 'login_time';
$fields[] = 'online_time';
// HTML table: Headers showed
$headers = array();
$headers[] = $locate->Translate("ALL") . "<input type='checkbox' onclick=\"ckbAllOnClick(this);\">";
//"select all for delete";
$headers[] = $locate->Translate("username");
$headers[] = $locate->Translate("login time");
$headers[] = $locate->Translate("online time");
//"Customer Name";
// HTML table: hearders attributes
$attribsHeader = array();
$attribsHeader[] = 'width="5%"';
$attribsHeader[] = 'width="30%"';
$attribsHeader[] = 'width="30%"';
$attribsHeader[] = 'width="30%"';
// HTML Table: columns attributes
$attribsCols = array();
$attribsCols[] = 'style="text-align: left"';
$attribsCols[] = 'style="text-align: left"';
$attribsCols[] = 'style="text-align: left"';
// HTML Table: If you want ascendent and descendent ordering, set the Header Events.
$eventHeader = array();
$eventHeader[] = '';
$eventHeader[] = 'onClick=\'xajax_showGrid(0,' . $limit . ',"' . $filter . '","' . $content . '","username","' . $divName . '","ORDERING");return false;\'';
$eventHeader[] = '';
$eventHeader[] = 'onClick=\'xajax_showGrid(0,' . $limit . ',"' . $filter . '","' . $content . '","last_login_time","' . $divName . '","ORDERING");return false;\'';
// Select Box: fields table.
$fieldsFromSearch = array();
$fieldsFromSearch[] = 'username';
$fieldsFromSearch[] = 'last_login_time';
// Selecct Box: Labels showed on search select box.
$fieldsFromSearchShowAs = array();
$fieldsFromSearchShowAs[] = $locate->Translate("username");
$fieldsFromSearchShowAs[] = $locate->Translate("login time");
// Create object whit 5 cols and all data arrays set before.
$table = new ScrollTable(6, $start, $limit, $filter, $numRows, $content, $order);
$table->setHeader('title', $headers, $attribsHeader, $eventHeader, 0, 0, 0);
$table->setAttribsCols($attribsCols);
$table->exportFlag = '2';
//对导出标记进行赋值
//$table->deleteFlag = '1';
$table->ordering = $ordering;
//$table->addRowSearchMore("note",$fieldsFromSearch,$fieldsFromSearchShowAs,$filter,$content);
$table->addRowSearchMore("astercrm_accout", $fieldsFromSearch, $fieldsFromSearchShowAs, $filter, $content, $start, $limit, 0, 0, $typeFromSearch, $typeFromSearchShowAs, $stype);
while ($arreglo->fetchInto($row)) {
// Change here by the name of fields of its database table
$rowc = array();
$rowc[] = $row['id'];
$rowc['select_id'] = $row['id'];
$rowc[] = $row['username'];
$rowc[] = astercrm::FormatSec(strtotime(date("Y-m-d H:i:s")) - strtotime($row['last_login_time']));
$rowc[] = $row['last_login_time'];
$table->addRow("astercrm_accout", $rowc, 0, 0, 0, $divName, $fields);
}
// End Editable Zone
$html = $table->render('delGrid');
return $html;
}
/**
* generate grid HTML code
* @param start int record start
* @param limit int how many records need
* @param filter string the field need to search
* @param content string the contect want to match
* @param divName string which div grid want to be put
* @param order string data order
* @return html string grid HTML code
*/
function createGrid($start = 0, $limit = 1, $filter = null, $content = null, $order = null, $divName = "grid", $ordering = "", $exportFlag = "", $stype = array(), $displaymode = 'on')
{
global $locate, $config;
$_SESSION['ordering'] = $ordering;
if ($filter == null or $content == null || !is_array($content) && $content == 'Array' || !is_array(filter) && $filter == 'Array') {
$content = null;
$filter = null;
$numRows =& Customer::getNumRows($displaymode);
$arreglo =& Customer::getAllRecords($start, $limit, $order, $displaymode);
} else {
foreach ($content as $value) {
if (trim($value) != "") {
//搜索内容有值
$flag = "1";
break;
}
}
foreach ($filter as $value) {
if (trim($value) != "") {
//搜索条件有值
$flag2 = "1";
break;
}
}
foreach ($stype as $value) {
if (trim($value) != "") {
//搜索方式有值
$flag3 = "1";
break;
}
}
if ($flag != "1" || $flag2 != "1") {
//无值
$order = null;
$numRows =& Customer::getNumRows();
$arreglo =& Customer::getAllRecords($start, $limit, $order);
} elseif ($flag3 != 1) {
$order = "id";
$numRows =& Customer::getNumRowsMore($filter, $content, "callshoprate");
$arreglo =& Customer::getRecordsFilteredMore($start, $limit, $filter, $content, $order, "callshoprate");
} else {
$order = "id";
$numRows =& Customer::getNumRowsMorewithstype($filter, $content, $stype, $table, $displaymode);
$arreglo =& Customer::getRecordsFilteredMorewithstype($start, $limit, $filter, $content, $stype, $order, $table, $displaymode);
}
}
// Select Box: type table.
$typeFromSearch = array();
$typeFromSearch[] = 'like';
$typeFromSearch[] = 'equal';
$typeFromSearch[] = 'more';
$typeFromSearch[] = 'less';
// Selecct Box: Labels showed on searchtype select box.
$typeFromSearchShowAs = array();
$typeFromSearchShowAs[] = $locate->Translate("like");
$typeFromSearchShowAs[] = '=';
$typeFromSearchShowAs[] = '>';
$typeFromSearchShowAs[] = '<';
// Editable zone
// Databse Table: fields
$fields = array();
if ($config['synchronize']['display_synchron_server']) {
$fields[] = 'id';
}
$fields[] = 'dialprefix';
$fields[] = 'numlen';
$fields[] = 'destination';
$fields[] = 'connectcharge';
$fields[] = 'initblock';
$fields[] = 'rateinitial';
$fields[] = 'billingblock';
$fields[] = 'groupname';
$fields[] = 'resellername';
$fields[] = 'addtime';
// HTML table: Headers showed
$headers = array();
if ($config['synchronize']['display_synchron_server']) {
$headers[] = $locate->Translate("Id") . '<br>';
}
$headers[] = $locate->Translate("Prefix") . '<br>';
$headers[] = $locate->Translate("Length") . '<br>';
$headers[] = $locate->Translate("Destination") . '<br>';
$headers[] = $locate->Translate("Connect Charge") . '<br>';
$headers[] = $locate->Translate("Init Block") . '<br>';
$headers[] = $locate->Translate("Rate") . '<br>';
$headers[] = $locate->Translate("Billing Block") . '<br>';
$headers[] = $locate->Translate("Group") . '<br>';
$headers[] = $locate->Translate("Reseller") . '<br>';
$headers[] = $locate->Translate("Addtime") . '<br>';
// HTML table: hearders attributes
$attribsHeader = array();
$attribsHeader[] = 'width=""';
$attribsHeader[] = 'width=""';
$attribsHeader[] = 'width=""';
$attribsHeader[] = 'width=""';
$attribsHeader[] = 'width=""';
$attribsHeader[] = 'width=""';
$attribsHeader[] = 'width=""';
$attribsHeader[] = 'width=""';
$attribsHeader[] = 'width=""';
$attribsHeader[] = 'width=""';
// HTML Table: columns attributes
$attribsCols = array();
$attribsCols[] = 'style="text-align: left"';
$attribsCols[] = 'style="text-align: left"';
$attribsCols[] = 'style="text-align: left"';
$attribsCols[] = 'style="text-align: left"';
$attribsCols[] = 'style="text-align: left"';
$attribsCols[] = 'style="text-align: left"';
$attribsCols[] = 'style="text-align: left"';
$attribsCols[] = 'style="text-align: left"';
$attribsCols[] = 'style="text-align: left"';
$attribsCols[] = 'style="text-align: left"';
// HTML Table: If you want ascendent and descendent ordering, set the Header Events.
$eventHeader = array();
if ($config['synchronize']['display_synchron_server']) {
$eventHeader[] = 'onClick=\'xajax_showGrid(0,' . $limit . ',"' . $filter . '","' . $content . '","id","' . $divName . '","ORDERING");return false;\'';
}
$eventHeader[] = 'onClick=\'xajax_showGrid(0,' . $limit . ',"' . $filter . '","' . $content . '","dialprefix","' . $divName . '","ORDERING");return false;\'';
$eventHeader[] = 'onClick=\'xajax_showGrid(0,' . $limit . ',"' . $filter . '","' . $content . '","numlen","' . $divName . '","ORDERING");return false;\'';
$eventHeader[] = 'onClick=\'xajax_showGrid(0,' . $limit . ',"' . $filter . '","' . $content . '","destination","' . $divName . '","ORDERING");return false;\'';
$eventHeader[] = 'onClick=\'xajax_showGrid(0,' . $limit . ',"' . $filter . '","' . $content . '","connectcharge","' . $divName . '","ORDERING");return false;\'';
$eventHeader[] = 'onClick=\'xajax_showGrid(0,' . $limit . ',"' . $filter . '","' . $content . '","initblock","' . $divName . '","ORDERING");return false;\'';
$eventHeader[] = 'onClick=\'xajax_showGrid(0,' . $limit . ',"' . $filter . '","' . $content . '","rateinitial","' . $divName . '","ORDERING");return false;\'';
$eventHeader[] = 'onClick=\'xajax_showGrid(0,' . $limit . ',"' . $filter . '","' . $content . '","billingblock","' . $divName . '","ORDERING");return false;\'';
$eventHeader[] = 'onClick=\'xajax_showGrid(0,' . $limit . ',"' . $filter . '","' . $content . '","groupname","' . $divName . '","ORDERING");return false;\'';
$eventHeader[] = 'onClick=\'xajax_showGrid(0,' . $limit . ',"' . $filter . '","' . $content . '","resellername","' . $divName . '","ORDERING");return false;\'';
$eventHeader[] = 'onClick=\'xajax_showGrid(0,' . $limit . ',"' . $filter . '","' . $content . '","addtime","' . $divName . '","ORDERING");return false;\'';
// Select Box: fields table.
$fieldsFromSearch = array();
$fieldsFromSearch[] = 'dialprefix';
$fieldsFromSearch[] = 'numlen';
$fieldsFromSearch[] = 'destination';
$fieldsFromSearch[] = 'rateinitial';
$fieldsFromSearch[] = 'initblock';
$fieldsFromSearch[] = 'billingblock';
$fieldsFromSearch[] = 'connectcharge';
$fieldsFromSearch[] = 'groupname';
$fieldsFromSearch[] = 'resellername';
$fieldsFromSearch[] = 'callshoprate.addtime';
// Selecct Box: Labels showed on search select box.
$fieldsFromSearchShowAs = array();
$fieldsFromSearchShowAs[] = $locate->Translate('prefix');
$fieldsFromSearchShowAs[] = $locate->Translate('length');
$fieldsFromSearchShowAs[] = $locate->Translate('destination');
$fieldsFromSearchShowAs[] = $locate->Translate('rate');
$fieldsFromSearchShowAs[] = $locate->Translate('init block');
$fieldsFromSearchShowAs[] = $locate->Translate('billing block');
$fieldsFromSearchShowAs[] = $locate->Translate('connect charge');
$fieldsFromSearchShowAs[] = $locate->Translate('group');
$fieldsFromSearchShowAs[] = $locate->Translate('reseller');
$fieldsFromSearchShowAs[] = $locate->Translate('addtime');
// Create object whit 5 cols and all data arrays set before.
$table = new ScrollTable(6, $start, $limit, $filter, $numRows, $content, $order);
if ($_SESSION['curuser']['usertype'] == 'admin' || $_SESSION['curuser']['usertype'] == 'reseller') {
$table->setHeader('title', $headers, $attribsHeader, $eventHeader, 1, 1, 0);
$table->deleteFlag = '1';
//对导出标记进行赋值
$table->multiEditFlag = '1';
//对批量修改标记进行赋值
} else {
$table->setHeader('title', $headers, $attribsHeader, $eventHeader, 0, 0, 0);
}
$table->setAttribsCols($attribsCols);
$table->exportFlag = '1';
//对导出标记进行赋值
if ($_SESSION['curuser']['usertype'] == 'admin' || $_SESSION['curuser']['usertype'] == 'reseller') {
$table->addRowSearchMore("callshoprate", $fieldsFromSearch, $fieldsFromSearchShowAs, $filter, $content, $start, $limit, 1, $typeFromSearch, $typeFromSearchShowAs, $stype);
} else {
$table->addRowSearchMore("callshoprate", $fieldsFromSearch, $fieldsFromSearchShowAs, $filter, $content, $start, $limit, 0, $typeFromSearch, $typeFromSearchShowAs, $stype, $displaymode);
}
if ($config['synchronize']['display_synchron_server']) {
$otherHost = $config['synchronize_host']['Host'];
$hostArray = explode(',', trim($otherHost, ','));
}
while ($arreglo->fetchInto($row)) {
// Change here by the name of fields of its database table
$rowc = array();
$rowc[] = $row['id'];
if ($config['synchronize']['display_synchron_server']) {
$existFlag = false;
foreach ($hostArray as $tmp) {
if ($row['id'] >= $config['synchronize_host'][$tmp . '_minId'] && $row['id'] <= $config['synchronize_host'][$tmp . '_maxId']) {
$rowc[] = $row['id'] . '(' . $config['synchronize_host'][$tmp] . ')';
$existFlag = true;
}
}
if (!$existFlag) {
$rowc[] = $row['id'] . '(' . $locate->Translate("Local") . ')';
}
}
$rowc[] = $row['dialprefix'];
$rowc[] = $row['numlen'];
$rowc[] = $row['destination'];
$rowc[] = $row['connectcharge'];
$rowc[] = $row['initblock'];
$rowc[] = $row['rateinitial'];
$rowc[] = $row['billingblock'];
$rowc[] = $row['groupname'];
$rowc[] = $row['resellername'];
$rowc[] = $row['addtime'];
if ($_SESSION['curuser']['usertype'] == 'admin' || $_SESSION['curuser']['usertype'] == 'reseller') {
if ($_SESSION['curuser']['usertype'] == 'reseller' && $row['resellerid'] != $_SESSION['curuser']['resellerid']) {
$table->addRow("myrate", $rowc, 0, 0, 0, $divName, $fields);
} else {
$table->addRow("callshoprate", $rowc, 1, 1, 0, $divName, $fields);
}
} else {
$table->addRow("callshoprate", $rowc, 0, 0, 0, $divName, $fields);
}
}
// End Editable Zone
$html = $table->render();
return $html;
}
function createGrid($start = 0, $limit = 1, $filter = null, $content = null, $order = null, $divName = "grid", $ordering = "", $stype = array(), $action = '', $campaign_id = 0)
{
if ($action == 'abandoned' && $campaign_id > 0) {
$campaignrow = astercrm::getRecordById($campaign_id, 'campaign');
$filter = array('campaigndialedlist.billsec_leg_a', 'campaigndialedlist.billsec', 'campaignname');
$content = array(0, 0, $campaignrow['campaignname']);
$stype = array('more', 'equal', 'equal');
}
global $locate;
$_SESSION['ordering'] = $ordering;
if ($filter == null or $content == null or $content == 'Array' or $filter == 'Array') {
$numRows =& Customer::getNumRows();
$arreglo =& Customer::getAllRecords($start, $limit, $order);
$content = null;
$filter = null;
} else {
foreach ($content as $value) {
if (trim($value) != "") {
//搜索内容有值
$flag = "1";
break;
}
}
foreach ($filter as $value) {
if (trim($value) != "") {
//搜索条件有值
$flag2 = "1";
break;
}
}
foreach ($stype as $value) {
if (trim($value) != "") {
//搜索方式有值
$flag3 = "1";
break;
}
}
if ($flag != "1" || $flag2 != "1") {
//无值
if (is_array($order) || $order == '') {
$order = null;
}
$numRows =& Customer::getNumRows($_SESSION['curuser']['groupid']);
$arreglo =& Customer::getAllRecords($start, $limit, $order, $_SESSION['curuser']['groupid']);
} elseif ($flag3 != 1) {
$order = "id";
$numRows =& Customer::getNumRowsMore($filter, $content, "campaigndialedlist");
$arreglo =& Customer::getRecordsFilteredMore($start, $limit, $filter, $content, $order, "campaigndialedlist");
} else {
$order = "id";
$numRows =& Customer::getNumRowsMorewithstype($filter, $content, $stype, $table);
$arreglo =& Customer::getRecordsFilteredMorewithstype($start, $limit, $filter, $content, $stype, $order, $table);
}
}
// Select Box: type table.
$typeFromSearch = array();
$typeFromSearch[] = 'like';
$typeFromSearch[] = 'equal';
$typeFromSearch[] = 'more';
$typeFromSearch[] = 'less';
// Selecct Box: Labels showed on searchtype select box.
$typeFromSearchShowAs = array();
$typeFromSearchShowAs[] = $locate->Translate("like");
$typeFromSearchShowAs[] = '=';
$typeFromSearchShowAs[] = '>';
$typeFromSearchShowAs[] = '<';
// Editable zone
// Databse Table: fields
$fields = array();
$fields[] = 'dialednumber';
$fields[] = 'answertime';
$fields[] = 'duration';
$fields[] = 'callresult';
$fields[] = 'billsec';
$fields[] = 'billsec_leg_a';
$fields[] = 'customer';
$fields[] = 'customername';
// $fields[] = 'uniqueid';
$fields[] = 'campaignresult';
$fields[] = 'response';
$fields[] = 'detect';
$fields[] = 'transfertime';
$fields[] = 'transfertarget';
$fields[] = 'resultby';
$fields[] = 'dialedby';
// $fields[] = 'groupname';
$fields[] = 'recycles';
// HTML table: Headers showed
$headers = array();
$headers[] = $locate->Translate("ALL") . "<input type='checkbox' onclick=\"ckbAllOnClick(this);\"><BR \\>";
$headers[] = $locate->Translate("Dialed Number");
// $headers[] = $locate->Translate("Answer Time");
$headers[] = $locate->Translate("Duration");
$headers[] = $locate->Translate("Billsec");
$headers[] = $locate->Translate("Total Billsec");
$headers[] = $locate->Translate("Call Result");
$headers[] = $locate->Translate("Customer");
$headers[] = $locate->Translate("Name");
// $headers[] = $locate->Translate("Uniqueid");
$headers[] = $locate->Translate("Campaign Result");
$headers[] = $locate->Translate("Response");
$headers[] = $locate->Translate("Detect");
$headers[] = $locate->Translate("Transfertime");
$headers[] = $locate->Translate("Transfertarget");
$headers[] = $locate->Translate("Result By");
$headers[] = $locate->Translate("Tried");
$headers[] = $locate->Translate("Dialed Time");
// $headers[] = $locate->Translate("Group");
$headers[] = $locate->Translate("Campaign");
$headers[] = $locate->Translate("Recycles");
// HTML table: hearders attributes
$attribsHeader = array();
$attribsHeader[] = 'width=""';
$attribsHeader[] = 'width=""';
$attribsHeader[] = 'width=""';
$attribsHeader[] = 'width=""';
$attribsHeader[] = 'width=""';
$attribsHeader[] = 'width=""';
$attribsHeader[] = 'width=""';
$attribsHeader[] = 'width=""';
$attribsHeader[] = 'width=""';
$attribsHeader[] = 'width=""';
$attribsHeader[] = 'width=""';
$attribsHeader[] = 'width=""';
$attribsHeader[] = 'width=""';
$attribsHeader[] = 'width=""';
$attribsHeader[] = 'width=""';
$attribsHeader[] = 'width=""';
$attribsHeader[] = 'width=""';
// $attribsHeader[] = 'width=""';
// HTML Table: columns attributes
$attribsCols = array();
$attribsCols[] = 'style="text-align: left"';
$attribsCols[] = 'style="text-align: left"';
$attribsCols[] = 'style="text-align: left"';
$attribsCols[] = 'style="text-align: left"';
$attribsCols[] = 'style="text-align: left"';
$attribsCols[] = 'style="text-align: left"';
$attribsCols[] = 'style="text-align: left"';
$attribsCols[] = 'style="text-align: left"';
$attribsCols[] = 'style="text-align: left"';
$attribsCols[] = 'style="text-align: left"';
$attribsCols[] = 'style="text-align: left"';
$attribsCols[] = 'style="text-align: left"';
$attribsCols[] = 'style="text-align: left"';
// $attribsCols[] = 'style="text-align: left"';
// $attribsCols[] = 'style="text-align: left"';
// $attribsCols[] = 'style="text-align: left"';
// HTML Table: If you want ascendent and descendent ordering, set the Header Events.
$eventHeader = array();
$eventHeader[] = '';
$eventHeader[] = 'onClick=\'xajax_showGrid(0,' . $limit . ',"' . $filter . '","' . $content . '","dialednumber","' . $divName . '","ORDERING");return false;\'';
// $eventHeader[]= 'onClick=\'xajax_showGrid(0,'.$limit.',"'.$filter.'","'.$content.'","answertime","'.$divName.'","ORDERING");return false;\'';
$eventHeader[] = 'onClick=\'xajax_showGrid(0,' . $limit . ',"' . $filter . '","' . $content . '","duration","' . $divName . '","ORDERING");return false;\'';
$eventHeader[] = 'onClick=\'xajax_showGrid(0,' . $limit . ',"' . $filter . '","' . $content . '","billsec","' . $divName . '","ORDERING");return false;\'';
$eventHeader[] = 'onClick=\'xajax_showGrid(0,' . $limit . ',"' . $filter . '","' . $content . '","billsec_leg_a","' . $divName . '","ORDERING");return false;\'';
$eventHeader[] = 'onClick=\'xajax_showGrid(0,' . $limit . ',"' . $filter . '","' . $content . '","callresult","' . $divName . '","ORDERING");return false;\'';
$eventHeader[] = 'onClick=\'xajax_showGrid(0,' . $limit . ',"' . $filter . '","' . $content . '","customer","' . $divName . '","ORDERING");return false;\'';
$eventHeader[] = 'onClick=\'xajax_showGrid(0,' . $limit . ',"' . $filter . '","' . $content . '","customername","' . $divName . '","ORDERING");return false;\'';
// $eventHeader[]= 'onClick=\'xajax_showGrid(0,'.$limit.',"'.$filter.'","'.$content.'","uniqueid","'.$divName.'","ORDERING");return false;\'';
$eventHeader[] = 'onClick=\'xajax_showGrid(0,' . $limit . ',"' . $filter . '","' . $content . '","campaignresult","' . $divName . '","ORDERING");return false;\'';
$eventHeader[] = 'onClick=\'xajax_showGrid(0,' . $limit . ',"' . $filter . '","' . $content . '","response","' . $divName . '","ORDERING");return false;\'';
$eventHeader[] = 'onClick=\'xajax_showGrid(0,' . $limit . ',"' . $filter . '","' . $content . '","detect","' . $divName . '","ORDERING");return false;\'';
$eventHeader[] = 'onClick=\'xajax_showGrid(0,' . $limit . ',"' . $filter . '","' . $content . '","transfertime","' . $divName . '","ORDERING");return false;\'';
$eventHeader[] = 'onClick=\'xajax_showGrid(0,' . $limit . ',"' . $filter . '","' . $content . '","transfertarget","' . $divName . '","ORDERING");return false;\'';
$eventHeader[] = 'onClick=\'xajax_showGrid(0,' . $limit . ',"' . $filter . '","' . $content . '","resultby","' . $divName . '","ORDERING");return false;\'';
$eventHeader[] = 'onClick=\'xajax_showGrid(0,' . $limit . ',"' . $filter . '","' . $content . '","trytime","' . $divName . '","ORDERING");return false;\'';
$eventHeader[] = 'onClick=\'xajax_showGrid(0,' . $limit . ',"' . $filter . '","' . $content . '","dialedtime","' . $divName . '","ORDERING");return false;\'';
// $eventHeader[]= 'onClick=\'xajax_showGrid(0,'.$limit.',"'.$filter.'","'.$content.'","groupname","'.$divName.'","ORDERING");return false;\'';
$eventHeader[] = 'onClick=\'xajax_showGrid(0,' . $limit . ',"' . $filter . '","' . $content . '","campaignname","' . $divName . '","ORDERING");return false;\'';
$eventHeader[] = 'onClick=\'xajax_showGrid(0,' . $limit . ',"' . $filter . '","' . $content . '","recycles","' . $divName . '","ORDERING");return false;\'';
// Select Box: fields table.
$fieldsFromSearch = array();
$fieldsFromSearch[] = 'dialednumber';
//$fieldsFromSearch[] = 'answertime';
$fieldsFromSearch[] = 'duration';
$fieldsFromSearch[] = 'campaigndialedlist.billsec';
$fieldsFromSearch[] = 'campaigndialedlist.billsec_leg_a';
$fieldsFromSearch[] = 'callresult';
$fieldsFromSearch[] = 'customer';
$fieldsFromSearch[] = 'customername';
$fieldsFromSearch[] = 'uniqueid';
$fieldsFromSearch[] = 'response';
$fieldsFromSearch[] = 'detect';
$fieldsFromSearch[] = 'campaignresult';
$fieldsFromSearch[] = 'transfertarget';
$fieldsFromSearch[] = 'resultby';
$fieldsFromSearch[] = 'dialedby';
$fieldsFromSearch[] = 'trytime';
$fieldsFromSearch[] = 'dialedtime';
$fieldsFromSearch[] = 'groupname';
$fieldsFromSearch[] = 'campaignname';
$fieldsFromSearch[] = 'recycles';
// Selecct Box: Labels showed on search select box.
$fieldsFromSearchShowAs = array();
$fieldsFromSearchShowAs[] = $locate->Translate("Dialed Number");
//$fieldsFromSearchShowAs[] = $locate->Translate("Answer Time");
$fieldsFromSearchShowAs[] = $locate->Translate("Duration");
$fieldsFromSearchShowAs[] = $locate->Translate("Billsec");
$fieldsFromSearchShowAs[] = $locate->Translate("Total Billsec");
$fieldsFromSearchShowAs[] = $locate->Translate("Call Result");
$fieldsFromSearchShowAs[] = $locate->Translate("Customer");
$fieldsFromSearchShowAs[] = $locate->Translate("Name");
$fieldsFromSearchShowAs[] = $locate->Translate("Uniqueid");
$fieldsFromSearchShowAs[] = $locate->Translate("Response");
$fieldsFromSearchShowAs[] = $locate->Translate("Detect");
$fieldsFromSearchShowAs[] = $locate->Translate("Campaign Result");
$fieldsFromSearchShowAs[] = $locate->Translate("Transfertarget");
$fieldsFromSearchShowAs[] = $locate->Translate("Result By");
$fieldsFromSearchShowAs[] = $locate->Translate("Dialed By");
$fieldsFromSearchShowAs[] = $locate->Translate("Tried");
$fieldsFromSearchShowAs[] = $locate->Translate("Dialed time");
$fieldsFromSearchShowAs[] = $locate->Translate("Group");
$fieldsFromSearchShowAs[] = $locate->Translate("Campaign");
$fieldsFromSearchShowAs[] = $locate->Translate("Recycles");
// Create object whit 5 cols and all data arrays set before.
$table = new ScrollTable(6, $start, $limit, $filter, $numRows, $content, $order);
$table->exportFlag = '2';
//对导出标记进行赋值
$table->deleteFlag = '1';
//对删除标记进行赋值
$table->ordering = $ordering;
$editFlag = 1;
$deleteFlag = 1;
$deleteBtnFlag = 1;
if ($_SESSION['curuser']['usertype'] != 'admin' && $_SESSION['curuser']['usertype'] != 'groupadmin') {
if ($_SESSION['curuser']['privileges']['dialedlist']['delete']) {
$deleteFlag = 1;
$table->deleteFlag = '1';
$deleteBtnFlag = 1;
} else {
$deleteFlag = 0;
$table->deleteFlag = '0';
$deleteBtnFlag = 0;
}
if ($_SESSION['curuser']['privileges']['dialedlist']['edit']) {
$editFlag = 1;
} else {
$editFlag = 0;
}
}
$table->setHeader('title', $headers, $attribsHeader, $eventHeader, 0, $deleteFlag, 0);
$table->setAttribsCols($attribsCols);
$table->addRowSearchMore("campaigndialedlist", $fieldsFromSearch, $fieldsFromSearchShowAs, $filter, $content, $start, $limit, 0, $deleteBtnFlag, $typeFromSearch, $typeFromSearchShowAs, $stype);
while ($arreglo->fetchInto($row)) {
// Change here by the name of fields of its database table
$rowc = array();
$rowc[] = $row['id'];
$rowc['select_id'] = $row['id'];
$rowc[] = $row['dialednumber'];
// $rowc[] = $row['answertime'];
$rowc[] = astercrm::FormatSec($row['duration']);
$rowc[] = astercrm::FormatSec($row['billsec']);
$rowc[] = astercrm::FormatSec($row['billsec_leg_a']);
$rowc[] = $row['callresult'];
$rowc[] = $row['customer'];
$rowc[] = $row['customername'];
// $rowc[] = $row['uniqueid'];
$rowc[] = $row['campaignresult'];
$rowc[] = $row['response'];
$rowc[] = $row['detect'];
$rowc[] = $row['transfertime'];
$rowc[] = $row['transfertarget'];
$rowc[] = $row['resultby'];
$rowc[] = $row['trytime'];
$rowc[] = $row['dialedtime'];
// $rowc[] = $row['groupname'];
$rowc[] = $row['campaignname'];
$rowc[] = $row['recycles'];
$table->addRow("campaigndialedlist", $rowc, 0, $deleteFlag, 0, $divName, $fields);
}
// End Editable Zone
$html = $table->render('delGrid');
return $html;
}
/**
* generate grid HTML code
* @param start int record start
* @param limit int how many records need
* @param filter string the field need to search
* @param content string the contect want to match
* @param divName string which div grid want to be put
* @param order string data order
* @return html string grid HTML code
*/
function createGrid($start = 0, $limit = 1, $filter = null, $content = null, $order = null, $divName = "grid", $ordering = "", $stype = array())
{
global $locate;
$_SESSION['ordering'] = $ordering;
if ($filter == null or $content == null or $content == 'Array' or $filter == 'Array') {
$numRows =& Customer::getNumRows();
$arreglo =& Customer::getAllRecords($start, $limit, $order);
$content = null;
$filter = null;
} else {
foreach ($content as $value) {
if (trim($value) != "") {
//搜索内容有值
$flag = "1";
break;
}
}
foreach ($filter as $value) {
if (trim($value) != "") {
//搜索条件有值
$flag2 = "1";
break;
}
}
foreach ($stype as $value) {
if (trim($value) != "") {
//搜索方式有值
$flag3 = "1";
break;
}
}
if ($flag != "1" || $flag2 != "1") {
//无值
if (is_array($order) || $order == '') {
$order = null;
}
$numRows =& Customer::getNumRows();
$arreglo =& Customer::getAllRecords($start, $limit, $order);
} elseif ($flag3 != 1) {
$order = "id";
$numRows =& Customer::getNumRowsMore($filter, $content, "worktimepackages");
$arreglo =& Customer::getRecordsFilteredMore($start, $limit, $filter, $content, $order, "worktimepackages");
} else {
$order = "id";
$numRows =& Customer::getNumRowsMorewithstype($filter, $content, $stype, $table);
$arreglo =& Customer::getRecordsFilteredMorewithstype($start, $limit, $filter, $content, $stype, $order, $table);
}
}
// Select Box: type table.
$typeFromSearch = array();
$typeFromSearch[] = 'like';
$typeFromSearch[] = 'equal';
$typeFromSearch[] = 'more';
$typeFromSearch[] = 'less';
// Selecct Box: Labels showed on searchtype select box.
$typeFromSearchShowAs = array();
$typeFromSearchShowAs[] = $locate->Translate("like");
$typeFromSearchShowAs[] = '=';
$typeFromSearchShowAs[] = '>';
$typeFromSearchShowAs[] = '<';
// Editable zone
// Databse Table: fields
$fields = array();
$fields[] = 'starttime';
$fields[] = 'endtime';
$fields[] = 'startweek';
$fields[] = 'endweek';
$fields[] = 'groupname';
$fields[] = 'cretime';
$fields[] = 'creby';
// HTML table: Headers showed
$headers = array();
$headers[] = $locate->Translate("Start Time");
$headers[] = $locate->Translate("End Time");
$headers[] = $locate->Translate("Start Week");
$headers[] = $locate->Translate("End Week");
$headers[] = $locate->Translate("Group Name");
$headers[] = $locate->Translate("Cretime");
$headers[] = $locate->Translate("Creby");
// HTML table: hearders attributes
$attribsHeader = array();
$attribsHeader[] = 'width=""';
$attribsHeader[] = 'width=""';
$attribsHeader[] = 'width=""';
$attribsHeader[] = 'width=""';
$attribsHeader[] = 'width=""';
$attribsHeader[] = 'width=""';
$attribsHeader[] = 'width=""';
// HTML Table: columns attributes
$attribsCols = array();
$attribsCols[] = 'style="text-align: left"';
$attribsCols[] = 'style="text-align: left"';
$attribsCols[] = 'style="text-align: left"';
$attribsCols[] = 'style="text-align: left"';
$attribsCols[] = 'style="text-align: left"';
$attribsCols[] = 'style="text-align: left"';
$attribsCols[] = 'style="text-align: left"';
// HTML Table: If you want ascendent and descendent ordering, set the Header Events.
$eventHeader = array();
$eventHeader[] = 'onClick=\'xajax_showGrid(0,' . $limit . ',"' . $filter . '","' . $content . '","starttime","' . $divName . '","ORDERING");return false;\'';
$eventHeader[] = 'onClick=\'xajax_showGrid(0,' . $limit . ',"' . $filter . '","' . $content . '","endtime","' . $divName . '","ORDERING");return false;\'';
$eventHeader[] = 'onClick=\'xajax_showGrid(0,' . $limit . ',"' . $filter . '","' . $content . '","startweek","' . $divName . '","ORDERING");return false;\'';
$eventHeader[] = 'onClick=\'xajax_showGrid(0,' . $limit . ',"' . $filter . '","' . $content . '","endweek","' . $divName . '","ORDERING");return false;\'';
$eventHeader[] = 'onClick=\'xajax_showGrid(0,' . $limit . ',"' . $filter . '","' . $content . '","groupname","' . $divName . '","ORDERING");return false;\'';
$eventHeader[] = 'onClick=\'xajax_showGrid(0,' . $limit . ',"' . $filter . '","' . $content . '","worktimes.cretime","' . $divName . '","ORDERING");return false;\'';
$eventHeader[] = 'onClick=\'xajax_showGrid(0,' . $limit . ',"' . $filter . '","' . $content . '","worktimes.creby","' . $divName . '","ORDERING");return false;\'';
// Select Box: fields table.
$fieldsFromSearch = array();
$fieldsFromSearch[] = 'starttime';
$fieldsFromSearch[] = 'endtime';
$fieldsFromSearch[] = 'startweek';
$fieldsFromSearch[] = 'endweek';
$fieldsFromSearch[] = 'groupname';
$fieldsFromSearch[] = 'worktimes.cretime';
$fieldsFromSearch[] = 'worktimes.creby';
// Selecct Box: Labels showed on search select box.
$fieldsFromSearchShowAs = array();
$fieldsFromSearchShowAs[] = $locate->Translate("Start Time");
$fieldsFromSearchShowAs[] = $locate->Translate("End Time");
$fieldsFromSearchShowAs[] = $locate->Translate("Start Week");
$fieldsFromSearchShowAs[] = $locate->Translate("End Week");
$fieldsFromSearchShowAs[] = $locate->Translate("Group Name");
$fieldsFromSearchShowAs[] = $locate->Translate("Cretime");
$fieldsFromSearchShowAs[] = $locate->Translate("Creby");
// Create object whit 5 cols and all data arrays set before.
$table = new ScrollTable(6, $start, $limit, $filter, $numRows, $content, $order);
$table->exportFlag = '1';
//对导出标记进行赋值
$table->ordering = $ordering;
$editFlag = 1;
$deleteFlag = 1;
if ($_SESSION['curuser']['usertype'] != 'admin' && $_SESSION['curuser']['usertype'] != 'groupadmin') {
if ($_SESSION['curuser']['privileges']['worktime']['delete']) {
$deleteFlag = 1;
} else {
$deleteFlag = 0;
}
if ($_SESSION['curuser']['privileges']['worktime']['edit']) {
$editFlag = 1;
} else {
$editFlag = 0;
}
}
$table->setHeader('title', $headers, $attribsHeader, $eventHeader, $editFlag, $deleteFlag, 0);
$table->setAttribsCols($attribsCols);
$table->addRowSearchMore("worktimes", $fieldsFromSearch, $fieldsFromSearchShowAs, $filter, $content, $start, $limit, 1, 0, $typeFromSearch, $typeFromSearchShowAs, $stype);
$weekShow = array('', $locate->Translate("Monday"), $locate->Translate('Tuesday'), $locate->Translate('Wednesday'), $locate->Translate('Thursday'), $locate->Translate('Friday'), $locate->Translate('Saturday'), $locate->Translate('Sunday'));
while ($arreglo->fetchInto($row)) {
// Change here by the name of fields of its database table
$rowc = array();
$rowc[] = $row['id'];
$rowc[] = $row['starttime'];
$rowc[] = $row['endtime'];
$rowc[] = $weekShow[$row['startweek']];
$rowc[] = $weekShow[$row['endweek']];
$rowc[] = $row['groupname'];
$rowc[] = $row['cretime'];
$rowc[] = $row['creby'];
$table->addRow("worktimes", $rowc, $editFlag, $deleteFlag, 0, $divName, $fields);
}
// End Editable Zone
$html = $table->render();
return $html;
}
/**
* generate grid HTML code
* @param start int record start
* @param limit int how many records need
* @param filter string the field need to search
* @param content string the contect want to match
* @param divName string which div grid want to be put
* @param order string data order
* @return html string grid HTML code
*/
function createGrid($start = 0, $limit = 1, $filter = null, $content = null, $order = null, $divName = "grid", $ordering = "")
{
global $locate;
$_SESSION['ordering'] = $ordering;
if ($filter == null or $content == null or $content == 'Array' or $filter == 'Array') {
$numRows =& Customer::getNumRows();
$arreglo =& Customer::getAllRecords($start, $limit, $order);
$content = null;
$filter = null;
} else {
foreach ($content as $value) {
if (trim($value) != "") {
//搜索内容有值
$flag = "1";
break;
}
}
foreach ($filter as $value) {
if (trim($value) != "") {
//搜索条件有值
$flag2 = "1";
break;
}
}
if ($flag != "1" || $flag2 != "1") {
//无值
$order = null;
$numRows =& Customer::getNumRows();
$arreglo =& Customer::getAllRecords($start, $limit, $order);
} else {
$order = "id";
$numRows =& Customer::getNumRowsMore($filter, $content, "remindercalls");
$arreglo =& Customer::getRecordsFilteredMore($start, $limit, $filter, $content, $order, "remindercalls");
}
}
// Editable zone
// Databse Table: fields
$fields = array();
$fields[] = 'phonenumber';
$fields[] = 'status';
$fields[] = 'result';
$fields[] = 'note';
$fields[] = 'asteriskcallsname';
$fields[] = 'groupname';
$fields[] = 'creby';
$fields[] = 'cretime';
// HTML table: Headers showed
$headers = array();
$headers[] = $locate->Translate("Number");
$headers[] = $locate->Translate("Status");
$headers[] = $locate->Translate("Result");
$headers[] = $locate->Translate("Note");
$headers[] = $locate->Translate("Plan name");
$headers[] = $locate->Translate("Groupname");
$headers[] = $locate->Translate("Creby");
$headers[] = $locate->Translate("Cretime");
// HTML table: hearders attributes
$attribsHeader = array();
$attribsHeader[] = 'width="15%"';
$attribsHeader[] = 'width="10%"';
$attribsHeader[] = 'width="15%"';
$attribsHeader[] = 'width="15%"';
$attribsHeader[] = 'width="10%"';
$attribsHeader[] = 'width="10%"';
$attribsHeader[] = 'width="10%"';
$attribsHeader[] = 'width="15%"';
// HTML Table: columns attributes
$attribsCols = array();
$attribsCols[] = 'style="text-align: left"';
$attribsCols[] = 'style="text-align: left"';
$attribsCols[] = 'style="text-align: left"';
$attribsCols[] = 'style="text-align: left"';
$attribsCols[] = 'style="text-align: left"';
$attribsCols[] = 'style="text-align: left"';
$attribsCols[] = 'style="text-align: left"';
$attribsCols[] = 'style="text-align: left"';
// HTML Table: If you want ascendent and descendent ordering, set the Header Events.
$eventHeader = array();
$eventHeader[] = 'onClick=\'xajax_showGrid(0,' . $limit . ',"' . $filter . '","' . $content . '","phonenumber","' . $divName . '","ORDERING");return false;\'';
$eventHeader[] = 'onClick=\'xajax_showGrid(0,' . $limit . ',"' . $filter . '","' . $content . '","status","' . $divName . '","ORDERING");return false;\'';
$eventHeader[] = 'onClick=\'xajax_showGrid(0,' . $limit . ',"' . $filter . '","' . $content . '","result","' . $divName . '","ORDERING");return false;\'';
$eventHeader[] = 'onClick=\'xajax_showGrid(0,' . $limit . ',"' . $filter . '","' . $content . '","note","' . $divName . '","ORDERING");return false;\'';
$eventHeader[] = 'onClick=\'xajax_showGrid(0,' . $limit . ',"' . $filter . '","' . $content . '","asteriskcallsname","' . $divName . '","ORDERING");return false;\'';
$eventHeader[] = 'onClick=\'xajax_showGrid(0,' . $limit . ',"' . $filter . '","' . $content . '","groupname","' . $divName . '","ORDERING");return false;\'';
$eventHeader[] = 'onClick=\'xajax_showGrid(0,' . $limit . ',"' . $filter . '","' . $content . '","creby","' . $divName . '","ORDERING");return false;\'';
$eventHeader[] = 'onClick=\'xajax_showGrid(0,' . $limit . ',"' . $filter . '","' . $content . '","cretime","' . $divName . '","ORDERING");return false;\'';
// Select Box: fields table.
$fieldsFromSearch = array();
$fieldsFromSearch[] = 'phonenumber';
$fieldsFromSearch[] = 'status';
$fieldsFromSearch[] = 'result';
$fieldsFromSearch[] = 'note';
$fieldsFromSearch[] = 'asteriskcallsname';
$fieldsFromSearch[] = 'groupname';
$fieldsFromSearch[] = 'remindercalls.creby';
$fieldsFromSearch[] = 'remindercalls.cretime';
// Selecct Box: Labels showed on search select box.
$fieldsFromSearchShowAs = array();
$fieldsFromSearchShowAs[] = $locate->Translate("Number");
$fieldsFromSearchShowAs[] = $locate->Translate("Status");
$fieldsFromSearchShowAs[] = $locate->Translate("Result");
$fieldsFromSearchShowAs[] = $locate->Translate("Note");
$fieldsFromSearchShowAs[] = $locate->Translate("Plan name");
$fieldsFromSearchShowAs[] = $locate->Translate("Group name");
$fieldsFromSearchShowAs[] = $locate->Translate("Creby");
$fieldsFromSearchShowAs[] = $locate->Translate("Cretime");
//echo 'dddddddddddddd';
// Create object whit 5 cols and all data arrays set before.
$table = new ScrollTable(6, $start, $limit, $filter, $numRows, $content, $order);
$table->setHeader('title', $headers, $attribsHeader, $eventHeader, 1, 1, 0);
$table->setAttribsCols($attribsCols);
$table->addRowSearchMore("remindercalls", $fieldsFromSearch, $fieldsFromSearchShowAs, $filter, $content, $start, $limit);
while ($arreglo->fetchInto($row)) {
// Change here by the name of fields of its database table
$rowc = array();
$rowc[] = $row['id'];
$rowc[] = '<a href="?" onclick="return false;">' . $row['phonenumber'] . '</a>';
$rowc[] = $row['status'];
$rowc[] = $row['result'];
$rowc[] = $row['note'];
$rowc[] = $row['asteriskcallsname'];
$rowc[] = $row['groupname'];
$rowc[] = $row['creby'];
$rowc[] = $row['cretime'];
$table->addRow("remindercalls", $rowc, 1, 1, 0, $divName, $fields);
}
// End Editable Zone
$html = $table->render();
return $html;
}
/**
* generate grid HTML code
* @param start int record start
* @param limit int how many records need
* @param filter string the field need to search
* @param content string the contect want to match
* @param divName string which div grid want to be put
* @param order string data order
* @return html string grid HTML code
*/
function createGrid($start = 0, $limit = 1, $filter = null, $content = null, $order = null, $divName = "grid", $ordering = "", $stype = array())
{
global $locate;
$_SESSION['ordering'] = $ordering;
if ($filter == null or $content == null or $content == 'Array' or $filter == 'Array') {
$arreglo =& Customer::getAllRecords($start, $limit, $order, $_SESSION['curuser']['groupid']);
$numRows = count($arreglo);
$content = null;
$filter = null;
} else {
foreach ($content as $value) {
if (trim($value) != "") {
//搜索内容有值
$flag = "1";
break;
}
}
foreach ($filter as $value) {
if (trim($value) != "") {
//搜索条件有值
$flag2 = "1";
break;
}
}
foreach ($stype as $value) {
if (trim($value) != "") {
//搜索方式有值
$flag3 = "1";
break;
}
}
if ($flag != "1" || $flag2 != "1") {
//无值
$arreglo =& Customer::getAllRecords($start, $limit, $order, $_SESSION['curuser']['groupid']);
$numRows = count($arreglo);
} elseif ($flag3 != 1) {
$order = "id";
$numRows =& Customer::getNumRowsMore($filter, $content);
$arreglo =& Customer::getRecordsFilteredMore($start, $limit, $filter, $content, $order);
} else {
$order = "id";
$numRows =& Customer::getNumRowsMorewithstype($filter, $content, $stype, $table);
$arreglo =& Customer::getRecordsFilteredMorewithstype($start, $limit, $filter, $content, $stype, $order, $table);
}
}
// Select Box: type table.
$typeFromSearch = array();
$typeFromSearch[] = 'like';
$typeFromSearch[] = 'equal';
$typeFromSearch[] = 'more';
$typeFromSearch[] = 'less';
// Selecct Box: Labels showed on searchtype select box.
$typeFromSearchShowAs = array();
$typeFromSearchShowAs[] = $locate->Translate("like");
$typeFromSearchShowAs[] = '=';
$typeFromSearchShowAs[] = '>';
$typeFromSearchShowAs[] = '<';
// Editable zone
// Databse Table: fields
$fields = array();
$fields[] = 'agent';
$fields[] = 'password';
$fields[] = 'name';
// HTML table: Headers showed
$headers = array();
$headers[] = $locate->Translate("Agent");
$headers[] = $locate->Translate("Password");
$headers[] = $locate->Translate("Name");
// HTML table: hearders attributes
$attribsHeader = array();
$attribsHeader[] = 'width=""';
$attribsHeader[] = 'width=""';
$attribsHeader[] = 'width=""';
// HTML Table: columns attributes
$attribsCols = array();
$attribsCols[] = 'style="text-align: left"';
$attribsCols[] = 'style="text-align: left"';
$attribsCols[] = 'style="text-align: left"';
// HTML Table: If you want ascendent and descendent ordering, set the Header Events.
$eventHeader = array();
$eventHeader[] = 'onClick=\'xajax_showGrid(0,' . $limit . ',"' . $filter . '","' . $content . '","username","' . $divName . '","ORDERING");return false;\'';
$eventHeader[] = 'onClick=\'xajax_showGrid(0,' . $limit . ',"' . $filter . '","' . $content . '","password","' . $divName . '","ORDERING");return false;\'';
$eventHeader[] = 'onClick=\'xajax_showGrid(0,' . $limit . ',"' . $filter . '","' . $content . '","extension","' . $divName . '","ORDERING");return false;\'';
// Create object whit 5 cols and all data arrays set before.
$table = new ScrollTable(7, $start, $limit, $filter, $numRows, $content, $order, '', '', '', 'agents');
$table->ordering = $ordering;
$editFlag = 1;
$deleteFlag = 1;
if ($_SESSION['curuser']['usertype'] != 'admin' && $_SESSION['curuser']['usertype'] != 'groupadmin') {
if ($_SESSION['curuser']['privileges']['agent']['delete']) {
$deleteFlag = 1;
} else {
$deleteFlag = 0;
}
if ($_SESSION['curuser']['privileges']['agent']['edit']) {
$editFlag = 1;
} else {
$editFlag = 0;
}
}
$table->setHeader('title', $headers, $attribsHeader, $eventHeader, $editFlag, $deleteFlag);
$table->setAttribsCols($attribsCols);
$table->addRowSearchMore("agents", $fieldsFromSearch, $fieldsFromSearchShowAs, $filter, $content, $start, $limit, 1, 0, $typeFromSearch, $typeFromSearchShowAs, 'none');
//print_r($arreglo);exit;
foreach ($arreglo as $row) {
// Change here by the name of fields of its database table
$rowc = array();
$rowc[] = $row['agent'];
$rowc[] = $row['agent'];
$rowc[] = $row['password'];
$rowc[] = $row['name'];
$table->addRow("agents", $rowc, $editFlag, $deleteFlag, 1, $divName, $fields);
}
// End Editable Zone
$html = $table->render();
return $html;
}
/**
* generate grid HTML code
* @param start int record start
* @param limit int how many records need
* @param filter string the field need to search
* @param content string the contect want to match
* @param divName string which div grid want to be put
* @param order string data order
* @return html string grid HTML code
*/
function createGrid($start = 0, $limit = 1, $filter = null, $content = null, $order = null, $divName = "grid", $ordering = "", $stype = array())
{
global $locate, $config;
$_SESSION['ordering'] = $ordering;
if ($filter == null or $content == null || !is_array($content) && $content == 'Array' || !is_array(filter) && $filter == 'Array') {
$content = null;
$filter = null;
$numRows =& Customer::getNumRows();
$arreglo =& Customer::getAllRecords($start, $limit, $order);
} else {
foreach ($content as $value) {
if (trim($value) != "") {
//搜索内容有值
$flag = "1";
break;
}
}
foreach ($filter as $value) {
if (trim($value) != "") {
//搜索条件有值
$flag2 = "1";
break;
}
}
foreach ($stype as $value) {
if (trim($value) != "") {
//搜索方式有值
$flag3 = "1";
break;
}
}
if ($flag != "1" || $flag2 != "1") {
//无值
$order = null;
$numRows =& Customer::getNumRows();
$arreglo =& Customer::getAllRecords($start, $limit, $order);
} elseif ($flag3 != 1) {
$order = "id";
$numRows =& Customer::getNumRowsMore($filter, $content, $config['customers']['customertable']);
$arreglo =& Customer::getRecordsFilteredMore($start, $limit, $filter, $content, $order, $config['customers']['customertable']);
} else {
$order = "id";
$numRows =& Customer::getNumRowsMorewithstype($filter, $content, $stype, $config['customers']['customertable']);
$arreglo =& Customer::getRecordsFilteredMorewithstype($start, $limit, $filter, $content, $stype, $order, $config['customers']['customertable']);
}
}
// Select Box: type table.
$typeFromSearch = array();
$typeFromSearch[] = 'like';
$typeFromSearch[] = 'equal';
$typeFromSearch[] = 'more';
$typeFromSearch[] = 'less';
// Selecct Box: Labels showed on searchtype select box.
$typeFromSearchShowAs = array();
$typeFromSearchShowAs[] = $locate->Translate("like");
$typeFromSearchShowAs[] = '=';
$typeFromSearchShowAs[] = '>';
$typeFromSearchShowAs[] = '<';
// Editable zone
// Databse Table: fields
$fields = array();
$fields[] = 'pin';
$fields[] = 'first_name';
$fields[] = 'last_name';
$fields[] = 'amount';
$fields[] = 'discount';
$fields[] = 'cretime';
// HTML table: Headers showed
$headers = array();
$headers[] = $locate->Translate("Pin");
$headers[] = $locate->Translate("First name");
$headers[] = $locate->Translate("Last name");
$headers[] = $locate->Translate("Amount");
$headers[] = $locate->Translate("Discount");
$headers[] = $locate->Translate("Create time");
// HTML table: hearders attributes
$attribsHeader = array();
$attribsHeader[] = 'width=""';
$attribsHeader[] = 'width=""';
$attribsHeader[] = 'width=""';
$attribsHeader[] = 'width=""';
$attribsHeader[] = 'width=""';
$attribsHeader[] = 'width=""';
// HTML Table: columns attributes
$attribsCols = array();
$attribsCols[] = 'style="text-align: left"';
$attribsCols[] = 'style="text-align: left"';
$attribsCols[] = 'style="text-align: left"';
$attribsCols[] = 'style="text-align: left"';
$attribsCols[] = 'style="text-align: left"';
$attribsCols[] = 'style="text-align: left"';
// HTML Table: If you want ascendent and descendent ordering, set the Header Events.
$eventHeader = array();
$eventHeader[] = 'onClick=\'xajax_showGrid(0,' . $limit . ',"' . $filter . '","' . $content . '","pin","' . $divName . '","ORDERING");return false;\'';
$eventHeader[] = 'onClick=\'xajax_showGrid(0,' . $limit . ',"' . $filter . '","' . $content . '","first_name","' . $divName . '","ORDERING");return false;\'';
$eventHeader[] = 'onClick=\'xajax_showGrid(0,' . $limit . ',"' . $filter . '","' . $content . '","last_name","' . $divName . '","ORDERING");return false;\'';
$eventHeader[] = 'onClick=\'xajax_showGrid(0,' . $limit . ',"' . $filter . '","' . $content . '","amount","' . $divName . '","ORDERING");return false;\'';
$eventHeader[] = 'onClick=\'xajax_showGrid(0,' . $limit . ',"' . $filter . '","' . $content . '","discount","' . $divName . '","ORDERING");return false;\'';
$eventHeader[] = 'onClick=\'xajax_showGrid(0,' . $limit . ',"' . $filter . '","' . $content . '","cretime","' . $divName . '","ORDERING");return false;\'';
// Select Box: fields table.
$fieldsFromSearch = array();
$fieldsFromSearch[] = 'pin';
$fieldsFromSearch[] = 'first_name';
$fieldsFromSearch[] = 'last_name';
$fieldsFromSearch[] = 'amount';
$fieldsFromSearch[] = 'discount';
$fieldsFromSearch[] = 'cretime';
// Selecct Box: Labels showed on search select box.
$fieldsFromSearchShowAs = array();
$fieldsFromSearchShowAs[] = $locate->Translate("Pin");
$fieldsFromSearchShowAs[] = $locate->Translate("First name");
$fieldsFromSearchShowAs[] = $locate->Translate("Last name");
$fieldsFromSearchShowAs[] = $locate->Translate("Amount");
$fieldsFromSearchShowAs[] = $locate->Translate("Discount");
$fieldsFromSearchShowAs[] = $locate->Translate("Create time");
// Create object whit 5 cols and all data arrays set before.
$table = new ScrollTable(6, $start, $limit, $filter, $numRows, $content, $order);
$table->setAttribsCols($attribsCols);
if ($_SESSION['curuser']['usertype'] == 'admin') {
$table->setHeader('title', $headers, $attribsHeader, $eventHeader, 1, 1, 'customer');
//$table->deleteFlag = '1';//对删除标记进行赋值
//$table->exportFlag = '1';//对导出标记进行赋值
$table->addRowSearchMore($config['customers']['customertable'], $fieldsFromSearch, $fieldsFromSearchShowAs, $filter, $content, $start, $limit, 1, $typeFromSearch, $typeFromSearchShowAs, $stype);
} else {
$table->setHeader('title', $headers, $attribsHeader, $eventHeader, 0, 0, 'customer');
//if($_SESSION['curuser']['usertype'] == 'groupadmin') $table->exportFlag = '1';//对导出标记进行赋值
$table->addRowSearchMore($config['customers']['customertable'], $fieldsFromSearch, $fieldsFromSearchShowAs, $filter, $content, $start, $limit, 0, $typeFromSearch, $typeFromSearchShowAs, $stype);
}
while ($arreglo->fetchInto($row)) {
// Change here by the name of fields of its database table
$rowc = array();
$rowc[] = $row['id'];
$rowc[] = $row['pin'];
$rowc[] = $row['first_name'];
$rowc[] = $row['last_name'];
$rowc[] = $row['amount'];
if ($row['discount'] == -1) {
$rowc[] = $locate->Translate("dynamic");
} else {
$rowc[] = $row['discount'];
}
$rowc[] = $row['cretime'];
if ($_SESSION['curuser']['usertype'] == 'admin') {
$table->addRow($config['customers']['customertable'], $rowc, 1, 1, 'customer', $divName, $fields);
} else {
$table->addRow($config['customers']['customertable'], $rowc, 0, 0, 'customer', $divName, $fields);
}
}
// End Editable Zone
$html = $table->render();
return $html;
}