function save($f)
{
global $locate;
$objResponse = new xajaxResponse();
if (trim(astercrm::getDigitsInStr($f['dialnumber'])) == '') {
$objResponse->addAlert($locate->Translate("dial number must be digits"));
return $objResponse->getXML();
}
if (trim(astercrm::getDigitsInStr($f['dialnumber'])) == '' || trim($f['groupid']) == '' || trim($f['campaignid']) == '') {
$objResponse->addAlert($locate->Translate("obligatory_fields"));
return $objResponse->getXML();
}
if ($f['campaignid'] == '') {
$objResponse->addAlert($locate->Translate("Must select a campaign"));
return $objResponse->getXML();
}
// check if the assign number belong to this group
if ($_SESSION['curuser']['usertype'] != 'admin' && $f['assign'] != "") {
$flag = false;
foreach ($_SESSION['curuser']['memberExtens'] as $extension) {
if ($extension == $f['assign']) {
$flag = true;
break;
}
}
if (!$flag) {
$objResponse->addAssign("msgZone", "innerHTML", $locate->Translate("Cant insert, please confirm the assign number is in your group"));
return $objResponse;
}
}
$id = Customer::insertNewDiallist($f);
$html = createGrid(0, ROWSXPAGE);
$objResponse->addAssign("grid", "innerHTML", $html);
$objResponse->addAssign("msgZone", "innerHTML", $locate->Translate("diallist_added"));
$objResponse->addAssign("formDiv", "style.visibility", "hidden");
$objResponse->addClear("formDiv", "innerHTML");
return $objResponse->getXML();
}
function updateDNCRecord($f)
{
global $db;
$f = astercrm::variableFiler($f);
$query = "UPDATE dnc_list SET " . "number='" . astercrm::getDigitsInStr($f['number']) . "', " . "groupid='" . $f['groupid'] . "', " . "campaignid= '" . $f['campaignid'] . "' " . "WHERE id='" . $f['id'] . "'";
astercrm::events($query);
$res =& $db->query($query);
return $res;
}
function updateDiallistRecord($f)
{
global $db;
$f = astercrm::variableFiler($f);
if ($f['callOrder'] == 0 || $f['callOrder'] == '') {
$f['callOrder'] = 1;
}
$query = "UPDATE diallist SET " . "dialnumber='" . astercrm::getDigitsInStr($f['dialnumber']) . "', " . "customername='" . $f['customername'] . "', " . "groupid='" . $f['groupid'] . "', " . "dialtime='" . $f['dialtime'] . "', " . "callOrder='" . $f['callOrder'] . "', " . "campaignid= " . $f['campaignid'] . ", " . "assign='" . $f['assign'] . "'," . "memo='" . $f['memo'] . "'" . "WHERE id='" . $f['id'] . "'";
astercrm::events($query);
$res =& $db->query($query);
return $res;
}
/**
* update contact table
*
* @param $f (array) array contain contact fields.
* @return $res (object) object
*/
function updateContactRecord($f)
{
global $db;
$f = astercrm::variableFiler($f);
$query = "UPDATE contact SET " . "contact='" . $f['contact'] . "', " . "gender='" . $f['contactGender'] . "', " . "position='" . $f['position'] . "', " . "phone='" . astercrm::getDigitsInStr($f['phone']) . "', " . "ext='" . astercrm::getDigitsInStr($f['ext']) . "', " . "phone1='" . astercrm::getDigitsInStr($f['phone1']) . "', " . "ext1='" . astercrm::getDigitsInStr($f['ext1']) . "', " . "phone2='" . astercrm::getDigitsInStr($f['phone2']) . "', " . "ext2='" . astercrm::getDigitsInStr($f['ext2']) . "', " . "mobile='" . astercrm::getDigitsInStr($f['mobile']) . "', " . "fax='" . astercrm::getDigitsInStr($f['fax']) . "', " . "fax_ext='" . astercrm::getDigitsInStr($f['fax_ext']) . "', " . "email='" . $f['email'] . "' " . "WHERE id='" . $f['contactid'] . "'";
astercrm::events($query);
$res =& $db->query($query);
return $res;
}
function parseRowToSql($arrRow, $order, $dialListField, $dialListTime, $tableStructure, $tableName, $date, $groupid, $assignNum, $arryAssign, $campaignid, $assignKey)
{
$fieldName = '';
$strData = '';
//echo $dialListField.'111';exit;
$phone_field = array(0 => 'phone', 1 => 'phone_ext', 2 => 'fax', 3 => 'fax_ext', 4 => 'mobile', 5 => 'ext', 6 => 'phone1', 7 => 'ext1', 8 => 'phone2', 9 => 'ext2');
//判断customer传过来的名字是不是空，如果是空就用 first name 和 last name 组合下赋给 customer的名
$customerFieldExist = false;
//判断导入选择的字段里是否有customer字段
$customername = '';
$hasCheckflag = false;
$customerKey = '';
//导入的时候选择的字段里有没有customer
$firstnameKey = '';
//导入的时候选择的字段里有没有customer
$lastnameKey = '';
//导入的时候选择的字段里有没有customer
if ($tableName == 'customer') {
foreach ($order as $key => $tmp) {
if ($tableStructure[trim($tmp)]['name'] == 'customer') {
$customerFieldExist = true;
$customerKey = $key;
} else {
if ($tableStructure[trim($tmp)]['name'] == 'first_name') {
$firstnameKey = $key;
} else {
if ($tableStructure[trim($tmp)]['name'] == 'last_name') {
$lastnameKey = $key;
}
}
}
}
}
for ($j = 0; $j < count($arrRow); $j++) {
$arrRow[$j] = trim($arrRow[$j]);
// if ($arrRow[$j] != mb_convert_encoding($arrRow[$j],"UTF-8","UTF-8"))
//echo "ok";exit;
// $arrRow[$j]=mb_convert_encoding($arrRow[$j],"UTF-8","GB2312");
$fieldOrder = trim($order[$j]);
//得到字段顺序号
if ($fieldOrder != '' && $arrRow[$j] != '') {
$fieldName .= $tableStructure[$fieldOrder]['name'] . ',';
if (in_array($tableStructure[$fieldOrder]['name'], $phone_field)) {
$arrRow[$j] = astercrm::getDigitsInStr($arrRow[$j]);
}
//如果导入里有customer字段并且值为空
if ($tableStructure[$fieldOrder]['name'] == 'customer' && $arrRow[$j] == '') {
$tmpNameStr = '';
if ($firstnameKey !== '') {
$tmpNameStr .= $arrRow[$firstnameKey] . ' ';
}
if ($lastnameKey !== '') {
$tmpNameStr .= $arrRow[$lastnameKey];
}
$arrRow[$j] = trim($tmpNameStr);
}
//如果导入里没有customer字段
if (!$customerFieldExist && !$hasCheckflag && $tableName == 'customer') {
$tmpNameStr = '';
if ($firstnameKey !== '') {
$tmpNameStr .= $arrRow[$firstnameKey] . ' ';
}
if ($lastnameKey !== '') {
$tmpNameStr .= $arrRow[$lastnameKey];
}
$customername = addslashes(trim($tmpNameStr));
$hasCheckflag = true;
}
$strData .= '"' . addslashes($arrRow[$j]) . '"' . ',';
}
if (isset($dialListField) && $dialListField != '' && $arrRow[$j] != '') {
if ($dialListField == $j) {
if ($tableName == 'diallist') {
if ($assignNum > 0) {
// while ($arryAssign[$x] == ''){
// if($x >$assignNum){
// $x = 0;
// }else{
// $x ++;
// }
// }
$fieldName .= 'assign,';
$strData .= '"' . addslashes($arryAssign[$assignKey]) . '"' . ',';
}
} else {
$dialNum = astercrm::getDigitsInStr($arrRow[$j]);
}
}
}
if (isset($dialListTime) && $dialListTime != '') {
if ($dialListTime == $j) {
$dialTime = trim($arrRow[$j]);
}
}
}
if (!$customerFieldExist && $tableName == 'customer') {
$fieldName = 'customer,' . substr($fieldName, 0, strlen($fieldName) - 1);
$strData = '"' . $customername . '",' . substr($strData, 0, strlen($strData) - 1);
} else {
$fieldName = substr($fieldName, 0, strlen($fieldName) - 1);
$strData = substr($strData, 0, strlen($strData) - 1);
}
if ($fieldName != "") {
if ($tableName == "diallist") {
$strSql = "INSERT INTO {$tableName} ({$fieldName},cretime,creby,groupid,campaignid) VALUES ({$strData}, '" . $date . "', '" . $_SESSION['curuser']['username'] . "', '" . $groupid . "','" . $campaignid . "')";
} else {
$strSql = "INSERT INTO {$tableName} ({$fieldName},cretime,creby,groupid) VALUES ({$strData}, '" . $date . "', '" . $_SESSION['curuser']['username'] . "', " . $groupid . ")";
}
}
return array('strSql' => $strSql, 'dialListNum' => $dialNum, 'dialListTime' => $dialTime);
}
function saveSchedulerDial($dialnumber = '', $campaignid = '', $dialtime = '')
{
global $locate, $db;
$objResponse = new xajaxResponse();
if ($dialnumber == '') {
$objResponse->addAlert($locate->Translate("Number can not be blank"));
return $objResponse->getXML();
}
if ($campaignid == '') {
$objResponse->addAlert($locate->Translate("Campaign can not be blank"));
return $objResponse->getXML();
}
if ($dialtime == '') {
$objResponse->addAlert($locate->Translate("Dial time can not be blank"));
return $objResponse->getXML();
}
$sql = "INSERT INTO diallist SET " . "dialnumber='" . astercrm::getDigitsInStr($dialnumber) . "', " . "groupid='" . $_SESSION['curuser']['groupid'] . "', " . "dialtime='" . $dialtime . "', " . "creby='" . $_SESSION['curuser']['username'] . "', " . "cretime= now(), " . "campaignid= " . $campaignid . " ";
$res =& $db->query($sql);
if ($res) {
$objResponse->addAlert($locate->Translate("Add scheduler dial success"));
$objResponse->addAssign("trAddSchedulerDial", "style.display", "none");
} else {
$objResponse->addAlert($locate->Translate("Add scheduler dial failed"));
}
return $objResponse->getXML();
}
function save($f)
{
global $locate;
$objResponse = new xajaxResponse();
if (trim(astercrm::getDigitsInStr($f['number'])) == '') {
$objResponse->addAlert($locate->Translate("dial number must be digits"));
return $objResponse->getXML();
}
// check if the assign number belong to this group
$id = Customer::insertNewDNClist($f);
$html = createGrid(0, ROWSXPAGE);
$objResponse->addAssign("grid", "innerHTML", $html);
$objResponse->addAssign("msgZone", "innerHTML", $locate->Translate("DNClist_added"));
$objResponse->addAssign("formDiv", "style.visibility", "hidden");
$objResponse->addClear("formDiv", "innerHTML");
return $objResponse->getXML();
}
/**
* update customer_leads table
*
* @param $f (array) array contain customer fields.
* @return $res (object) object
*/
function updateCustomerLeadRecord($f)
{
global $db;
$f = astercrm::variableFiler($f);
$query = "UPDATE customer_leads SET " . "customer='" . $f['customer'] . "', " . "customertitle='" . $f['customertitle'] . "', " . "website='" . $f['website'] . "', " . "country='" . $f['country'] . "', " . "address='" . $f['address'] . "', " . "zipcode='" . $f['zipcode'] . "', " . "phone='" . astercrm::getDigitsInStr($f['customerPhone']) . "', " . "phone_ext='" . astercrm::getDigitsInStr($f['customerPhone_ext']) . "', " . "contact='" . $f['customerContact'] . "', " . "contactgender='" . $f['customerContactGender'] . "', " . "state='" . $f['state'] . "', " . "city='" . $f['city'] . "', " . "category='" . $f['category'] . "', " . "bankname='" . $f['bankname'] . "', " . "bankzip='" . $f['bankzip'] . "', " . "fax='" . astercrm::getDigitsInStr($f['mainFax']) . "', " . "fax_ext='" . astercrm::getDigitsInStr($f['mainFax_ext']) . "', " . "mobile='" . astercrm::getDigitsInStr($f['mainMobile']) . "', " . "email='" . $f['mainEmail'] . "', " . "bankaccount='" . $f['bankaccount'] . "', " . "bankaccountname='" . $f['bankaccountname'] . "' " . "WHERE id='" . $f['customerid'] . "'";
astercrm::events($query);
$res =& $db->query($query);
return $res;
}
