function updateWorktimeRecord($f)
{
global $db;
$f = astercrm::variableFiler($f);
$query = "UPDATE worktimes SET " . "starttime='" . $f['starttime'] . "', " . "endtime='" . $f['endtime'] . "', " . "startweek='" . $f['startweek'] . "', " . "endweek='" . $f['endweek'] . "', " . "groupid='" . $f['groupid'] . "' " . "WHERE id=" . $f['id'];
astercrm::events($query);
$res =& $db->query($query);
return $res;
}
function updateRateRecord($f)
{
global $db;
$f = astercrm::variableFiler($f);
$sql = "UPDATE myrate SET " . "dialprefix = '" . $f['dialprefix'] . "', " . "numlen = '" . $f['numlen'] . "', " . "destination = '" . $f['destination'] . "', " . "rateinitial = '" . $f['rateinitial'] . "', " . "initblock = '" . $f['initblock'] . "', " . "billingblock = '" . $f['billingblock'] . "', " . "connectcharge= '" . $f['connectcharge'] . "', " . "groupid = '" . $f['groupid'] . "', " . "resellerid = '" . $f['resellerid'] . "', " . "addtime= now() " . "WHERE id = " . $f['id'];
astercrm::events($sql);
$res =& $db->query($sql);
return $res;
}
function updateWorktimepackage($f)
{
global $db;
$f = astercrm::variableFiler($f);
$query = "UPDATE worktimepackages SET " . "worktimepackage_name=" . $db->quote($f['worktimepackage_name']) . ", " . "worktimepackage_note=" . $db->quote($f['worktimepackage_note']) . ", " . "worktimepackage_status='" . $f['worktimepackage_status'] . "', " . "groupid='" . $f['groupid'] . "' " . "WHERE id=" . $f['id'];
$wp_res = Customer::deleteRecords("worktimepackage_id", $f['id'], 'worktimepackage_worktimes');
$sltedWorktimes = split(',', rtrim($f['sltedWorktimes'], ','));
foreach ($sltedWorktimes as $worktimeid) {
$sql = "INSERT INTO worktimepackage_worktimes SET " . "worktimepackage_id='" . $f['id'] . "', " . "worktime_id='" . $worktimeid . "', " . "creby = '" . $_SESSION['curuser']['username'] . "'," . "cretime = now()";
$wp_res =& $db->query($sql);
}
astercrm::events($query);
$res =& $db->query($query);
return $res;
}
function updateTrunkinfoRecord($f)
{
global $db;
$f = astercrm::variableFiler($f);
$query = "UPDATE trunkinfo SET " . "trunkname='" . $f['trunkname'] . "', " . "trunkchannel='" . $f['trunkchannel'] . "', " . "didnumber='" . $f['didnumber'] . "', " . "trunk_number='" . $f['trunk_number'] . "', " . "trunknote='" . $f['trunknote'] . "', " . "cretime= now() " . "WHERE id= " . $f['id'] . " ";
astercrm::events($query);
$res =& $db->query($query);
return $res;
}
/**
* update resellergroup table
*
* @param $f (array) array contain customer fields.
* @return $res (object) object
*/
function updateResellergroupRecord($f)
{
global $db, $config;
$f = astercrm::variableFiler($f);
if ($f['creditmodtype'] == '') {
$newcurcredit = $f['curcredit'];
} elseif ($f['creditmodtype'] == 'add' && is_numeric($f['creditmod'])) {
$newcurcredit = $f['curcredit'] + $f['creditmod'];
$newcurcreditstr = "curcredit=curcredit + " . $f['creditmod'] . ", ";
$historysql = "INSERT INTO credithistory SET " . "modifytime= now(), " . "resellerid='" . $f['resellerid'] . "', " . "srccredit='" . $f['curcredit'] . "', " . "modifystatus= 'add', " . "modifyamount='" . $f['creditmod'] . "', " . "comment='" . $f['comment'] . "', " . "operator='" . $_SESSION['curuser']['userid'] . "'";
$historyres =& $db->query($historysql);
} elseif ($f['creditmodtype'] == 'reduce' && is_numeric($f['creditmod'])) {
$newcurcredit = $f['curcredit'] - $f['creditmod'];
$newcurcreditstr = "curcredit=curcredit - " . $f['creditmod'] . ", ";
$historysql = "INSERT INTO credithistory SET " . "modifytime= now(), " . "resellerid='" . $f['resellerid'] . "', " . "srccredit='" . $f['curcredit'] . "', " . "modifystatus= 'reduce', " . "modifyamount='" . $f['creditmod'] . "', " . "comment='" . $f['comment'] . "', " . "operator='" . $_SESSION['curuser']['userid'] . "'";
$historyres =& $db->query($historysql);
}
$sql = "UPDATE resellergroup SET " . "resellername='" . $f['resellername'] . "', " . "accountcode='" . $f['accountcode'] . "', " . "clid_context='" . $f['clid_context'] . "', " . $newcurcreditstr . "creditlimit='" . $f['creditlimit'] . "', " . "limittype='" . $f['limittype'] . "', " . "multiple= '" . $f['multiple'] . "', " . "trunk1_id= '" . $f['trunk1_id'] . "', " . "trunk2_id= '" . $f['trunk2_id'] . "', " . "allowcallback='no', " . "addtime= now() " . "WHERE id='" . $f['resellerid'] . "'";
astercrm::events($sql);
$res =& $db->query($sql);
return $res;
}
function updateRemindercallsRecord($f)
{
global $db;
$f = astercrm::variableFiler($f);
$query = "UPDATE remindercalls SET " . "customerid='" . $f['customerid'] . "', " . "contactid='" . $f['contactid'] . "', " . "phonenumber= '" . $f['phonenumber'] . "', " . "asteriskcallsid= '" . $f['asteriskcallsid'] . "', " . "note= '" . $f['note'] . "', " . "dialtime= '" . $f['dialtime'] . "', " . "groupid = " . $f['groupid'] . ", " . "cretime = now() " . "WHERE id= " . $f['id'] . " ";
astercrm::events($query);
$res =& $db->query($query);
return $res;
}
function updateCustomer($f)
{
global $customers_db, $config;
//print_r($f);exit;
$f = astercrm::variableFiler($f);
$sql = "UPDATE " . $config['customers']['customertable'] . " SET " . "first_name='" . $f['first_name'] . "', " . "last_name = '" . $f['last_name'] . "', " . "discount = '" . $f['discount'] . " 'WHERE pin = '" . $f['pin'] . "'";
astercrm::events($sql);
$res =& $customers_db->query($sql);
return $res;
}
function updateUserTypeRecord($f)
{
global $db;
$f = astercrm::variableFiler($f);
$sql = "UPDATE user_types SET " . "usertype_name='" . $f['usertype_name'] . "', " . "memo='" . $f['memo'] . "' where id=" . $f['Id'] . " ";
astercrm::events($sql);
$res =& $db->query($sql);
//下面是编辑权限,先删除这个用户的所有权限，然后进行重新分配
astercrm::events("DELETE FROM user_privileges WHERE user_type_id=" . $f['Id'] . " ");
$delete =& $db->query("DELETE FROM user_privileges WHERE user_type_id=" . $f['Id'] . " ");
if (!$delete) {
return $res;
}
//删除权限失败就不重新插如新的权限
$insertArray = array();
$curView = explode(',', rtrim($f['chkView'], ','));
foreach ($curView as $view) {
$obj = explode('=', $view);
$checked = $obj[1];
$page = str_replace("_view", "", $obj[0]);
if ($checked) {
$insertArray[] = array('view', $page, $f['Id']);
}
}
$curEdit = explode(',', rtrim($f['chkEdit'], ','));
foreach ($curEdit as $edit) {
$Eobj = explode('=', $edit);
$Echecked = $Eobj[1];
$Epage = str_replace("_edit", "", $Eobj[0]);
if ($Echecked) {
$insertArray[] = array('edit', $Epage, $f['Id']);
}
}
$curDel = explode(',', rtrim($f['ckdelete'], ','));
foreach ($curDel as $del) {
$Dobj = explode('=', $del);
$Dchecked = $Dobj[1];
$Dpage = str_replace("_delete", "", $Dobj[0]);
if ($Dchecked) {
$insertArray[] = array('delete', $Dpage, $f['Id']);
}
}
if (!empty($insertArray)) {
$privilege_sql = "INSERT INTO `user_privileges` (`action`,`page`,`user_type_id`,`created`) VALUES ";
foreach ($insertArray as $tmp) {
$privilege_sql .= "('" . $tmp[0] . "','" . $tmp[1] . "'," . $tmp[2] . ",now()),";
}
$new_sql .= rtrim($privilege_sql, ',') . ';';
astercrm::events($new_sql);
$result =& $db->query($new_sql);
}
return $res;
}
/**
* update a field in a table
*
* @param $table (string) table name
* @param $field (string) field need to be updated
* @param $value (string) value want to update to
* @param $id (int) identity of the record
* @return $res (object) object
*/
function updateField($table, $field, $value, $id, $fld = "id")
{
global $db;
$f = astercrm::variableFiler($f);
$sql = "UPDATE {$table} SET {$field}='{$value}' WHERE {$fld} = '{$id}'";
astercrm::events($sql);
$res =& $db->query($sql);
return $res;
}
/**
* Actualiza un registro de la tabla.
*
* @param $f (array) Arreglo que contiene los datos del formulario pasado.
* @return $res (object) Devuelve el objeto con la respuesta de la sentencia SQL ejecutada del UPDATE.
*/
function updateTCategoryRecord($f)
{
global $db;
$f = astercrm::variableFiler($f);
$query = "UPDATE tickets SET " . "ticketname='" . $f['ticketname'] . "', " . "campaignid='" . $f['campaignid'] . "', " . "groupid='" . $f['groupid'] . "', " . "fid=" . $f['fid'] . " " . "WHERE id='" . $f['id'] . "'";
astercrm::events($query);
$res =& $db->query($query);
return $res;
}
function updateCampaignResultRecord($f)
{
global $db;
$f = astercrm::variableFiler($f);
$bindqueue = 0;
if ($f['bindqueue'] == "on") {
$bindqueue = 1;
}
$query = "UPDATE campaignresult SET " . "resultname='" . $f['resultname'] . "', " . "resultnote='" . $f['resultnote'] . "', " . "status='" . $f['status'] . "', " . "campaignid='" . $f['campaignid'] . "', " . "parentid='" . $f['parentid'] . "', " . "groupid='" . $f['groupid'] . "' " . "WHERE id=" . $f['id'];
astercrm::events($query);
// echo $query;exit;
$res =& $db->query($query);
return $res;
}
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 updateRemind($f)
{
//修改提醒
global $db;
$f = astercrm::variableFiler($f);
$remindtime = $f['remindtime'];
$touser = trim($f['touser']);
//if($touser == ''){
$touser = $_SESSION['curuser']['username'];
//}
$query = "UPDATE remind SET " . "title='" . $f['remindtitle'] . "', " . "content='" . $f['content'] . "', " . "remindtime='" . $remindtime . "'," . "remindtype='" . $f['remindtype'] . "'," . "priority='" . $f['priority'] . "'," . "username='******'username'] . "', " . "remindabout='" . $f['remindabout'] . "', " . "touser='******' " . "WHERE id='" . $f['id'] . "'";
astercrm::events($query);
$res =& $db->query($query);
return $res;
}
function updateCurTicket($f)
{
global $db;
$f = astercrm::variableFiler($f);
$query = "UPDATE ticket_details SET " . "ticketcategoryid=" . $f['ticketcategoryid'] . ", " . "ticketid=" . $f['ticketid'] . ", " . "parent_id='" . ($f['parent_id'] == '' ? '' : str_pad($f['parent_id'], 8, '0', STR_PAD_LEFT)) . "'," . "customerid=" . $f['customerid'] . ", " . "assignto=" . $f['assignto'] . "," . "status='" . $f['status'] . "', " . "groupid=" . $f['groupid'] . "," . "memo='" . $f['memo'] . "' " . "WHERE id=" . $f['id'] . "";
astercrm::events($query);
$res =& $db->query($query);
return $res;
}
function saveCustomerLeadNote($f)
{
global $db;
$f = astercrm::variableFiler($f);
$query = "INSERT INTO note_leads SET " . "note='" . $f['note'] . "', " . "callerid='" . $f['iptcallerid'] . "', " . "attitude='" . $f['attitude'] . "', " . "priority=" . $f['priority'] . ", " . "private='" . $f['private'] . "', " . "cretime=now(), " . "creby='" . $_SESSION['curuser']['username'] . "', " . "groupid = " . $_SESSION['curuser']['groupid'] . ", " . "customerid=" . $f['customerid'] . ", " . "contactid=" . $f['contactid'] . ", " . "codes='" . $f['note_code'] . "' ";
astercrm::events($query);
$res =& $db->query($query);
if ($res) {
$noteId = mysql_insert_id();
$sql = "UPDATE customer_leads SET last_note_id={$noteId} WHERE id=" . $f['customerid'] . " ";
$res =& $db->query($sql);
}
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;
}
function insertNewAccountForBilling($f)
{
global $db;
$f = astercrm::variableFiler($f);
$sql = "INSERT INTO clid SET " . "clid='" . $f['extension'] . "', " . "pin='" . $f['password'] . "', " . "display='" . $f['username'] . "', " . "groupid = " . $f['groupid'] . ", " . "resellerid = " . $f['resellerid'] . ", " . "creditlimit = '" . $f['creditlimit'] . "'," . "limittype = '" . $f['limittype'] . "'," . "addtime = now() ";
astercrm::events($sql);
$res =& $db->query($sql);
return $res;
}
function updateCampaignRecord($f)
{
global $db;
$f = astercrm::variableFiler($f);
$bindqueue = 0;
if ($f['bindqueue'] == "on") {
$bindqueue = 1;
}
if ($f['dialtwoparty'] == "on") {
$dialtwoparty = "yes";
} else {
$dialtwoparty = "no";
}
if ($f['use_ext_chan'] == "on") {
$useExtChan = "yes";
} else {
$useExtChan = "no";
}
$limit_type = '';
if ($f['queuename'] == "") {
$limit_type = 'channel';
}
$query = "UPDATE campaign SET " . "campaignname='" . $f['campaignname'] . "', " . "campaignnote='" . $f['campaignnote'] . "', " . "enable='" . $f['enable'] . "', " . "serverid='" . $f['serverid'] . "', " . "worktime_package_id='" . $f['worktime_package_id'] . "', " . "waittime='" . $f['waittime'] . "', " . "outcontext='" . $f['outcontext'] . "', " . "incontext='" . $f['incontext'] . "', " . "nextcontext='" . $f['nextcontext'] . "', " . "firstcontext='" . $f['firstcontext'] . "', " . "inexten='" . $f['inexten'] . "', " . "queuename='" . $f['queuename'] . "', " . "bindqueue='" . $bindqueue . "', " . "max_dialing='" . $f['max_dialing'] . "', " . "maxtrytime='" . $f['maxtrytime'] . "', " . "recyletime='" . $f['recyletime'] . "', " . "enablerecyle='" . $f['enablerecyle'] . "', " . "minduration='" . $f['minduration'] . "', " . "minduration_billsec='" . $f['minduration_billsec'] . "', " . "minduration_leg_a='" . $f['minduration_leg_a'] . "', " . "callerid='" . $f['callerid'] . "', " . "use_ext_chan='" . $useExtChan . "', " . "dialtwoparty='" . $dialtwoparty . "', " . "queue_context='" . $f['queue_context'] . "', " . "sms_number='" . $f['sms_number'] . "', " . "balance = '" . $f['balance'] . "'," . "init_billing = '" . $f['init_billing'] . "'," . "billing_block = '" . $f['billing_block'] . "'," . "enablebalance = '" . $f['enablebalance'] . "'," . "groupid='" . $f['groupid'] . "' ";
if ($limit_type != '') {
$query .= ",limit_type='{$limit_type}' ";
}
$query .= "WHERE id=" . $f['id'];
astercrm::events($query);
$res =& $db->query($query);
return $res;
}
function updateServerRecord($f)
{
global $db;
$f = astercrm::variableFiler($f);
$query = "UPDATE servers SET " . "name='" . $f['name'] . "', " . "ip='" . $f['ip'] . "', " . "port='" . $f['port'] . "', " . "username= '******'username'] . "', " . "secret='" . $f['secret'] . "', " . "note='" . $f['note'] . "' " . "WHERE id='" . $f['id'] . "'";
astercrm::events($query);
$res =& $db->query($query);
return $res;
}
function updateAsteriskcallsRecord($f)
{
global $db;
$f = astercrm::variableFiler($f);
$query = "UPDATE asteriskcalls SET " . "asteriskcallsname='" . $f['asteriskcallsname'] . "', " . "outcontext='" . $f['dialoutcontext'] . "', " . "incontext='" . $f['dialincontext'] . "', " . "inextension= '" . $f['dialinextension'] . "', " . "groupid = " . $f['groupid'] . ", " . "cretime = now() " . "WHERE id= " . $f['id'] . " ";
astercrm::events($query);
$res =& $db->query($query);
return $res;
}
function updateDiscount($f)
{
global $customers_db, $config;
$f = astercrm::variableFiler($f);
$sql = "UPDATE " . $config['customers']['discounttable'] . " SET " . "amount='" . $f['amount'] . "', " . "discount = '" . $f['discount'] . "' WHERE id = '" . $f['id'] . "'";
astercrm::events($sql);
$res =& $customers_db->query($sql);
return $res;
}
function insertNewGroupForBilling($group)
{
global $db;
$f = astercrm::variableFiler($group);
$sql = "INSERT INTO accountgroup SET " . "groupname='" . $group['groupname'] . "', " . "creditlimit= " . $group['creditlimit'] . ", " . "limittype= '" . $group['limittype'] . "', " . "resellerid= " . $group['resellerid'] . ", " . "addtime = now() ";
astercrm::events($sql);
$res =& $db->query($sql);
$curid = mysql_insert_id();
return $curid;
}
