/**
* Updates existing DB entry for some login
*
* @param string $login
* @param string $seal
* @param string $length
* @param string $price
*
* @return void
*/
protected function update($login, $seal, $length, $price)
{
$login = mysql_real_escape_string($login);
simple_update_field('condet', 'seal', $seal, "WHERE `login`='" . $login . "';");
simple_update_field('condet', 'length', $length, "WHERE `login`='" . $login . "';");
simple_update_field('condet', 'price', $price, "WHERE `login`='" . $login . "';");
}
public function save()
{
$value = serialize($_POST[self::FORM_NAME]);
$value = base64_encode($value);
simple_update_field('nas', 'options', $value, "WHERE `id` = '" . $this->_id . "'");
// Re-new options current values:
$this->options = zb_NasOptionsGet($this->_id);
// Return
return true;
}
public function save($id)
{
$id = vf($id, 3);
if (isset($this->data[$id])) {
simple_update_field('zbsannouncements', 'public', $_POST['editpublic'], "WHERE `id`='" . $id . "'");
simple_update_field('zbsannouncements', 'type', $_POST['edittype'], "WHERE `id`='" . $id . "'");
simple_update_field('zbsannouncements', 'title', $_POST['edittitle'], "WHERE `id`='" . $id . "'");
simple_update_field('zbsannouncements', 'text', $_POST['edittext'], "WHERE `id`='" . $id . "'");
log_register("ANNOUNCEMENT EDIT [" . $id . "]");
} else {
throw new Exception(self::EX_ID_NO_EXIST);
}
}
} else {
//printable result
if (wf_CheckPost(array('printdatefrom', 'printdateto'))) {
ts_PrintTasks($_POST['printdatefrom'], $_POST['printdateto']);
}
//show printing form
show_window(__('Tasks printing'), ts_PrintDialogue());
}
} else {
//sms post sending
if (wf_CheckPost(array('postsendemployee', 'postsendsmstext'))) {
$smsDataRaw = ts_SendSMS($_POST['postsendemployee'], $_POST['postsendsmstext']);
if (!empty($smsDataRaw)) {
$smsDataSave = serialize($smsDataRaw);
$smsDataSave = "'" . base64_encode($smsDataSave) . "'";
simple_update_field('taskman', 'smsdata', $smsDataSave, "WHERE `id`='" . $_GET['edittask'] . "'");
//flushing dark void
$darkVoid = new DarkVoid();
$darkVoid->flushCache();
rcms_redirect('?module=taskman&edittask=' . $_GET['edittask']);
}
}
//sms data flush
if (wf_CheckGet(array('flushsmsdata'))) {
ts_FlushSMSData($_GET['flushsmsdata']);
rcms_redirect('?module=taskman&edittask=' . $_GET['flushsmsdata']);
}
/**
* Salary accounting actions
*/
if ($altCfg['SALARY_ENABLED']) {
/**
* Marks ticket as unreviewed in database
*
* @param int $ticketid
*
* @return void
*/
function zb_TicketSetUnDone($ticketid)
{
$ticketid = vf($ticketid, 3);
simple_update_field('ticketing', 'status', '0', "WHERE `id`='" . $ticketid . "'");
log_register("TICKET OPEN [" . $ticketid . "]");
}
/**
* Marks signup request as undone in database
*
* @param int $reqid Existing request ID
*
* @return void
*/
public function setUnDone($reqid)
{
$requid = vf($reqid, 3);
simple_update_field('sigreq', 'state', '0', "WHERE `id`='" . $reqid . "'");
log_register('SIGREQ UNDONE [' . $reqid . ']');
}
if (!zb_AddressBuildProtected($_GET['buildid'])) {
zb_AddressDeleteBuild($_GET['buildid']);
rcms_redirect("?module=builds&action=edit&streetid=" . $streetid);
} else {
show_window('', wf_Link("?module=builds&action=edit&streetid=" . $streetid, 'Back', false, 'ubButton'));
show_error(__('You can not delete a building if there are users of the apartment'));
}
}
if ($_GET['action'] == 'editbuild') {
$buildid = vf($_GET['buildid']);
$streetid = vf($_GET['streetid']);
//build edit subroutine
if (isset($_POST['editbuildnum'])) {
if (!empty($_POST['editbuildnum'])) {
simple_update_field('build', 'buildnum', $_POST['editbuildnum'], "WHERE `id`='" . $buildid . "'");
simple_update_field('build', 'geo', $_POST['editbuildgeo'], "WHERE `id`='" . $buildid . "'");
}
log_register("CHANGE AddressBuild [" . $buildid . "] " . mysql_real_escape_string($_POST['editbuildnum']));
rcms_redirect("?module=builds&action=edit&streetid=" . $streetid);
}
//construct edit form
$builddata = zb_AddressGetBuildData($buildid);
$streetname = zb_AddressGetStreetData($streetid);
$streetname = $streetname['streetname'];
$editinputs = $streetname . " " . $builddata['buildnum'] . wf_tag('hr');
$editinputs .= wf_TextInput('editbuildnum', 'Building number', $builddata['buildnum'], true, '10');
$editinputs .= wf_TextInput('editbuildgeo', 'Geo location', $builddata['geo'], true, '20');
$editinputs .= wf_Submit('Save');
$editform = wf_Form('', 'POST', $editinputs, 'glamour');
show_window(__('Edit') . ' ' . __('Build'), $editform);
show_window('', wf_Link("?module=builds&action=edit&streetid=" . $streetid, 'Back', true, 'ubButton'));
/**
* Performs switch replacement in database
*
* @param int $fromId
* @param int $toId
* @param int $employeeid
*
* @return void
*/
function zb_SwitchReplace($fromId, $toId, $employeeId)
{
$fromId = vf($fromId, 3);
$toId = vf($toId, 3);
$employeeId = vf($employeeId, 3);
$allEmployees = ts_GetAllEmployee();
$fromData = zb_SwitchGetData($fromId);
$toData = zb_SwitchGetData($toId);
if (!empty($fromData)) {
//copy geo coordinates to new switch
simple_update_field('switches', 'geo', $fromData['geo'], "WHERE `id`='" . $toId . "'");
//setting new description and remove NP flag
$newDescriptionTo = str_replace('NP', 'm:' . @$allEmployees[$employeeId], $toData['desc']);
simple_update_field('switches', 'desc', $newDescriptionTo, "WHERE `id`='" . $toId . "'");
//copy location
simple_update_field('switches', 'location', $fromData['location'], "WHERE `id`='" . $toId . "'");
//copy switch parent ID
if (!empty($fromData['parentid'])) {
simple_update_field('switches', 'parentid', $fromData['parentid'], "WHERE `id`='" . $toId . "'");
} else {
$parentId_q = "UPDATE `switches` SET `parentid`=NULL WHERE `id`='" . $toId . "';";
nr_query($parentId_q);
}
//moving childs if it present
simple_update_field('switches', 'parentid', $toId, "WHERE `parentid`='" . $fromId . "'");
// doing old switch cleanup and disabling it
simple_update_field('switches', 'geo', '', "WHERE `id`='" . $fromId . "'");
$newFromLocation = __('removed from') . ': ' . $fromData['location'];
simple_update_field('switches', 'location', $newFromLocation, "WHERE `id`='" . $fromId . "'");
$newFromDesc = 'NP u:' . @$allEmployees[$employeeId];
simple_update_field('switches', 'desc', $newFromDesc, "WHERE `id`='" . $fromId . "'");
$parentIdFrom_q = "UPDATE `switches` SET `parentid`=NULL WHERE `id`='" . $fromId . "';";
nr_query($parentIdFrom_q);
log_register("SWITCH REPLACE FROM [" . $fromId . "] TO [" . $toId . "] EMPLOYEE [" . $employeeId . "]");
} else {
show_error(__('Strange exeption') . ': FROM_SWITCH_EMPTY_DATA');
}
}
/**
* Saves timesheet editing results into database
*
* @return void
*/
public function timesheetSaveChanges()
{
if (wf_CheckPost(array('edittimesheetid'))) {
$id = vf($_POST['edittimesheetid'], 3);
if (isset($this->allTimesheets[$id])) {
$timesheetData = $this->allTimesheets[$id];
$timesheetDate = $timesheetData['date'];
$employee = $timesheetData['employeeid'];
$hours = vf($_POST['editemployeehours'], 3);
$hospitalFlag = wf_CheckPost(array('edithospital')) ? 1 : 0;
$holidayFlag = wf_CheckPost(array('editholiday')) ? 1 : 0;
$where = " WHERE `id`='" . $id . "';";
if ($timesheetData['hours'] != $hours) {
simple_update_field('salary_timesheets', 'hours', $hours, $where);
}
if ($timesheetData['holiday'] != $holidayFlag) {
simple_update_field('salary_timesheets', 'holiday', $holidayFlag, $where);
}
if ($timesheetData['hospital'] != $hospitalFlag) {
simple_update_field('salary_timesheets', 'hospital', $hospitalFlag, $where);
}
log_register('SALARY EDIT TIMESHEET [' . $id . '] `' . $timesheetDate . '` EMPLOYEE [' . $employee . '] HOURS `' . $hours . '` HOSPITAL `' . $hospitalFlag . '` HOLIDAY `' . $holidayFlag . '`');
} else {
log_register('SALARY EDIT FAIL TIMESHEET [' . $id . '] NOT_EXISTING_ID');
}
}
}
public function changeTask()
{
$taskID = vf($_GET['edit'], 3);
if (wf_CheckPost(array('editname', 'editaction', 'editparam'))) {
if (!empty($taskID)) {
if (isset($_POST['editactive'])) {
$actFlag = 1;
} else {
$actFlag = 0;
}
simple_update_field('watchdog', 'name', $_POST['editname'], "WHERE `id`='" . $taskID . "'");
simple_update_field('watchdog', 'checktype', $_POST['editchecktype'], "WHERE `id`='" . $taskID . "'");
simple_update_field('watchdog', 'param', $_POST['editparam'], "WHERE `id`='" . $taskID . "'");
simple_update_field('watchdog', 'operator', $_POST['editoperator'], "WHERE `id`='" . $taskID . "'");
simple_update_field('watchdog', 'condition', $_POST['editcondition'], "WHERE `id`='" . $taskID . "'");
simple_update_field('watchdog', 'action', $_POST['editaction'], "WHERE `id`='" . $taskID . "'");
simple_update_field('watchdog', 'active', $actFlag, "WHERE `id`='" . $taskID . "'");
log_register("WATCHDOG CHANGE TASK [" . $taskID . "] `" . $_POST['editname'] . "`");
} else {
throw new Exception(self::TASKID_EX);
}
} else {
throw new Exception(self::TASKADD_EX);
}
}
if (wf_CheckPost(array('newmaclan'))) {
docsis_ModemAdd($_POST['newmaclan']);
}
//deleting modem
if (wf_CheckGet(array('deletemodem'))) {
docsis_ModemDelete($_GET['deletemodem']);
rcms_redirect("?module=docsis");
}
//editing modem
if (isset($_POST['edituserbind']) and isset($_POST['editnote'])) {
$editmodemid = vf($_GET['showmodem'], 3);
if (!empty($editmodemid)) {
$newmodemuserbind = mysql_real_escape_string($_POST['edituserbind']);
$newmodemnote = mysql_real_escape_string($_POST['editnote']);
simple_update_field('modems', 'userbind', $newmodemuserbind, "WHERE `id`='" . $editmodemid . "'");
simple_update_field('modems', 'note', $newmodemnote, "WHERE `id`='" . $editmodemid . "'");
log_register("DOCSIS MODEM EDIT BIND `" . $newmodemuserbind . "` [" . $editmodemid . "]");
rcms_redirect("?module=docsis&showmodem=" . $editmodemid);
} else {
show_window(__('Error'), __('Strange exeption'));
}
}
//setting modem snmp community
if (wf_CheckPost(array('newmodemcommunity', 'newsnmpwalkpath'))) {
docsis_ModemSnmpSet($_POST['newmodemcommunity']);
docsis_ModemSnmpWalkSet($_POST['newsnmpwalkpath']);
rcms_redirect("?module=docsis");
}
//show controls
docsis_ControlsShow();
//show modems list by default
/**
* changes pool login
*
* @param int $poolid Existing poolID
* @param string $login Existin ubilling user login
*
* @return void
*/
public function poolLinkLogin($poolid, $login)
{
$poolid = vf($poolid, 3);
$login = trim($login);
if (isset($this->pools[$poolid])) {
simple_update_field('netextpools', 'login', $login, "WHERE `id`='" . $poolid . "'");
log_register("POOL LINK USER `" . $login . "`");
} else {
throw new Exception(self::EX_NOEXPOOL);
}
}
<?php
if (cfr('SWITCHMAP')) {
$altercfg = $ubillingConfig->getAlter();
if ($altercfg['SWYMAP_ENABLED']) {
//wysiwyg switch placement
if (wf_CheckPost(array('switchplacing', 'placecoords'))) {
if (cfr('SWITCHESEDIT')) {
$switchid = vf($_POST['switchplacing'], 3);
$placegeo = mysql_real_escape_string($_POST['placecoords']);
simple_update_field('switches', 'geo', $placegeo, "WHERE `id`='" . $switchid . "'");
log_register('SWITCH CHANGE [' . $switchid . ']' . ' GEO ' . $placegeo);
rcms_redirect("?module=switchmap&locfinder=true");
} else {
show_error(__('Access denied'));
}
}
$ymconf = $ubillingConfig->getYmaps();
$ym_center = $ymconf['CENTER'];
$ym_zoom = $ymconf['ZOOM'];
$ym_type = $ymconf['TYPE'];
$ym_lang = $ymconf['LANG'];
$area = '';
//show map container
sm_ShowMapContainer();
//collect switches geolocation data
if (!wf_CheckGet(array('coverage'))) {
$placemarks = sm_MapDrawSwitches();
//uplinks display mode
if (wf_CheckGet(array('showuplinks')) and !wf_CheckGet(array('traceid'))) {
$placemarks .= sm_MapDrawSwitchUplinks();
function ms_TicketSetDone($ticketid)
{
$ticketid = vf($ticketid);
simple_update_field('ticketing', 'status', '1', "WHERE `id`='" . $ticketid . "'");
}
/**
* Assigns exinsting ONU with some login
*
* @param int $onuid
* @param string $login
*
* @return void
*/
public function onuAssign($onuid, $login)
{
$onuid = vf($onuid, 3);
if (isset($this->allOnu[$onuid])) {
simple_update_field('pononu', 'login', $login, "WHERE `id`='" . $onuid . "'");
log_register('PON ASSIGN ONU [' . $onuid . '] WITH (' . $login . ')');
} else {
log_register('PON ASSIGN ONU [' . $onuid . '] FAILED');
}
}
} else {
show_window(__('Error'), __('Required fields'));
}
}
//if someone deleting tagtype
if (isset($_GET['delete'])) {
stg_delete_tagtype($_GET['delete']);
rcms_redirect("?module=usertags");
}
//if someone wants to edit tagtype
if (isset($_GET['edit'])) {
$tagtypeid = vf($_GET['edit'], 3);
if (isset($_POST['edittagcolor'])) {
simple_update_field('tagtypes', 'tagcolor', $_POST['edittagcolor'], "WHERE `id`='" . $tagtypeid . "'");
simple_update_field('tagtypes', 'tagsize', $_POST['edittagsize'], "WHERE `id`='" . $tagtypeid . "'");
simple_update_field('tagtypes', 'tagname', $_POST['edittagname'], "WHERE `id`='" . $tagtypeid . "'");
log_register("TAGTYPE CHANGE [" . $tagtypeid . ']');
rcms_redirect("?module=usertags");
}
//form construct
$tagpriorities = array('1' => '1', '2' => '2', '3' => '3', '4' => '4', '5' => '5', '6' => '6');
$tagtypedata = stg_get_tagtype_data($tagtypeid);
$editinputs = wf_ColPicker('edittagcolor', __('Color'), $tagtypedata['tagcolor'], true, '20');
$editinputs .= wf_TextInput('edittagname', 'Text', $tagtypedata['tagname'], true, 20);
$editinputs .= wf_Selector('edittagsize', $tagpriorities, 'Priority', $tagtypedata['tagsize'], true);
$editinputs .= wf_Submit('Save');
$editform = wf_Form('', 'POST', $editinputs, 'glamour');
show_window(__('Edit'), $editform);
show_window('', wf_Link("?module=usertags", 'Back', true, 'ubButton'));
}
//show available tagtypes
/**
* Changes existing custom map name in database
*
* @paramint $id
* @param string $name
* @throws Exception
*/
public function mapEdit($id, $name)
{
$id = vf($id, 3);
if (isset($this->allMaps[$id])) {
simple_update_field('custmaps', 'name', $name, "WHERE `id`='" . $id . "'");
log_register('CUSTMAPS EDIT MAP [' . $id . '] SET `' . $name . '`');
} else {
throw new Exception(self::EX_NO_MAP_ID);
}
}
function catvbs_LockRow($rowid)
{
$rowid = vf($rowid, 3);
simple_update_field('catv_bankstaparsed', 'state', '1', "WHERE `id`='" . $rowid . "'");
log_register("CATV_BANKSTA LOCK ROW " . $rowid);
}
$priority = $_POST['newpriority'];
if (!empty($price)) {
zb_VserviceCreate($tagid, $price, $cashtype, $priority);
rcms_redirect("?module=vservices");
} else {
show_error(__('No all of required fields is filled'));
}
}
if (isset($_GET['delete'])) {
$vservid = $_GET['delete'];
zb_VsericeDelete($vservid);
rcms_redirect("?module=vservices");
}
if (wf_CheckGet(array('edit'))) {
$editId = vf($_GET['edit'], 3);
if (wf_CheckPost(array('edittagid', 'editcashtype', 'editpriority', 'editfee'))) {
simple_update_field('vservices', 'tagid', $_POST['edittagid'], "WHERE `id`='" . $editId . "'");
simple_update_field('vservices', 'cashtype', $_POST['editcashtype'], "WHERE `id`='" . $editId . "'");
simple_update_field('vservices', 'priority', $_POST['editpriority'], "WHERE `id`='" . $editId . "'");
simple_update_field('vservices', 'price', $_POST['editfee'], "WHERE `id`='" . $editId . "'");
log_register("CHANGE VSERVICE [" . $editId . "] PRICE `" . $_POST['editfee'] . "`");
rcms_redirect("?module=vservices");
}
show_window(__('Edit'), web_VserviceEditForm($_GET['edit']));
} else {
//show available services list
web_VservicesShow();
}
} else {
show_error(__('Access denied'));
}
/**
* updates existing license key
*/
public function updateKey($index, $key)
{
if ($this->checkLicenseValidity($key)) {
simple_update_field('ubstorage', 'value', $key, "WHERE `key`='" . $index . "'");
log_register("AVARICE UPDATE KEY `" . $index . '`');
return true;
} else {
log_register("AVARICE TRY UPDATE WRONG KEY");
return false;
}
}
//if someone deleting type
if (isset($_GET['delete'])) {
cf_TypeDelete($_GET['delete']);
rcms_redirect("?module=cftypes");
}
//if someone adding field
if (isset($_POST['newtype'])) {
cf_TypeAdd($_POST['newtype'], $_POST['newname']);
rcms_redirect("?module=cftypes");
}
//if someone edits type
if (isset($_POST['editname'])) {
$typeid = vf($_POST['editid']);
$typename = $_POST['editname'];
$typetype = $_POST['edittype'];
simple_update_field('cftypes', 'type', $typetype, 'WHERE `id` = "' . $typeid . '"');
simple_update_field('cftypes', 'name', $typename, 'WHERE `id` = "' . $typeid . '"');
log_register("CFTYPE CHANGE [" . $typeid . "] `" . $typename . "`");
rcms_redirect("?module=cftypes");
}
if (!isset($_GET['edit'])) {
show_window(__('Available custom profile field types'), cf_TypesShow());
show_window(__('Create new field type'), cf_TypeAddForm());
} else {
//editing type
$typeid = vf($_GET['edit']);
cf_TypeEditForm($typeid);
}
} else {
show_error(__('You cant control this module'));
}
/**
* Updates task params in database
*
* @param int $taskid
* @param string $startdate
* @param string $starttime
* @param string $address
* @param string $login
* @param string $phone
* @param int $jobtypeid
* @param int $employeeid
* @param string $jobnote
*
* @return void
*/
function ts_ModifyTask($taskid, $startdate, $starttime, $address, $login, $phone, $jobtypeid, $employeeid, $jobnote)
{
$taskid = vf($taskid, 3);
$startdate = mysql_real_escape_string($startdate);
if (!empty($starttime)) {
$starttime = "'" . mysql_real_escape_string($starttime) . "'";
} else {
$starttime = 'NULL';
}
$address = str_replace('\'', '`', $address);
$address = mysql_real_escape_string($address);
$login = mysql_real_escape_string($login);
$phone = mysql_real_escape_string($phone);
$jobtypeid = vf($jobtypeid, 3);
$employeeid = vf($employeeid, 3);
simple_update_field('taskman', 'startdate', $startdate, "WHERE `id`='" . $taskid . "'");
nr_query("UPDATE `taskman` SET `starttime` = " . $starttime . " WHERE `id`='" . $taskid . "'");
//that shit for preventing quotes
simple_update_field('taskman', 'address', $address, "WHERE `id`='" . $taskid . "'");
simple_update_field('taskman', 'login', $login, "WHERE `id`='" . $taskid . "'");
simple_update_field('taskman', 'phone', $phone, "WHERE `id`='" . $taskid . "'");
simple_update_field('taskman', 'jobtype', $jobtypeid, "WHERE `id`='" . $taskid . "'");
simple_update_field('taskman', 'employee', $employeeid, "WHERE `id`='" . $taskid . "'");
simple_update_field('taskman', 'jobnote', $jobnote, "WHERE `id`='" . $taskid . "'");
log_register("TASKMAN MODIFY [" . $taskid . "] `" . $address . '`');
}
}
} else {
//editing switch form
$switchid = vf($_GET['edit'], 3);
$switchdata = zb_SwitchGetData($switchid);
//if someone edit switch
if (wf_CheckPost(array('editmodel'))) {
if (cfr('SWITCHESEDIT')) {
simple_update_field('switches', 'modelid', $_POST['editmodel'], "WHERE `id`='" . $switchid . "'");
simple_update_field('switches', 'ip', $_POST['editip'], "WHERE `id`='" . $switchid . "'");
simple_update_field('switches', 'location', $_POST['editlocation'], "WHERE `id`='" . $switchid . "'");
simple_update_field('switches', 'desc', $_POST['editdesc'], "WHERE `id`='" . $switchid . "'");
simple_update_field('switches', 'snmp', $_POST['editsnmp'], "WHERE `id`='" . $switchid . "'");
simple_update_field('switches', 'geo', $_POST['editgeo'], "WHERE `id`='" . $switchid . "'");
if ($_POST['editparentid'] != $switchid) {
simple_update_field('switches', 'parentid', $_POST['editparentid'], "WHERE `id`='" . $switchid . "'");
}
log_register('SWITCH CHANGE [' . $switchid . ']' . ' IP ' . $_POST['editip'] . " LOC `" . $_POST['editlocation'] . "`");
rcms_redirect("?module=switches&edit=" . $switchid);
} else {
show_error(__('Access denied'));
}
}
//render switch edit form
show_window(__('Edit switch'), web_SwitchEditForm($switchid));
//minimap container
if ($altCfg['SWYMAP_ENABLED']) {
if (!empty($switchdata['geo'])) {
show_window(__('Mini-map'), wf_delimiter() . web_SwitchMiniMap($switchdata));
}
}
/**
* cnahges banksta contract number for some existing row
*
* @param int $bankstaid existing bank statement transaction ID
* @param string $contract new contract number for this row
*/
public function bankstaSetContract($bankstaid, $contract)
{
$bankstaid = vf($bankstaid, 3);
$contract = mysql_real_escape_string($contract);
$contract = trim($contract);
if (empty($this->bankstarecords)) {
$this->loadBankstaAll();
}
if (isset($this->bankstarecords[$bankstaid])) {
$oldContract = $this->bankstarecords[$bankstaid]['contract'];
simple_update_field('ukv_banksta', 'contract', $contract, "WHERE `id`='" . $bankstaid . "';");
log_register('UKV BANKSTA [' . $bankstaid . '] CONTRACT `' . $oldContract . '` CHANGED ON `' . $contract . '`');
} else {
log_register('UKV BANKSTA NONEXIST [' . $bankstaid . '] CONTRACT CHANGE TRY');
}
}
/**
* Changes comment text in database
*
* @param int $id existing comment database ID
* @param string $text new text for comment
*/
protected function modifyComment($id, $text)
{
$id = vf($id, 3);
$text = strip_tags($text);
simple_update_field('adcomments', 'text', $text, "WHERE `id`='" . $id . "';");
log_register("ADCOMM CHANGE SCOPE `" . $this->scope . "` ITEM [" . $this->item . "]");
}
/**
* Saves contractor changes in database by data recieved from form
*
* @return void
*/
public function contractorsSave()
{
if (wf_CheckPost(array('editcontractorname', 'editcontractorid'))) {
$contractorId = vf($_POST['editcontractorid'], 3);
if (isset($this->allContractors[$contractorId])) {
simple_update_field('wh_contractors', 'name', $_POST['editcontractorname'], "WHERE `id`='" . $contractorId . "'");
log_register('WAREHOUSE CONTRACTORS EDIT [' . $contractorId . '] `' . $_POST['editcontractorname'] . '`');
} else {
log_register('WAREHOUSE CONTRACTORS EDIT FAIL [' . $contractorId . '] NO_EXISTING');
}
}
}
} else {
//show editing form
$nasid = vf($_GET['edit']);
//if someone editing nas
if (wf_CheckPost(array('editnastype'))) {
$targetnas = "WHERE `id` = '" . $nasid . "'";
$nastype = vf($_POST['editnastype']);
$nasip = mysql_real_escape_string($_POST['editnasip']);
$nasname = mysql_real_escape_string($_POST['editnasname']);
$nasbwdurl = mysql_real_escape_string($_POST['editnasbwdurl']);
$netid = vf($_POST['networkselect']);
simple_update_field('nas', 'nastype', $nastype, $targetnas);
simple_update_field('nas', 'nasip', $nasip, $targetnas);
simple_update_field('nas', 'nasname', $nasname, $targetnas);
simple_update_field('nas', 'bandw', $nasbwdurl, $targetnas);
simple_update_field('nas', 'netid', $netid, $targetnas);
zb_NasConfigSave();
log_register("NAS EDIT " . $nasip);
rcms_redirect("?module=nas&edit=" . $nasid);
}
$nasdata = zb_NasGetData($nasid);
$currentnetid = $nasdata['netid'];
$currentnasip = $nasdata['nasip'];
$currentnasname = $nasdata['nasname'];
$currentnastype = $nasdata['nastype'];
$currentbwdurl = $nasdata['bandw'];
$nastypes = array('local' => 'Local NAS', 'rscriptd' => 'rscriptd', 'mikrotik' => 'MikroTik', 'radius' => 'Radius');
$editinputs = multinet_network_selector($currentnetid) . "<br>";
$editinputs .= wf_Selector('editnastype', $nastypes, 'NAS type', $currentnastype, true);
$editinputs .= wf_TextInput('editnasip', 'IP', $currentnasip, true, '15');
$editinputs .= wf_TextInput('editnasname', 'NAS name', $currentnasname, true, '15');
function uhw_ChangeMac($nethost_id, $newmac)
{
$newmac = strtolower($newmac);
simple_update_field('nethosts', 'mac', $newmac, "WHERE `id`='" . $nethost_id . "'");
}
/**
* Updates line data in database
*
* @return boolean true
*/
public function line_edit_form_submit($id, $data)
{
$where = "WHERE `id` = '" . $id . "'";
foreach ($data as $column => $new_value) {
simple_update_field(self::TABLE_LINES, $column, $new_value, $where);
}
return true;
}
<?php
if (cfr('USERSMAP')) {
$altercfg = $ubillingConfig->getAlter();
if ($altercfg['SWYMAP_ENABLED']) {
//wysiwyg build map placement
if (wf_CheckPost(array('buildplacing', 'placecoords'))) {
if (cfr('BUILDS')) {
$buildid = vf($_POST['buildplacing'], 3);
$placegeo = mysql_real_escape_string($_POST['placecoords']);
simple_update_field('build', 'geo', $placegeo, "WHERE `id`='" . $buildid . "'");
log_register('BUILD CHANGE [' . $buildid . ']' . ' GEO `' . $placegeo . '`');
rcms_redirect("?module=usersmap&locfinder=true");
} else {
show_window(__('Error'), __('Access denied'));
}
}
$ymconf = $ubillingConfig->getYmaps();
$ym_center = $ymconf['CENTER'];
$ym_zoom = $ymconf['ZOOM'];
$ym_type = $ymconf['TYPE'];
$ym_lang = $ymconf['LANG'];
$area = '';
//show map container
um_ShowMapContainer();
//collect biulds geolocation data
$placemarks = um_MapDrawBuilds();
//setting custom zoom and map center if need to find some build
if (wf_CheckGet(array('findbuild'))) {
$ym_zoom = $ymconf['FINDING_ZOOM'];
$ym_center = vf($_GET['findbuild']);
