function bs_FilePush($filename, $rawdata)
{
$filename = vf($filename);
$rawdata = mysql_real_escape_string($rawdata);
$query = "INSERT INTO `bankstaraw` (\n `id` ,\n `filename` ,\n `rawdata`\n )\n VALUES (\n NULL , '" . $filename . "', '" . $rawdata . "'\n );\n ";
nr_query($query);
$lastid = simple_get_lastid('bankstaraw');
return $lastid;
}
/**
* Creates new tag type in database
*
* @return void
*/
function stg_add_tagtype()
{
$color = mysql_real_escape_string($_POST['newcolor']);
$size = vf($_POST['newpriority'], 3);
$text = mysql_real_escape_string($_POST['newtext']);
$query = "INSERT INTO `tagtypes` (`id` ,`tagcolor` ,`tagsize` ,`tagname`) VALUES (NULL , '" . $color . "', '" . $size . "', '" . $text . "');";
nr_query($query);
$newId = simple_get_lastid('tagtypes');
log_register('TAGTYPE ADD `' . $text . '` [' . $newId . ']');
}
public function create($public, $type, $title, $text)
{
$public = vf($public, 3);
$type = vf($type);
$title = mysql_real_escape_string($title);
$text = mysql_real_escape_string($text);
$query = "INSERT INTO `zbsannouncements` (`id`,`public`,`type`,`title`,`text`) VALUES\n (NULL, '" . $public . "', '" . $type . "', '" . $title . "', '" . $text . "'); ";
nr_query($query);
$newId = simple_get_lastid('zbsannouncements');
log_register("ANNOUNCEMENT CREATE [" . $newId . "]");
return $newId;
}
function ms_MassSendMessage($users_arr, $message)
{
global $alter_conf;
if (!empty($users_arr)) {
foreach ($users_arr as $eachuser) {
if (!$alter_conf['MASSSEND_SAFE']) {
ms_SendMessage($eachuser, $message);
} else {
ms_TicketCreate('NULL', $eachuser, $message, 'NULL', whoami());
$newid = simple_get_lastid('ticketing');
ms_TicketSetDone($newid);
}
}
log_register("MASSEND (" . sizeof($users_arr) . ")");
}
}
$altCfg = $ubillingConfig->getAlter();
//if someone creates new task
if (isset($_POST['createtask'])) {
if (wf_CheckPost(array('newstartdate', 'newtaskaddress', 'newtaskphone'))) {
if (wf_CheckPost(array('typicalnote'))) {
$newjobnote = $_POST['typicalnote'] . ' ' . $_POST['newjobnote'];
} else {
$newjobnote = $_POST['newjobnote'];
}
//date validyty check
if (zb_checkDate($_POST['newstartdate'])) {
ts_CreateTask($_POST['newstartdate'], @$_POST['newstarttime'], $_POST['newtaskaddress'], @$_POST['newtasklogin'], $_POST['newtaskphone'], $_POST['newtaskjobtype'], $_POST['newtaskemployee'], $newjobnote);
if (!isset($_GET['gotolastid'])) {
rcms_redirect("?module=taskman");
} else {
$lasttaskid = simple_get_lastid('taskman');
rcms_redirect("?module=taskman&edittask=" . $lasttaskid);
}
} else {
show_error(__('Wrong date format'));
}
} else {
show_error(__('All fields marked with an asterisk are mandatory'));
}
}
//modify task sub
if (isset($_POST['modifytask'])) {
if (wf_CheckPost(array('modifystartdate', 'modifytaskaddress', 'modifytaskphone'))) {
if (zb_checkDate($_POST['modifystartdate'])) {
$taskid = $_POST['modifytask'];
ts_ModifyTask($taskid, $_POST['modifystartdate'], $_POST['modifystarttime'], $_POST['modifytaskaddress'], @$_POST['modifytasklogin'], $_POST['modifytaskphone'], $_POST['modifytaskjobtype'], $_POST['modifytaskemployee'], $_POST['modifytaskjobnote']);
/**
* Creates new address pool in database
*
* @param ...
*
*
* @return void
*/
public function poolCreate($netid, $pool, $netmask, $vlan)
{
$netid = vf($netid, 3);
$pool = mysql_real_escape_string($pool);
$netmask = vf($netmask);
$vlan = vf($vlan, 3);
$query = "INSERT INTO `netextpools` (`id`, `netid`, `pool`, `netmask`, `gw`, `clientip`, `broadcast`, `vlan`, `login`) " . "VALUES (NULL, '" . $netid . "', '" . $pool . "', '" . $netmask . "', NULL, NULL, NULL, '" . $vlan . "', NULL);";
nr_query($query);
$newPoolId = simple_get_lastid('netextpools');
log_register("POOL CREATE [" . $newPoolId . "] `" . $pool . "/" . $netmask . "`");
$newGw = int2ip(ip2int($pool) + 1);
$newBroadcast = int2ip(ip2int($pool) + ($this->cidrOffsets[$netmask] - 1));
simple_update_field('netextpools', 'gw', $newGw, "WHERE `id`='" . $newPoolId . "';");
simple_update_field('netextpools', 'broadcast', $newBroadcast, "WHERE `id`='" . $newPoolId . "';");
//creating ips list for pool
$newIpsStart = int2ip(ip2int($newGw) + 1);
$newIpsEnd = int2ip(ip2int($newBroadcast) - 1);
$this->ipsCreate($newPoolId, $newIpsStart, $newIpsEnd);
}
/**
* Creates new ONU in database and returns it Id or 0 if action fails
*
* @param int $onumodelid
* @param int $oltid
* @param string $ip
* @param string $mac
* @param string $serial
* @param string $login
*
* @return int
*/
public function onuCreate($onumodelid, $oltid, $ip, $mac, $serial, $login)
{
$mac = strtolower($mac);
$mac = trim($mac);
$onumodelid = vf($onumodelid, 3);
$oltid = vf($oltid, 3);
$ip = mysql_real_escape_string($ip);
$macRaw = $mac;
$mac = mysql_real_escape_string($mac);
$serial = mysql_real_escape_string($serial);
$login = mysql_real_escape_string($login);
$login = trim($login);
$result = 0;
if (!empty($mac)) {
if (check_mac_format($mac)) {
if ($this->checkMacUnique($mac)) {
$query = "INSERT INTO `pononu` (`id`, `onumodelid`, `oltid`, `ip`, `mac`, `serial`, `login`) " . "VALUES (NULL, '" . $onumodelid . "', '" . $oltid . "', '" . $ip . "', '" . $mac . "', '" . $serial . "', '" . $login . "');";
nr_query($query);
$result = simple_get_lastid('pononu');
log_register('PON CREATE ONU [' . $result . '] MAC `' . $macRaw . '`');
} else {
log_register('PON MACDUPLICATE TRY `' . $macRaw . '`');
}
} else {
log_register('PON MACINVALID TRY `' . $macRaw . '`');
}
}
return $result;
}
/**
* Creates new outcoming operation record in database
*
* @param string $date
* @param string $desttype
* @param string $destparam
* @param int $storageid
* @param int $itemtypeid
* @param float $count
* @param float $price
* @param string $notes
*
* @return string not emplty if something went wrong
*/
public function outcomingCreate($date, $desttype, $destparam, $storageid, $itemtypeid, $count, $price = '', $notes = '')
{
$result = '';
$date = mysql_real_escape_string($date);
$desttype = mysql_real_escape_string($desttype);
$destparam = mysql_real_escape_string($destparam);
$storageid = vf($storageid, 3);
$itemtypeid = vf($itemtypeid, 3);
$countF = mysql_real_escape_string($count);
$countF = str_replace('-', '', $countF);
$countF = str_replace(',', '.', $countF);
$priceF = mysql_real_escape_string($price);
$priceF = str_replace(',', '.', $priceF);
$notes = mysql_real_escape_string($notes);
if (isset($this->allStorages[$storageid])) {
if (isset($this->allItemTypes[$itemtypeid])) {
$allItemRemains = $this->remainsOnStorage($storageid);
@($itemRemains = $allItemRemains[$itemtypeid]);
$itemsReserved = $this->reserveGet($storageid, $itemtypeid);
$realRemains = $itemRemains - $itemsReserved;
if ($countF <= $realRemains) {
$query = "INSERT INTO `wh_out` (`id`,`date`,`desttype`,`destparam`,`storageid`,`itemtypeid`,`count`,`price`,`notes`) VALUES " . "(NULL,'" . $date . "','" . $desttype . "','" . $destparam . "','" . $storageid . "','" . $itemtypeid . "','" . $countF . "','" . $priceF . "','" . $notes . "')";
nr_query($query);
$newId = simple_get_lastid('wh_out');
log_register('WAREHOUSE OUTCOME CREATE [' . $newId . '] ITEM [' . $itemtypeid . '] COUNT `' . $count . '` PRICE `' . $price . '`');
if ($desttype == 'storage') {
$this->incomingCreate($date, $itemtypeid, 0, $destparam, $count, $price, '', __('from') . ' ' . __('Warehouse storage') . ' `' . $this->allStorages[$storageid] . '`');
}
} else {
$result = $this->messages->getStyledMessage(__('The balance of goods and materials in stock is less than the amount') . ' (' . $countF . ' > ' . $itemRemains . '-' . $itemsReserved . ')', 'error');
}
} else {
$result = $this->messages->getStyledMessage(__('Strange exeption') . ' EX_WRONG_ITEMTYPE_ID', 'error');
}
} else {
$result = $this->messages->getStyledMessage(__('Strange exeption') . ' EX_WRONG_STORAGE_ID', 'error');
}
return $result;
}
private function logResult()
{
$resultStatus = $this->getResult('result');
$resultStatusCode = $this->getResult('resultCode');
$resultComment = $this->getResult('resultComment');
switch ($resultStatusCode) {
case 1:
$resultComment = 'запрос обработан успешно';
break;
case 0:
$resultComment = 'запрос обрабатывается';
break;
case -1:
$resultComment = 'неверный алгоритм ЭП';
break;
case -2:
$resultComment = 'неверный формат ЭП';
break;
case -3:
$resultComment = 'недействительный сертификат ЭП';
break;
case -4:
$resultComment = 'некорректное значение ЭП';
break;
case -5:
$resultComment = 'ошибка проверки сертификата ЭП';
break;
case -6:
$resultComment = 'у заявителя отсутствует лицензия';
break;
case -7:
$resultComment = 'отсутствует идентификатор запроса';
break;
case -8:
$resultComment = 'неверный формат ID запроса';
break;
case -9:
$resultComment = 'не найден запрос по указанному ID';
break;
case -10:
$resultComment = 'повторите запрос позднее';
break;
}
$query = "\r\n INSERT INTO `rbs_results` (`requestID`, `resultStatus`, `resultStatusCode`, `resultComment`, `resultTime`)\r\n VALUES('{$this->_requestPK}', '{$resultStatus}', '{$resultStatusCode}', '{$resultComment}', NOW())\r\n ON DUPLICATE KEY UPDATE `resultStatus` = '{$resultStatus}', `resultStatusCode` = '{$resultStatusCode}', `resultComment` = '{$resultComment}', `resultTime` = NOW()\r\n ";
nr_query($query);
return simple_get_lastid('rbs_results');
}
<td>' . __('Text') . '</td>
</tr>
';
if (!empty($allmessages)) {
foreach ($allmessages as $io => $eachmessage) {
$result .= '
<tr class="row3">
<td>' . $eachmessage['date'] . '</td>
<td>' . $eachmessage['text'] . '</td>
</tr>
';
}
}
$result .= '</table>';
show_window(__('Previous messages'), $result);
}
if (isset($_GET['username'])) {
$login = $_GET['username'];
web_MessagesShowPrevious($login);
if (isset($_POST['messagetext'])) {
zb_TicketCreate('NULL', $login, $_POST['messagetext'], 'NULL', whoami());
$newid = simple_get_lastid('ticketing');
zb_TicketSetDone($newid);
rcms_redirect("?module=pl_sendmessage&username=" . $login);
}
web_MessageSendForm();
show_window('', web_UserControls($login));
}
} else {
show_error(__('You cant control this module'));
}
/**
* Creates new tariff in database
*
* @return void/string on error
*/
public function tariffCreate()
{
$result = '';
if (wf_CheckPost(array('newtariffname', 'newtarifffee', 'newtariffserviceid'))) {
$nameF = mysql_real_escape_string($_POST['newtariffname']);
$feeF = mysql_real_escape_string($_POST['newtarifffee']);
$serviceidF = mysql_real_escape_string($_POST['newtariffserviceid']);
$primary = wf_CheckPost(array('newtariffprimary')) ? 1 : 0;
$freePeriod = wf_CheckPost(array('newtarifffreeperiod')) ? 1 : 0;
if (zb_checkMoney($feeF)) {
$query = "INSERT INTO `mg_tariffs` (`id`,`name`,`fee`,`serviceid`,`primary`,`freeperiod`) VALUES ";
$query .= "(NULL,'" . $nameF . "','" . $feeF . "','" . $serviceidF . "','" . $primary . "','" . $freePeriod . "')";
nr_query($query);
$newId = simple_get_lastid('mg_tariffs');
log_register('MEGOGO TARIFF CREATE [' . $newId . '] `' . $_POST['newtariffname'] . '` FEE `' . $_POST['newtarifffee'] . '`');
} else {
$result = $this->messages->getStyledMessage(__('Wrong format of a sum of money to pay'), 'error');
}
} else {
$result = $this->messages->getStyledMessage(__('No all of required fields is filled'), 'error');
}
return $result;
}
/**
* Creates new personal note in database
*
* @return void
*/
public function addMyNote()
{
if (wf_CheckPost(array('newtext'))) {
$owner = $this->myLogin;
$createDate = curdatetime();
$remindDate = !empty($_POST['newreminddate']) ? $_POST['newreminddate'] : '';
$activity = isset($_POST['newactive']) ? 1 : 0;
$text = $_POST['newtext'];
$this->createNote($owner, $createDate, $remindDate, $activity, $text);
$newId = simple_get_lastid('stickynotes');
log_register("STICKY CREATE [" . $newId . "]");
}
}
/**
* Creates new DB contact record
*
* @param string $phone
* @param string $name
*
* @return void
*/
public function createContact($phone, $name)
{
$phoneF = mysql_real_escape_string($phone);
$nameF = mysql_real_escape_string($name);
$query = "INSERT INTO `contacts` (`id`,`phone`,`name`) VALUES (NULL, '" . $phoneF . "','" . $nameF . "');";
nr_query($query);
$newId = simple_get_lastid('contacts');
log_register('PHONEBOOK CREATE [' . $newId . '] NAME `' . $name . '` PHONE `' . $phone . '`');
}
/**
* Creates new DHCP network
*
* @param int $netid
* @param string $dhcpconfname
*
* @return void
*/
public function createNetwork($netid, $dhcpconfname)
{
$netid = vf($netid, 3);
$dhcpconfname = vf($dhcpconfname);
$dhcpconfname = trim($dhcpconfname);
$query = "INSERT INTO `dhcp` (`id` ,`netid` , `dhcpconfig` , `confname`)\n VALUES (NULL , '" . $netid . "', '', '" . $dhcpconfname . "');";
nr_query($query);
$newID = simple_get_lastid('dhcp');
log_register('CREATE DHCPNet [' . $newID . '] NETWORK [' . $netid . ']');
}
/**
* creates new capability in database
*
* @param $address - users address
* @param $phone - users phone
* @param $notes - text notes to task
*
* @return integer
*/
public function addCapability($address, $phone, $notes)
{
$date = curdatetime();
$address = mysql_real_escape_string($address);
$phone = mysql_real_escape_string($phone);
$notes = mysql_real_escape_string($notes);
$query = "INSERT INTO `capab` (`id` , `date` , `address` , `phone` ,`stateid` ,`notes` ,`price` ,`employeeid` ,`donedate`) \n VALUES ( NULL , '" . $date . "', '" . $address . "', '" . $phone . "', '0', '" . $notes . "', NULL , NULL , NULL);";
nr_query($query);
$lastId = simple_get_lastid('capab');
log_register("CAPABILITY ADD [" . $lastId . "] `" . $address . "`");
}
catv_TariffModify($_POST['edittariffid'], $_POST['edittariffname'], $_POST['edittariffprice'], @$_POST['edittariffchans']);
rcms_redirect("?module=catv&action=tariffs");
}
if (isset($_GET['action'])) {
//show available tariffs and add form
if ($_GET['action'] == 'tariffs') {
catv_TariffShowAll();
catv_TariffAddForm();
}
//show user registration form
if ($_GET['action'] == 'userreg') {
//if someone register user
$needtoregisteruser = array('realyregister');
if (wf_CheckPost($needtoregisteruser)) {
catv_UserRegister($_POST['newusercontract'], $_POST['newuserrealname'], $_POST['newuserstreet'], $_POST['newuserbuild'], $_POST['newuserapt'], $_POST['newuserphone'], $_POST['newusertariff'], $_POST['newusercash'], $_POST['newuserdecoder']);
$newuserid = simple_get_lastid('catv_users');
rcms_redirect("?module=catv_profile&userid=" . $newuserid);
}
catv_UserRegisterForm();
}
//show user list
if ($_GET['action'] == 'showusers') {
if ($alter_conf['CATV_HP_MODE']) {
if (isset($_GET['ajax'])) {
catv_AjaxOnlineDataSource();
}
catv_UsersShowList_hp();
} else {
catv_UsersShowList();
}
}
/**
* Creates new map item in database
*
* @param int $mapid
* @param string $type
* @param string $geo
* @param string $name
* @param string $location
*/
public function itemCreate($mapid, $type, $geo, $name, $location)
{
$mapid = vf($mapid, 3);
$type = mysql_real_escape_string($type);
$geo = mysql_real_escape_string($geo);
$nameFiltered = mysql_real_escape_string($name);
$location = mysql_real_escape_string($location);
if (isset($this->allMaps[$mapid])) {
$query = "INSERT INTO `custmapsitems` (`id`, `mapid`, `type`, `geo`, `name`, `location`) " . "VALUES (NULL, '" . $mapid . "', '" . $type . "', '" . $geo . "', '" . $nameFiltered . "', '" . $location . "');";
nr_query($query);
$newId = simple_get_lastid('custmapsitems');
log_register('CUSTMAPS CREATE ITEM `' . $name . '` ID [' . $newId . ']');
} else {
throw new Exception(self::EX_NO_MAP_ID);
}
}
function docsis_ModemAdd($maclan)
{
$maclan = mysql_real_escape_string($maclan);
//random mac for usb
$macusb = '14:' . '88' . ':' . rand(10, 99) . ':' . rand(10, 99) . ':' . rand(10, 99) . ':' . rand(10, 99);
$altercfg = rcms_parse_ini_file(CONFIG_PATH . '/alter.ini');
$netid = $altercfg['DOCSIS_MODEM_NETID'];
$nextfreeip = multinet_get_next_freeip('nethosts', 'ip', $netid);
$note = '';
$userbind = '';
$basetemplate = 'short';
$date = curdate();
//check for free ip in subnet
if (!empty($nextfreeip)) {
$nic = str_replace('.', 'x', $nextfreeip);
//check is mac unique?
if (multinet_mac_free($maclan) and check_mac_format($maclan)) {
$query = "INSERT INTO `modems` (\n `id` ,\n `maclan` ,\n `macusb` ,\n `date` ,\n `ip` ,\n `conftemplate` ,\n `userbind` ,\n `nic` ,\n `note`\n )\n VALUES (\n NULL , '" . $maclan . "', '" . $maclan . "', '" . $date . "', '" . $nextfreeip . "', '" . $basetemplate . "', '' , '" . $nic . "', ''\n );";
nr_query($query);
$lastid = simple_get_lastid('modems');
log_register("DOCSIS MODEM ADD MAC" . $maclan . " IP " . $nextfreeip . "[" . $lastid . "]");
multinet_add_host($netid, $nextfreeip, $maclan, '');
multinet_rebuild_all_handlers();
rcms_redirect("?module=docsis&showmodem=" . $lastid);
} else {
show_window(__('Error'), __('This MAC is currently used') . ' ' . __('This MAC have wrong format'));
}
} else {
show_window(__('Error'), __('No free IP available in selected pool'));
}
}
/**
* registers new users into database and returns new user ID
*
* @return int
*/
public function userCreate()
{
$curdate = date("Y-m-d H:i:s");
$query = "\n INSERT INTO `ukv_users` (\n `id` ,\n `contract` ,\n `tariffid` ,\n `cash` ,\n `active` ,\n `realname` ,\n `passnum` ,\n `passwho` ,\n `passdate` ,\n `paddr`,\n `ssn` ,\n `phone` ,\n `mobile` ,\n `regdate` ,\n `city` ,\n `street` ,\n `build` ,\n `apt` ,\n `inetlogin` ,\n `notes`\n )\n VALUES (\n NULL ,\n NULL ,\n NULL ,\n '" . self::REG_CASH . "',\n '" . self::REG_ACT . "',\n NULL ,\n NULL ,\n NULL ,\n NULL ,\n NULL ,\n NULL ,\n NULL ,\n NULL ,\n '" . $curdate . "',\n NULL ,\n NULL ,\n NULL ,\n NULL ,\n NULL ,\n NULL\n ); ";
nr_query($query);
$newUserId = simple_get_lastid('ukv_users');
$result = $newUserId;
log_register("UKV REGISTER USER ((" . $newUserId . "))");
//saving post registration data
$this->userPostRegSave($newUserId);
return $result;
}
/**
* Creates new switch device in database
*
* @param int $modelid
* @param string $ip
* @param string $desc
* @param string $location
* @param string $snmp
* @param string $geo
* @param int $parentid
*/
function ub_SwitchAdd($modelid, $ip, $desc, $location, $snmp, $geo, $parentid = '')
{
$modelid = vf($modelid, 3);
$ip = mysql_real_escape_string($ip);
$desc = mysql_real_escape_string($desc);
$location = mysql_real_escape_string($location);
$snmp = mysql_real_escape_string($snmp);
$parentid = vf($parentid, 3);
if (!empty($parentid)) {
$parentid = "'" . $parentid . "'";
} else {
$parentid = 'NULL';
}
$query = "INSERT INTO `switches` (`id` ,`modelid` ,`ip` ,`desc` ,`location` ,`snmp`,`geo`,`parentid`) " . "VALUES ('', '" . $modelid . "', '" . $ip . "', '" . $desc . "', '" . $location . "', '" . $snmp . "','" . $geo . "', " . $parentid . " );";
nr_query($query);
$lastid = simple_get_lastid('switches');
log_register('SWITCH ADD [' . $lastid . '] IP `' . $ip . '` ON LOC `' . $location . '`');
show_window(__('Add switch'), __('Was added new switch') . ' ' . $ip . ' ' . $location);
}
/**
* creates new contact person in database
*
* @return void
*/
public function personCreate()
{
if (wf_CheckPost(array('addpersoncorpid', 'addpersonrealname'))) {
$corpid = vf($_POST['addpersoncorpid']);
$realname = mysql_real_escape_string($_POST['addpersonrealname']);
$phone = mysql_real_escape_string($_POST['addpersonphone']);
$im = mysql_real_escape_string($_POST['addpersonim']);
$email = mysql_real_escape_string($_POST['addpersonemail']);
$appointment = mysql_real_escape_string($_POST['addpersonappointment']);
if (isset($this->corps[$corpid])) {
$query = "INSERT INTO `corp_persons` (`id`, `corpid`, `realname`, `phone`, `im`, `email`, `appointment`) VALUES (NULL, '" . $corpid . "', '" . $realname . "', '" . $phone . "', '" . $im . "', '" . $email . "', '" . $appointment . "');";
nr_query($query);
$newId = simple_get_lastid('corp_persons');
log_register("CORPS CREATE PERSON [" . $newId . "] FOR CORP [" . $corpid . "]");
}
}
}
/**
* Write to DB sheduled task and log that
*
* @param string $date
* @param string $login
* @param string $action
* @param string $param
* @param string $note
*/
function createTask($date, $login, $action, $param, $note)
{
$dateF = mysql_real_escape_string($date);
$loginF = mysql_real_escape_string($login);
$actionF = mysql_real_escape_string($action);
$paramF = mysql_real_escape_string($param);
$noteF = mysql_real_escape_string($note);
$query = "INSERT INTO `dealwithit` (`id`,`date`,`login`,`action`,`param`,`note`) VALUES";
$query .= "(NULL,'" . $dateF . "','" . $loginF . "','" . $actionF . "','" . $paramF . "','" . $noteF . "');";
nr_query($query);
$newId = simple_get_lastid('dealwithit');
log_register('SCHEDULER CREATE ID [' . $newId . '] (' . $login . ') DATE `' . $date . ' `ACTION `' . $action . '` NOTE `' . $note . '`');
}
/**
* Creates new salary job for some task
*
* @param int $taskid
* @param int $employeeid
* @param int $jobtypeid
* @param float $factor
* @param float $overprice
* @param string $notes
*
* @return void
*/
public function createSalaryJob($taskid, $employeeid, $jobtypeid, $factor, $overprice, $notes)
{
$taskid = vf($taskid, 3);
$employeeid = vf($employeeid, 3);
$jobtypeid = vf($jobtypeid, 3);
$factor = str_replace(',', '.', $factor);
$overprice = str_replace(',', '.', $overprice);
$notes = mysql_real_escape_string($notes);
$overprice = mysql_real_escape_string($overprice);
$date = curdatetime();
$state = 0;
$query = "INSERT INTO `salary_jobs` (`id`, `date`, `state` ,`taskid`, `employeeid`, `jobtypeid`, `factor`, `overprice`, `note`)" . " VALUES (NULL, '" . $date . "', '" . $state . "' ,'" . $taskid . "', '" . $employeeid . "', '" . $jobtypeid . "', '" . $factor . "', '" . $overprice . "', '" . $notes . "');";
nr_query($query);
$newId = simple_get_lastid('salary_jobs');
log_register('SALARY CREATE JOB [' . $newId . '] TASK [' . $taskid . '] EMPLOYEE [' . $employeeid . '] JOBTYPE [' . $jobtypeid . '] FACTOR `' . $factor . '` OVERPRICE `' . $overprice . '`');
}
