/**
* initialize page elements
*
*/
function init()
{
global $locate;
$objResponse = new xajaxResponse();
$objResponse->addAssign("divNav", "innerHTML", common::generateManageNav($skin));
$objResponse->addAssign("divCopyright", "innerHTML", common::generateCopyright($skin));
$objResponse->addScript("xajax_showGrid(0," . ROWSXPAGE . ",'','','')");
if ($_SESSION['curuser']['usertype'] == "groupadmin") {
$row = astercrm::getRecordById($_SESSION['curuser']['groupid'], "accountgroup");
$objResponse->addAssign("customer_multiple", "value", $row['customer_multiple']);
$objResponse->addAssign("spnShortcutUpdate", "innerHTML", '<input type="button" value="' . $locate->Translate("Shortcut update rate") . '" onclick="xajax_shortcutUpdate();">');
$objResponse->addAssign("spnShortcutMsg", "innerHTML", '');
}
return $objResponse;
}
function formAdd($surveyid = 0, $optionid = 0)
{
global $locate;
$html = '
<!-- No edit the next line -->
<form method="post" name="f" id="f">
<table border="1" width="100%" class="adminlist" id="tblSurvey">
';
$html .= '<tr><td colspan=2>
' . $locate->Translate("survey_title") . '*
</td></tr>';
if ($surveyid == 0) {
$html .= '<tr><td colspan=2>
<input type="text" size="50" maxlangth="100" id="surveyname" name="surveyname"/>
</td></tr>';
$html .= '<tr><td colspan=2>
' . $locate->Translate("Survey Note") . '
</td></tr>';
$html .= '<tr><td colspan=2>
<input type="text" size="50" maxlangth="254" id="surveynote" name="surveynote"/>
</td></tr>';
$enable_html = '<tr>
<td colspan=2>
<input type="radio" value="1" id="radEnable" name="radEnable" checked>' . $locate->Translate("enable") . '
<input type="radio" value="0" id="radEnable" name="radEnable">' . $locate->Translate("disable") . '
</td>
</tr>';
} else {
$survey = Customer::getRecord($surveyid, 'survey');
$nameCell = "TitleCol";
$html .= '<tr><td colspan="2" id="' . $nameCell . '" style="cursor: pointer;" onDblClick="xajax_editField(\'survey\',\'surveyname\',\'' . $nameCell . '\',\'' . $survey['surveyname'] . '\',\'' . $survey['id'] . '\');return false">' . $survey['surveyname'] . '<input type="hidden" id="surveyid" name="surveyid" value="' . $surveyid . '"/></td></tr>';
$nameCell = "NoteCol";
$html .= '<tr><td colspan=2>
' . $locate->Translate("Survey Note") . '
</td></tr>';
$html .= '<tr><td colspan="2" id="' . $nameCell . '" style="cursor: pointer;" onDblClick="xajax_editField(\'survey\',\'surveynote\',\'' . $nameCell . '\',\'' . $survey['surveynote'] . '\',\'' . $survey['id'] . '\');return false">' . $survey['surveynote'] . ' </td></tr>';
if ($survey['enable'] == 1) {
$enable_html = '<tr>
<td colspan=2>
<input type="radio" value="1" id="radEnable" name="radEnable" checked>' . $locate->Translate("enable") . '
<input type="radio" value="0" id="radEnable" name="radEnable">' . $locate->Translate("disable");
} else {
$enable_html = '<tr>
<td colspan=2>
<input type="radio" value="1" id="radEnable" name="radEnable" >' . $locate->Translate("enable") . '
<input type="radio" value="0" id="radEnable" name="radEnable" checked>' . $locate->Translate("disable");
}
$enable_html .= '<input type="button" onclick="xajax_setSurvey(xajax.getFormValues(\'f\'));return false;" value="' . $locate->Translate("update") . '">
</td>
</tr>';
}
$options = Customer::getOptions($surveyid);
if ($options) {
$ind = 0;
while ($options->fetchInto($row)) {
$nameRow = "formDivRow" . $row['id'];
$nameCell = $nameRow . "Col" . $ind;
$html .= '<tr id="' . $nameRow . '" >' . "\n";
$item_html = "";
if ($row['optiontype'] == "text") {
} else {
$item_html = '(<a href=? onclick="showItem(\'' . $row['id'] . '\');return false;">' . $locate->Translate("Item") . '</a>)';
}
$option_item_number = astercrm::getCountByField("optionid", $row['id'], "surveyoptionitems");
$html .= '
<td align="left" width="25%">' . $locate->Translate("option") . '(<a href="?" onclick="xajax_edit(\'' . $surveyid . '\',\'' . $row['id'] . '\');return false;"><img src="skin/default/images/edit.png"></a><a href="?" onclick="deleteOption(\'' . $row['id'] . '\',\'' . $nameRow . '\');return false;"><img src="skin/default/images/trash.png"></a>)' . $item_html . '
</td><td id="' . $nameCell . '" >' . $row['surveyoption'] . "(" . $locate->Translate($row['optiontype']) . ", {$option_item_number} " . $locate->Translate('items') . ")" . '</td></tr>
<tr>
<td align="left" width="25%">' . $locate->Translate("Option Note") . '</td>
<td id="' . $nameCell . '_note">' . $row['optionnote'] . '</td>
</tr>
<tr><td colspan="2" height="1" bgcolor="#ccc"></td></tr>
';
$ind++;
}
}
$html .= '<tr><td colspan=2>
' . $locate->Translate("option") . '
</td></tr>';
if ($optionid == 0) {
$button_value = $locate->Translate("Add Option");
$optionid = 0;
} else {
$button_value = $locate->Translate("Update Option");
$option = astercrm::getRecordById($optionid, "surveyoptions");
$optiontype[$option['optiontype']] = "selected";
}
$html .= '<tr><td colspan=2>' . $locate->Translate("Title") . ':
<input type="text" size="50" maxlength="50" id="surveyoption" name="surveyoption" value="' . $option['surveyoption'] . '"/>
<SELECT id="optiontype" name="optiontype">
<option value="radio" ' . $optiontype['radio'] . '>' . $locate->Translate("Radio") . '</option>
<option value="checkbox" ' . $optiontype['checkbox'] . '>' . $locate->Translate("Checkbox") . '</option>
<option value="text" ' . $optiontype['text'] . '>' . $locate->Translate("Text") . '</option>
</SELECT>
</td></tr>';
$html .= '<tr><td colspan=2>' . $locate->Translate("Note") . ':
<input type="text" size="50" maxlength="254" id="optionnote" name="optionnote" value="' . $option['optionnote'] . '"/>
<input type="button" value="' . $button_value . '" onclick="addOption(\'f\',\'' . $optionid . '\');return false;">
</td></tr>';
$html .= $enable_html;
if ($_SESSION['curuser']['usertype'] == 'admin') {
$res = Customer::getGroups();
$groupoptions .= '<select name="groupid" id="groupid" onchange="setCampaign();">';
while ($row = $res->fetchRow()) {
$groupoptions .= '<option value="' . $row['groupid'] . '"';
if ($survey['groupid'] == $row['groupid']) {
$groupoptions .= ' selected';
}
$groupoptions .= '>' . $row['groupname'] . '</option>';
}
$groupoptions .= '</select>';
} else {
$groupoptions .= $_SESSION['curuser']['group']['groupname'] . '<input id="groupid" name="groupid" type="hidden" value="' . $_SESSION['curuser']['groupid'] . '">';
}
if ($survey['campaignid'] == 0) {
$campaignoptions = '<option value="0">' . $locate->Translate("All") . '</option>';
}
$campaignres = Customer::getRecordsByGroupid($survey['groupid'], "campaign");
while ($row = $campaignres->fetchRow()) {
$campaignoptions .= '<option value="' . $row['id'] . '"';
if ($survey['campaignid'] == $row['id']) {
$campaignoptions .= ' selected';
}
$campaignoptions .= '>' . $row['campaignname'] . '</option>';
}
$html .= '
<tr>
<td align="left" width="25%">' . $locate->Translate("Group Name") . '</td>
<td>' . $groupoptions . '</td>
</tr>
<tr>
<td align="left" width="25%">' . $locate->Translate("Campaign Name") . '*</td>
<td><SELECT id="campaignid" name="campaignid">' . $campaignoptions . '</SELECT></td>
</tr>';
$html .= '
</table>
</form>
' . $locate->Translate("obligatory_fields") . '
';
return $html;
}
function saveDiallist($f, $userexten = '', $customerid = '')
{
global $locate;
$objResponse = new xajaxResponse();
if ($f['campaignid'] == '') {
$objResponse->addAlert($locate->Translate("Must select a campaign"));
return $objResponse->getXML();
}
if ($customerid > 0) {
$res_customer = astercrm::getRecordById($customerid, 'customer');
$f['customerid'] = $customerid;
$f['customername'] = $res_customer['customer'];
}
//print_r($f);exit;
// check if the assign number belong to this group
if ($_SESSION['curuser']['usertype'] != 'admin') {
$flag = false;
if ($_SESSION['curuser']['usertype'] == 'groupadmin') {
if ($f['assign'] == '') {
$flag = true;
} else {
foreach ($_SESSION['curuser']['memberExtens'] as $extension) {
if ($extension == $f['assign']) {
$flag = true;
break;
}
}
}
} else {
if ($_SESSION['curuser']['extension'] == $f['assign']) {
$flag = true;
}
}
if (!$flag) {
$objResponse->addAlert('"' . $locate->Translate("Cant insert, please confirm the assign number is in your group") . '"');
}
}
if ($userexten != '') {
$id = Customer::insertNewDiallist($f);
$html = Table::Top($locate->Translate("diallist"), "formDiallist");
$html .= Customer::createDiallistGrid($userexten, $customerid, 0, ROWSXPAGE);
$html .= Table::Footer();
$objResponse->addAssign("formDiallist", "innerHTML", $html);
$objResponse->addAssign("msgZone", "innerHTML", $locate->Translate("diallist_added"));
$objResponse->addAssign("formaddDiallistInfo", "style.visibility", "hidden");
$objResponse->addClear("formaddDiallistInfo", "innerHTML");
} else {
$id = Customer::updateDiallistRecord($f);
$objResponse->addAssign("msgZone", "innerHTML", $locate->Translate("diallist_updated"));
$objResponse->addAssign("formeditDiallistInfo", "style.visibility", "hidden");
$objResponse->addClear("formeditDiallistInfo", "innerHTML");
}
$objResponse->addScript("xajax_showDiallist('" . $_SESSION['curuser']['extension'] . "',0,0,5,'','','','formDiallistPannel','','');");
return $objResponse->getXML();
}
function &readReportAgent($groupid, $accountid, $sdate, $edate)
{
global $db;
$return_arr = array();
if ($_SESSION['curuser']['usertype'] == "admin") {
if (($groupid == '' || $groupid == 0) && ($accountid == '' || $accountid == 0)) {
$query = "SELECT COUNT(*) as recordNum, mycdr.astercrm_groupid,groupname FROM mycdr LEFT JOIN astercrm_accountgroup ON mycdr.astercrm_groupid = astercrm_accountgroup.id WHERE calldate >= '{$sdate}' AND calldate <= '{$edate}' AND mycdr.astercrm_groupid > 0 ";
$query_a = "SELECT COUNT(*) as arecordNum, SUM(billsec) as seconds ,mycdr.astercrm_groupid FROM mycdr WHERE calldate >= '{$sdate}' AND calldate <= '{$edate}' AND mycdr.astercrm_groupid > 0 AND billsec > 0";
$query .= " GROUP BY mycdr.astercrm_groupid ";
$query_a .= " GROUP BY mycdr.astercrm_groupid ";
$all_res =& $db->query($query);
$return_arr['type'] = 'grouplist';
while ($all_res->fetchinto($row)) {
$return_arr[$row['astercrm_groupid']]['recordNum'] = $row['recordNum'];
$return_arr[$row['astercrm_groupid']]['groupname'] = $row['groupname'];
$return_arr[$row['astercrm_groupid']]['arecordNum'] = 0;
$return_arr[$row['astercrm_groupid']]['seconds'] = 0;
}
$answer_res =& $db->query($query_a);
while ($answer_res->fetchinto($arow)) {
$return_arr[$arow['astercrm_groupid']]['arecordNum'] = $arow['arecordNum'];
$return_arr[$arow['astercrm_groupid']]['seconds'] = $arow['seconds'];
}
return $return_arr;
}
}
if (($groupid == '' || $groupid == 0) && ($accountid == '' || $accountid == 0) && $_SESSION['curuser']['usertype'] != "admin") {
$groupid = $_SESSION['curuser']['groupid'];
}
if (is_numeric($accountid) && $accountid > 0) {
$return_arr['type'] = 'agentlist';
$query = "SELECT COUNT(*) as recordNum FROM mycdr WHERE calldate >= '{$sdate}' AND calldate <= '{$edate}' ";
$query_a = "SELECT COUNT(*) as arecordNum, SUM(billsec) as seconds FROM mycdr WHERE calldate >= '{$sdate}' AND calldate <= '{$edate}' AND billsec > 0";
$query .= " AND mycdr.astercrm_groupid = " . $groupid . " ";
$query_a .= " AND mycdr.astercrm_groupid = " . $groupid . " ";
$query .= " AND accountid=" . $accountid;
$query_a .= " AND accountid=" . $accountid;
$all_count =& $db->getone($query);
$answer_row =& $db->getRow($query_a);
$account = astercrm::getRecordById($accountid, 'astercrm_account');
$return_arr[$accountid]['recordNum'] = $all_count;
$return_arr[$accountid]['username'] = $account['extension'];
$return_arr[$accountid]['name'] = $account['username'];
$return_arr[$accountid]['arecordNum'] = $answer_row['arecordNum'];
$return_arr[$accountid]['seconds'] = $answer_row['seconds'];
} else {
if (is_numeric($groupid)) {
if ($groupid > 0) {
$return_arr['type'] = 'agentlist';
$member = astercrm::getGroupMemberListByID($groupid);
while ($member->fetchinto($row)) {
$extens = '';
$channels = '';
$agents = '';
$query = "SELECT COUNT(*) as recordNum FROM mycdr WHERE calldate >= '{$sdate}' AND calldate <= '{$edate}' ";
$query_a = "SELECT COUNT(*) as arecordNum, SUM(billsec) as seconds FROM mycdr WHERE calldate >= '{$sdate}' AND calldate <= '{$edate}' AND billsec > 0";
$query .= " AND mycdr.astercrm_groupid = " . $groupid . " ";
$query_a .= " AND mycdr.astercrm_groupid = " . $groupid . " ";
$query .= " AND accountid=" . $row['id'];
$query_a .= " AND accountid=" . $row['id'];
$all_count =& $db->getone($query);
$answer_row =& $db->getRow($query_a);
$return_arr[$row['id']]['recordNum'] = $all_count;
$return_arr[$row['id']]['username'] = $row['extension'];
$return_arr[$row['id']]['name'] = $row['username'];
$return_arr[$row['id']]['arecordNum'] = $answer_row['arecordNum'];
$return_arr[$row['id']]['seconds'] = $answer_row['seconds'];
}
}
}
}
return $return_arr;
}
function formCustomrLeadEdit($id)
{
global $locate, $db;
$customer =& astercrm::getRecordById($id, 'customer_leads');
if ($customer['contactgender'] == 'male') {
$customerMaleSelected = 'selected';
} elseif ($customer['contactgender'] == 'female') {
$customerFemaleSelected = 'selected';
} else {
$customerUnknownSelected = 'selected';
}
$html = '
<form method="post" name="frmCustomerEdit" id="frmCustomerEdit">
<table border="0" width="100%">
<tr id="customerTR" name="customerTR">
<td nowrap align="left">' . $locate->Translate("customer_name") . '</td>
<td align="left">';
if ($customer['customertitle'] == 'Mr') {
$slt['Mr'] = 'selected';
} elseif ($customer['customertitle'] == 'Miss') {
$slt['Miss'] = 'selected';
} elseif ($customer['customertitle'] == 'Ms') {
$slt['Ms'] = 'selected';
} elseif ($customer['customertitle'] == 'Mrs') {
$slt['Mrs'] = 'selected';
} elseif ($customer['customertitle'] == 'other') {
$slt['other'] = 'selected';
}
$customertile = '<select id="customertitle" name="customertitle">
<option value="Mr" ' . $slt['Mr'] . '>' . $locate->Translate("Mr") . '</option>
<option value="Miss" ' . $slt['Miss'] . '>' . $locate->Translate("Miss") . '</option>
<option value="Ms" ' . $slt['Ms'] . '>' . $locate->Translate("Ms") . '</option>
<option value="Mrs" ' . $slt['Mrs'] . '>' . $locate->Translate("Mrs") . '</option>
<option value="other" ' . $slt['other'] . '>' . $locate->Translate("Other") . '</option>
</select>';
if ($_SESSION['curuser']['language'] != 'ZH' && $_SESSION['curuser']['country'] != 'cn') {
$html .= $customertile . ' <input type="text" id="customer" name="customer" size="35" maxlength="100" value="' . $customer['customer'] . '">';
} else {
$html .= '<input type="text" id="customer" name="customer" size="35" maxlength="100" value="' . $customer['customer'] . '"> ' . $customertile;
}
$html .= '<input type="hidden" id="customerid" name="customerid" value="' . $customer['id'] . '"><BR />
<input type="hidden" id="hidEditCustomerDetails" name="hidEditCustomerDetails" value="ON">
<input type="hidden" id="hidEditBankDetails" name="hidEditBankDetails" value="ON">
[<a href=? onclick="
if (xajax.$(\'hidEditCustomerDetails\').value == \'OFF\'){
showObj(\'trEditCustomerDetails\');
xajax.$(\'hidEditCustomerDetails\').value = \'ON\';
}else{
hideObj(\'trEditCustomerDetails\');
xajax.$(\'hidEditCustomerDetails\').value = \'OFF\';
};
return false;">
' . $locate->Translate("detail") . '
</a>] [<a href=? onclick="
if (xajax.$(\'hidEditBankDetails\').value == \'OFF\'){
showObj(\'trEditBankDetails\');
xajax.$(\'hidEditBankDetails\').value = \'ON\';
}else{
hideObj(\'trEditBankDetails\');
xajax.$(\'hidEditBankDetails\').value = \'OFF\';
}
return false;">' . $locate->Translate("bank") . '</a>]
</td>
</tr>
<tr id="trEditCustomerDetails" name="trEditCustomerDetails">
<td nowrap align="left">' . $locate->Translate("customer_contact") . '</td>
<td align="left"><input type="text" id="customerContact" name="customerContact" size="35" maxlength="35" value="' . $customer['contact'] . '"><BR />
<select id="customerContactGender" name="customerContactGender">
<option value="male" ' . $customerMaleSelected . '>' . $locate->Translate("male") . '</option>
<option value="female" ' . $customerFemaleSelected . '>' . $locate->Translate("female") . '</option>
<option value="unknown" ' . $customerUnknownSelected . '>' . $locate->Translate("unknown") . '</option>
</select>
</td>
</tr>
<tr id="trEditCustomerDetails" name="trEditCustomerDetails">
<td nowrap align="left">' . $locate->Translate("address") . '</td>
<td align="left"><input type="text" id="address" name="address" size="35" maxlength="200" value="' . $customer['address'] . '"></td>
</tr>
<tr id="trEditCustomerDetails" name="trEditCustomerDetails">
<td nowrap align="left">' . $locate->Translate("zipcode") . '/' . $locate->Translate("city") . '</td>
<td align="left"><input type="text" id="zipcode" name="zipcode" size="10" maxlength="10" value="' . $customer['zipcode'] . '">/<input type="text" id="city" name="city" size="17" maxlength="50" value="' . $customer['city'] . '"></td>
</tr>
<tr id="trEditCustomerDetails" name="trEditCustomerDetails">
<td nowrap align="left">' . $locate->Translate("state") . '</td>
<td align="left"><input type="text" id="state" name="state" size="35" maxlength="50" value="' . $customer['state'] . '"></td>
</tr>
<tr id="trEditCustomerDetails" name="trEditCustomerDetails">
<td nowrap align="left">' . $locate->Translate("country") . '</td>
<td align="left"><input type="text" id="country" name="country" size="35" maxlength="50" value="' . $customer['country'] . '"></td>
</tr>
<tr id="trEditCustomerDetails" name="trEditCustomerDetails">
<td nowrap align="left">' . $locate->Translate("customer_phone") . '</td>
<td align="left"><input type="text" id="customerPhone" name="customerPhone" size="35" maxlength="50" value="' . $customer['phone'] . '">-<input type="text" id="customerPhone_ext" name="customerPhone_ext" size="8" maxlength="8" value="' . $customer['phone_ext'] . '"></td>
</tr>
<tr name="trEditCustomerDetails" id="trEditCustomerDetails">
<td nowrap align="left">' . $locate->Translate("mobile") . '</td>
<td align="left"><input type="text" id="mainMobile" name="mainMobile" size="35" value="' . $customer['mobile'] . '"></td>
</tr>
<tr name="trEditCustomerDetails" id="trEditCustomerDetails">
<td nowrap align="left">' . $locate->Translate("email") . '</td>
<td align="left"><input type="text" id="mainEmail" name="mainEmail" size="35" value="' . $customer['email'] . '"></td>
</tr>
<tr id="trEditCustomerDetails" name="trEditCustomerDetails">
<td nowrap align="left">' . $locate->Translate("website") . '</td>
<td align="left"><input type="text" id="website" name="website" size="35" maxlength="100" value="' . $customer['website'] . '"><BR /><input type="button" value="' . $locate->Translate("browser") . '" onclick="openWindow(xajax.$(\'website\').value);return false;"></td>
</tr>
<tr id="trEditCustomerDetails" name="trEditCustomerDetails">
<td nowrap align="left">' . $locate->Translate("category") . '</td>
<td align="left"><input type="text" id="category" name="category" size="35" value="' . $customer['category'] . '"></td>
</tr>
<tr name="trEditCustomerDetails" id="trEditCustomerDetails" >
<td nowrap align="left">' . $locate->Translate("fax") . '</td>
<td align="left"><input type="text" id="mainFax" name="mainFax" size="35" value="' . $customer['fax'] . '"><input type="text" id="mainFax_ext" name="mainFax_ext" maxlength="8" size="8" value="' . $customer['fax_ext'] . '"></td>
</tr>
<!--*********************************************************-->
<tr id="trEditBankDetails" name="trEditBankDetails">
<td nowrap align="left">' . $locate->Translate("bank_name") . '</td>
<td align="left"><input type="text" id="bankname" name="bankname" size="35" value="' . $customer['bankname'] . '"></td>
</tr>
<tr id="trEditBankDetails" name="trEditBankDetails">
<td nowrap align="left">' . $locate->Translate("bank_zip") . '</td>
<td align="left"><input type="text" id="bankzip" name="bankzip" size="35" value="' . $customer['bankzip'] . '"></td>
</tr>
<tr id="trEditBankDetails" name="trEditBankDetails">
<td nowrap align="left">' . $locate->Translate("bank_account_name") . '</td>
<td align="left"><input type="text" id="bankaccountname" name="bankaccountname" size="35" value="' . $customer['bankaccountname'] . '"></td>
</tr>
<tr id="trEditBankDetails" name="trEditBankDetails">
<td nowrap align="left">' . $locate->Translate("bank_account") . '</td>
<td align="left"><input type="text" id="bankaccount" name="bankaccount" size="35" value="' . $customer['bankaccount'] . '"></td>
</tr>
<tr>
<td colspan="2" align="center"><button id="btnContinue" name="btnContinue" onClick=\'xajax_updateCustomerLead(xajax.getFormValues("frmCustomerEdit"),"customer");return false;\'>' . $locate->Translate("continue") . '</button></td>
</tr>
';
$html .= '
</table>
</form>
' . $locate->Translate("ob_fields") . '
';
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;
}
function showClidCredit()
{
$objResponse = new xajaxResponse();
$objResponse->addAssign("divClid", "style.visibility", "visible");
$clid = astercrm::getRecordById($_SESSION['curuser']['clidid'], 'clid');
if ($clid['limittype'] == '') {
$limit = 'no limit';
} else {
$limit = $clid['creditlimit'];
}
$objResponse->addAssign('spanCost', "innerHTML", $clid['credit_clid']);
$objResponse->addAssign("spanLimit", "innerHTML", $limit);
$objResponse->addAssign("spancurcredit", "innerHTML", $clid['curcredit']);
return $objResponse;
}
