function web_UsersLister($users)
{
$tablecells = wf_TableCell(__('Login'));
$tablecells .= wf_TableCell(__('Real Name'));
$tablecells .= wf_TableCell(__('Full address'));
$tablecells .= wf_TableCell(__('Tariff'));
$tablecells .= wf_TableCell(__('Tariff speeds'));
$tablecells .= wf_TableCell(__('Speed override'));
$tablecells .= wf_TableCell(__('Actions'));
$tablerows = wf_TableRow($tablecells, 'row1');
if (!empty($users)) {
$udata = array();
$alluserdata = zb_UserGetAllStargazerData();
$alladdress = zb_AddressGetFulladdresslist();
$allrealnames = zb_UserGetAllRealnames();
$allspeeds = zb_TariffGetAllSpeeds();
if (!empty($alluserdata)) {
foreach ($alluserdata as $ia => $eachdata) {
$udata[$eachdata['login']]['Tariff'] = $eachdata['Tariff'];
@($udata[$eachdata['login']]['Address'] = $alladdress[$eachdata['login']]);
@($udata[$eachdata['login']]['RealName'] = $allrealnames[$eachdata['login']]);
@($udata[$eachdata['login']]['NormalSpeedDown'] = $allspeeds[$eachdata['Tariff']]['speeddown']);
@($udata[$eachdata['login']]['NormalSpeedUp'] = $allspeeds[$eachdata['Tariff']]['speedup']);
}
}
foreach ($users as $io => $eachuser) {
$tablecells = wf_TableCell(wf_Link('?module=userprofile&username='******'login'], web_profile_icon() . ' ' . $eachuser['login']));
$tablecells .= wf_TableCell($udata[$eachuser['login']]['RealName']);
$tablecells .= wf_TableCell($udata[$eachuser['login']]['Address']);
$tablecells .= wf_TableCell($udata[$eachuser['login']]['Tariff']);
$tablecells .= wf_TableCell($udata[$eachuser['login']]['NormalSpeedDown'] . '/' . $udata[$eachuser['login']]['NormalSpeedUp']);
$tablecells .= wf_TableCell(zb_UserGetSpeedOverride($eachuser['login']));
$fixlink = wf_JSAlert('?module=speedcontrol&fix=' . $eachuser['login'], '<img src="skins/icon_repair.gif" title=' . __('Fix') . '>', 'Are you serious');
$tablecells .= wf_TableCell($fixlink);
$tablerows .= wf_TableRow($tablecells, 'row3');
}
}
$result = wf_TableBody($tablerows, '100%', '0', 'sortable');
return $result;
}
/**
* Loads available tariff speeds from database
*
* @return void
*/
protected function loadSpeeds()
{
$this->allSpeeds = zb_TariffGetAllSpeeds();
}
/**
* loads user data for template processing
*
* @return void
*/
public function loadAllUserData()
{
$userdata = array();
$alluserdata = zb_UserGetAllStargazerData();
$tariffspeeds = zb_TariffGetAllSpeeds();
$tariffprices = zb_TariffGetPricesAll();
$multinetdata = zb_MultinetGetAllData();
$allcontracts = zb_UserGetAllContracts();
$allcontracts = array_flip($allcontracts);
$contractDates = $this->getContractDatesAll();
$allphonedata = zb_UserGetAllPhoneData();
$allrealnames = zb_UserGetAllRealnames();
$alladdress = zb_AddressGetFulladdresslist();
$allemails = zb_UserGetAllEmails();
$allnasdata = zb_NasGetAllData();
$allcfdata = cf_FieldsGetAll();
$allpdata = zb_UserPassportDataGetAll();
$curdate = curdate();
$lastDocId = $this->getDocumentLastId();
$newDocId = $lastDocId + 1;
if ($this->altcfg['OPENPAYZ_REALID']) {
$allopcustomers = zb_TemplateGetAllOPCustomers();
}
if (!empty($alluserdata)) {
foreach ($alluserdata as $io => $eachuser) {
$userdata[$eachuser['login']]['LOGIN'] = $eachuser['login'];
$userdata[$eachuser['login']]['PASSWORD'] = $eachuser['Password'];
$userdata[$eachuser['login']]['USERHASH'] = crc16($eachuser['login']);
$userdata[$eachuser['login']]['TARIFF'] = $eachuser['Tariff'];
@($userdata[$eachuser['login']]['TARIFFPRICE'] = $tariffprices[$eachuser['Tariff']]);
$userdata[$eachuser['login']]['CASH'] = $eachuser['Cash'];
$userdata[$eachuser['login']]['CREDIT'] = $eachuser['Credit'];
$userdata[$eachuser['login']]['DOWN'] = $eachuser['Down'];
$userdata[$eachuser['login']]['PASSIVE'] = $eachuser['Passive'];
$userdata[$eachuser['login']]['AO'] = $eachuser['AlwaysOnline'];
@($userdata[$eachuser['login']]['CONTRACT'] = $allcontracts[$eachuser['login']]);
@($userdata[$eachuser['login']]['CONTRACTDATE'] = $contractDates[$eachuser['login']]['contractdate']);
@($userdata[$eachuser['login']]['REALNAME'] = $allrealnames[$eachuser['login']]);
@($userdata[$eachuser['login']]['ADDRESS'] = $alladdress[$eachuser['login']]);
@($userdata[$eachuser['login']]['EMAIL'] = $allemails[$eachuser['login']]);
@($userdata[$eachuser['login']]['PHONE'] = $allphonedata[$eachuser['login']]['phone']);
@($userdata[$eachuser['login']]['MOBILE'] = $allphonedata[$eachuser['login']]['mobile']);
//openpayz payment ID
if ($this->altcfg['OPENPAYZ_REALID']) {
@($userdata[$eachuser['login']]['PAYID'] = $allopcustomers[$eachuser['login']]);
} else {
@($userdata[$eachuser['login']]['PAYID'] = ip2int($eachuser['IP']));
}
//traffic params
$userdata[$eachuser['login']]['TRAFFIC'] = $eachuser['D0'] + $eachuser['U0'];
$userdata[$eachuser['login']]['TRAFFICDOWN'] = $eachuser['D0'];
$userdata[$eachuser['login']]['TRAFFICUP'] = $eachuser['U0'];
//net params
@($userdata[$eachuser['login']]['IP'] = $eachuser['IP']);
@($userdata[$eachuser['login']]['MAC'] = $multinetdata[$eachuser['IP']]['mac']);
@($userdata[$eachuser['login']]['NETID'] = $multinetdata[$eachuser['IP']]['netid']);
@($userdata[$eachuser['login']]['HOSTID'] = $multinetdata[$eachuser['IP']]['id']);
//nas data
@($usernas = zb_NasGetParams($multinetdata[$eachuser['IP']]['netid'], $allnasdata));
@($userdata[$eachuser['login']]['NASID'] = $usernas['id']);
@($userdata[$eachuser['login']]['NASIP'] = $usernas['nasip']);
@($userdata[$eachuser['login']]['NASNAME'] = $usernas['nasname']);
@($userdata[$eachuser['login']]['NASTYPE'] = $usernas['nastype']);
if (isset($tariffspeeds[$eachuser['Tariff']])) {
$userdata[$eachuser['login']]['SPEEDDOWN'] = $tariffspeeds[$eachuser['Tariff']]['speeddown'];
$userdata[$eachuser['login']]['SPEEDUP'] = $tariffspeeds[$eachuser['Tariff']]['speedup'];
} else {
//if no tariff speed defined zero speed by default
$userdata[$eachuser['login']]['SPEEDDOWN'] = 0;
$userdata[$eachuser['login']]['SPEEDUP'] = 0;
}
//passport data
@($userdata[$eachuser['login']]['PBIRTH'] = $allpdata[$eachuser['login']]['birthdate']);
@($userdata[$eachuser['login']]['PNUM'] = $allpdata[$eachuser['login']]['passportnum']);
@($userdata[$eachuser['login']]['PDATE'] = $allpdata[$eachuser['login']]['passportdate']);
@($userdata[$eachuser['login']]['PWHO'] = $allpdata[$eachuser['login']]['passportwho']);
@($userdata[$eachuser['login']]['PCITY'] = $allpdata[$eachuser['login']]['pcity']);
@($userdata[$eachuser['login']]['PSTREET'] = $allpdata[$eachuser['login']]['pstreet']);
@($userdata[$eachuser['login']]['PBUILD'] = $allpdata[$eachuser['login']]['pbuild']);
@($userdata[$eachuser['login']]['PAPT'] = $allpdata[$eachuser['login']]['papt']);
//other document data
@($userdata[$eachuser['login']]['CURDATE'] = $curdate);
@($userdata[$eachuser['login']]['DOCID'] = $newDocId);
}
}
$this->userData = $userdata;
}
function web_TariffLister()
{
$alltariffs = billing_getalltariffs();
$dbSchema = zb_CheckDbSchema();
global $ubillingConfig;
$alter = $ubillingConfig->getAlter();
$tariffSpeeds = zb_TariffGetAllSpeeds();
$cells = wf_TableCell(__('Tariff name'));
$cells .= wf_TableCell(__('Tariff Fee'));
if ($dbSchema > 0) {
$cells .= wf_TableCell(__('Period'));
}
$cells .= wf_TableCell(__('Speed'));
$cells .= wf_TableCell(__('Actions'));
$rows = wf_TableRow($cells, 'row1');
$result = wf_Link("?module=tariffs&action=new", __('Create new tariff'), true, 'ubButton');
if (!empty($alltariffs)) {
foreach ($alltariffs as $io => $eachtariff) {
$cells = wf_TableCell($eachtariff['name']);
$cells .= wf_TableCell($eachtariff['Fee']);
if ($dbSchema > 0) {
$cells .= wf_TableCell(__($eachtariff['period']));
}
if (isset($tariffSpeeds[$eachtariff['name']])) {
$speedData = $tariffSpeeds[$eachtariff['name']]['speeddown'] . ' / ' . $tariffSpeeds[$eachtariff['name']]['speedup'];
} else {
$speedData = wf_tag('font', false, '', 'color="#bc0000"') . __('Speed is not set') . wf_tag('font', true);
}
$cells .= wf_TableCell($speedData);
$actions = wf_JSAlert("?module=tariffs&action=delete&tariffname=" . $eachtariff['name'], web_delete_icon(), __('Delete') . ' ' . $eachtariff['name'] . '? ' . __('Removing this may lead to irreparable results'));
$actions .= wf_JSAlert("?module=tariffs&action=edit&tariffname=" . $eachtariff['name'], web_edit_icon(), __('Edit') . ' ' . $eachtariff['name'] . '? ' . __('Are you serious'));
$actions .= wf_Link('?module=tariffspeeds&tariff=' . $eachtariff['name'], wf_img('skins/icon_speed.gif', __('Edit speed')), false, '');
$actions .= isset($alter['SIGNUP_PAYMENTS']) && !empty($alter['SIGNUP_PAYMENTS']) ? wf_Link('?module=signupprices&tariff=' . $eachtariff['name'], wf_img('skins/icons/register.png', __('Edit signup price')), false, '') : null;
$cells .= wf_TableCell($actions);
$rows .= wf_TableRow($cells, 'row3');
}
}
$result .= wf_TableBody($rows, '100%', 0, 'sortable');
return $result;
}
<?php
$result = '';
if (cfr('USERPROFILE')) {
if (wf_CheckGet(array('tariff'))) {
$tariffName = mysql_real_escape_string($_GET['tariff']);
$tariffNameRaw = $_GET['tariff'];
$tariffInfo = '';
if ($tariffName == '*_NO_TARIFF_*') {
$messages = new UbillingMessageHelper();
$tariffInfo = $messages->getStyledMessage(__('No tariff'), 'warning');
} else {
$tariffPrice = zb_TariffGetPrice($tariffNameRaw);
$tariffPeriods = zb_TariffGetPeriodsAll();
$tariffSpeeds = zb_TariffGetAllSpeeds();
$speedDown = isset($tariffSpeeds[$tariffName]) ? $tariffSpeeds[$tariffName]['speeddown'] : __('No');
$speedUp = isset($tariffSpeeds[$tariffName]) ? $tariffSpeeds[$tariffName]['speedup'] : __('No');
$period = isset($tariffPeriods[$tariffName]) ? __($tariffPeriods[$tariffName]) : __('No');
$cells = wf_TableCell(__('Fee'), '', 'row1');
$cells .= wf_TableCell($tariffPrice);
$rows = wf_TableRow($cells, 'row2');
$cells = wf_TableCell(__('Download speed'), '', 'row1');
$cells .= wf_TableCell($speedDown);
$rows .= wf_TableRow($cells, 'row2');
$cells = wf_TableCell(__('Upload speed'), '', 'row1');
$cells .= wf_TableCell($speedUp);
$rows .= wf_TableRow($cells, 'row2');
$cells = wf_TableCell(__('Period'), '', 'row1');
$cells .= wf_TableCell($period);
$rows .= wf_TableRow($cells, 'row2');
$tariffInfo = wf_TableBody($rows, '40%', 0, '');
<?php
if (cfr('TARIFFSPEED')) {
if (isset($_GET['tariff'])) {
// show speed editor and create speed if need
$tariff = mysql_real_escape_string($_GET['tariff']);
$existingspeeds = zb_TariffGetAllSpeeds();
if (!isset($existingspeeds[$tariff]['speeddown'])) {
zb_TariffCreateSpeed($tariff, 0, 0);
$existingspeeds = zb_TariffGetAllSpeeds();
}
$fieldnames = array('fieldname1' => __('Down speed Kbit/s'), 'fieldname2' => __('Up speed Kbit/s'));
$fieldkeys = array('fieldkey1' => 'newspeeddown', 'fieldkey2' => 'newspeedup');
$olddata[1] = $existingspeeds[$tariff]['speeddown'];
$olddata[2] = $existingspeeds[$tariff]['speedup'];
show_window(__('Edit speed') . ' ' . $tariff, web_EditorTwoStringDataForm($fieldnames, $fieldkeys, $olddata));
show_window('', wf_Link("?module=tariffspeeds", 'Back', true, 'ubButton'));
// if all ok save speed
if (isset($_POST['newspeeddown']) and isset($_POST['newspeedup'])) {
zb_TariffDeleteSpeed($tariff);
$newSpeedDown = trim($_POST['newspeeddown']);
$newSpeedUp = trim($_POST['newspeedup']);
zb_TariffCreateSpeed($tariff, $newSpeedDown, $newSpeedUp);
rcms_redirect("?module=tariffspeeds");
}
} else {
//deleting speed
if (wf_CheckGet(array('deletespeed'))) {
zb_TariffDeleteSpeed($_GET['deletespeed']);
rcms_redirect("?module=tariffspeeds");
}
/**
* Returns tariffs popularity report
*
* @return string
*/
function web_TariffShowReport()
{
global $ubillingConfig;
$altCfg = $ubillingConfig->getAlter();
$fullFlag = false;
$tariffcount = zb_TariffGetLiveCount();
$allTariffData = zb_TariffGetAllData();
if (isset($altCfg['TARIFF_REPORT_FULL'])) {
if ($altCfg['TARIFF_REPORT_FULL']) {
$fullFlag = true;
}
}
if ($fullFlag) {
$dbSchema = zb_CheckDbSchema();
$tariffSpeeds = zb_TariffGetAllSpeeds();
}
$maxArr = array();
$totalusers = 0;
$liveusersCounter = 0;
$deadusersCounter = 0;
$cells = wf_TableCell(__('Tariff'));
if ($fullFlag) {
$cells .= wf_TableCell(__('Fee'));
if ($dbSchema > 0) {
$cells .= wf_TableCell(__('Period'));
}
$cells .= wf_TableCell(__('Speed'));
}
$cells .= wf_TableCell(__('Total'));
$cells .= wf_TableCell(__('Visual'));
$cells .= wf_TableCell(__('Active'));
$rows = wf_TableRow($cells, 'row1');
if (!empty($tariffcount)) {
$maxusers = 0;
foreach ($tariffcount as $io => $eachtcount) {
$maxArr[$io] = $eachtcount['alive'] + $eachtcount['dead'];
}
$maxusers = max($maxArr);
foreach ($tariffcount as $eachtariffname => $eachtariffcount) {
$totalusers = $totalusers + $eachtariffcount['alive'] + $eachtariffcount['dead'];
$deadusersCounter = $deadusersCounter + $eachtariffcount['dead'];
$liveusersCounter = $liveusersCounter + $eachtariffcount['alive'];
$tarif_data = $allTariffData[$eachtariffname];
$cells = wf_TableCell($eachtariffname);
if ($fullFlag) {
$cells .= wf_TableCell($tarif_data['Fee']);
if ($dbSchema > 0) {
$cells .= wf_TableCell(__($tarif_data['period']));
}
if (isset($tariffSpeeds[$eachtariffname])) {
$speedData = $tariffSpeeds[$eachtariffname]['speeddown'] . ' / ' . $tariffSpeeds[$eachtariffname]['speedup'];
} else {
$speedData = wf_tag('font', false, '', 'color="#bc0000"') . __('Speed is not set') . wf_tag('font', true);
}
$cells .= wf_TableCell($speedData);
}
$cells .= wf_TableCell($eachtariffcount['alive'] + $eachtariffcount['dead']);
$cells .= wf_TableCell(web_bar($eachtariffcount['alive'], $maxusers), '', '', 'sorttable_customkey="' . $eachtariffcount['alive'] . '"');
$cells .= wf_TableCell(web_barTariffs($eachtariffcount['alive'], $eachtariffcount['dead']), '', '', 'sorttable_customkey="' . $eachtariffcount['alive'] . '"');
$rows .= wf_TableRow($cells, 'row5');
}
}
$result = wf_TableBody($rows, '100%', 0, 'sortable');
$result .= wf_tag('h2') . __('Total') . ': ' . $totalusers . wf_tag('h2', true);
$result .= __('Active users') . ': ' . $liveusersCounter;
$result .= wf_tag('br');
$result .= __('Inactive users') . ': ' . $deadusersCounter;
return $result;
}
/**
* Returns list of available tariffs speeds
*
* @return string
*/
function web_TariffSpeedLister()
{
$results = '';
$alltariffs = zb_TariffsGetAll();
$availTariffs = array();
$allspeeds = zb_TariffGetAllSpeeds();
$cleanSpeedCount = 0;
$cells = wf_TableCell(__('Tariff'));
$cells .= wf_TableCell(__('Download speed'));
$cells .= wf_TableCell(__('Upload speed'));
$cells .= wf_TableCell(__('Actions'));
$rows = wf_TableRow($cells, 'row1');
if (!empty($alltariffs)) {
foreach ($alltariffs as $io => $eachtariff) {
$availTariffs[$eachtariff['name']] = $eachtariff['name'];
$cells = wf_TableCell($eachtariff['name']);
$cells .= wf_TableCell(@$allspeeds[$eachtariff['name']]['speeddown']);
$cells .= wf_TableCell(@$allspeeds[$eachtariff['name']]['speedup']);
$actLinks = wf_JSAlert('?module=tariffspeeds&tariff=' . $eachtariff['name'], web_edit_icon(), __('Are you serious'));
$cells .= wf_TableCell($actLinks);
$rows .= wf_TableRow($cells, 'row3');
}
}
$result = wf_TableBody($rows, '100%', 0, 'sortable');
if (!empty($allspeeds)) {
$cells = wf_TableCell(__('Tariff') . ' (' . __('Deleted') . ')');
$cells .= wf_TableCell(__('Download speed'));
$cells .= wf_TableCell(__('Upload speed'));
$cells .= wf_TableCell(__('Actions'));
$rows = wf_TableRow($cells, 'row1');
foreach ($allspeeds as $eachtariff => $eachspeed) {
if (!isset($availTariffs[$eachtariff])) {
$cells = wf_TableCell($eachtariff);
$cells .= wf_TableCell($eachspeed['speeddown']);
$cells .= wf_TableCell($eachspeed['speedup']);
$cells .= wf_TableCell(wf_JSAlert('?module=tariffspeeds&deletespeed=' . $eachtariff, web_delete_icon(), __('Are you serious')));
$rows .= wf_TableRow($cells, 'row3');
$cleanSpeedCount++;
}
}
if ($cleanSpeedCount != 0) {
$result .= wf_delimiter();
$result .= wf_tag('h3') . __('Database cleanup') . wf_tag('h3', true);
$result .= wf_TableBody($rows, '100%', 0, 'sortable');
}
}
return $result;
}
/**
* Returns all data about current userbase
* which used for templatizing functions
*
* @return array
*/
function zb_TemplateGetAllUserData()
{
$altcfg = rcms_parse_ini_file(CONFIG_PATH . "alter.ini");
$userdata = array();
$alluserdata = zb_UserGetAllStargazerData();
$tariffspeeds = zb_TariffGetAllSpeeds();
$tariffprices = zb_TariffGetPricesAll();
$multinetdata = zb_MultinetGetAllData();
$allcontracts = zb_UserGetAllContracts();
$allcontracts = array_flip($allcontracts);
$allrealnames = zb_UserGetAllRealnames();
$alladdress = zb_AddressGetFulladdresslist();
$allemails = zb_UserGetAllEmails();
$allnasdata = zb_NasGetAllData();
$allcfdata = cf_FieldsGetAll();
$allpdata = zb_UserPassportDataGetAll();
if ($altcfg['OPENPAYZ_REALID']) {
$allopcustomers = zb_TemplateGetAllOPCustomers();
}
if (!empty($alluserdata)) {
foreach ($alluserdata as $io => $eachuser) {
$userdata[$eachuser['login']]['login'] = $eachuser['login'];
$userdata[$eachuser['login']]['password'] = $eachuser['Password'];
$userdata[$eachuser['login']]['userhash'] = crc16($eachuser['login']);
$userdata[$eachuser['login']]['tariff'] = $eachuser['Tariff'];
@($userdata[$eachuser['login']]['tariffprice'] = $tariffprices[$eachuser['Tariff']]);
$userdata[$eachuser['login']]['cash'] = $eachuser['Cash'];
$userdata[$eachuser['login']]['credit'] = $eachuser['Credit'];
$userdata[$eachuser['login']]['down'] = $eachuser['Down'];
$userdata[$eachuser['login']]['passive'] = $eachuser['Passive'];
$userdata[$eachuser['login']]['ao'] = $eachuser['AlwaysOnline'];
@($userdata[$eachuser['login']]['contract'] = $allcontracts[$eachuser['login']]);
@($userdata[$eachuser['login']]['realname'] = $allrealnames[$eachuser['login']]);
@($userdata[$eachuser['login']]['address'] = $alladdress[$eachuser['login']]);
@($userdata[$eachuser['login']]['email'] = $allemails[$eachuser['login']]);
//openpayz payment ID
if ($altcfg['OPENPAYZ_REALID']) {
@($userdata[$eachuser['login']]['payid'] = $allopcustomers[$eachuser['login']]);
} else {
@($userdata[$eachuser['login']]['payid'] = ip2int($eachuser['IP']));
}
//traffic params
$userdata[$eachuser['login']]['traffic'] = $eachuser['D0'] + $eachuser['U0'];
$userdata[$eachuser['login']]['trafficdown'] = $eachuser['D0'];
$userdata[$eachuser['login']]['trafficup'] = $eachuser['U0'];
//net params
$userdata[$eachuser['login']]['ip'] = $eachuser['IP'];
@($userdata[$eachuser['login']]['mac'] = $multinetdata[$eachuser['IP']]['mac']);
@($userdata[$eachuser['login']]['netid'] = $multinetdata[$eachuser['IP']]['netid']);
@($userdata[$eachuser['login']]['hostid'] = $multinetdata[$eachuser['IP']]['id']);
//nas data
@($usernas = zb_NasGetParams($multinetdata[$eachuser['IP']]['netid'], $allnasdata));
@($userdata[$eachuser['login']]['nasid'] = $usernas['id']);
@($userdata[$eachuser['login']]['nasip'] = $usernas['nasip']);
@($userdata[$eachuser['login']]['nasname'] = $usernas['nasname']);
@($userdata[$eachuser['login']]['nastype'] = $usernas['nastype']);
if (isset($tariffspeeds[$eachuser['Tariff']])) {
$userdata[$eachuser['login']]['speeddown'] = $tariffspeeds[$eachuser['Tariff']]['speeddown'];
$userdata[$eachuser['login']]['speedup'] = $tariffspeeds[$eachuser['Tariff']]['speedup'];
} else {
//if no tariff speed defined zero speed by default
$userdata[$eachuser['login']]['speeddown'] = 0;
$userdata[$eachuser['login']]['speedup'] = 0;
}
//CF data
$usercfdata = zb_cfGetContent($eachuser['login'], $allcfdata);
if (!empty($usercfdata)) {
foreach ($usercfdata as $cd => $eachcf) {
$userdata[$eachuser['login']]['cf'][$cd] = $eachcf;
}
}
//passport data
@($userdata[$eachuser['login']]['birthdate'] = $allpdata[$eachuser['login']]['birthdate']);
@($userdata[$eachuser['login']]['passportnum'] = $allpdata[$eachuser['login']]['passportnum']);
@($userdata[$eachuser['login']]['passportdate'] = $allpdata[$eachuser['login']]['passportdate']);
@($userdata[$eachuser['login']]['passportwho'] = $allpdata[$eachuser['login']]['passportwho']);
@($userdata[$eachuser['login']]['pcity'] = $allpdata[$eachuser['login']]['pcity']);
@($userdata[$eachuser['login']]['pstreet'] = $allpdata[$eachuser['login']]['pstreet']);
@($userdata[$eachuser['login']]['pbuild'] = $allpdata[$eachuser['login']]['pbuild']);
@($userdata[$eachuser['login']]['papt'] = $allpdata[$eachuser['login']]['papt']);
}
}
return $userdata;
}
# $pmas_group[$pi1][1] - ID группы (по версии биллинга) (текст)
# $pmas_group[$pi1][2] - Название группы (текст)
# $pmas_group[$pi1][3] - Стоимость за переработку трафика (число или ноль)
# $pmas_group[$pi1][4] - Включенный трафик (число или ноль)
# $pmas_group[$pi1][5] - Метод учета трафика (0 - по входящему, 1 - по исходящему, 2 - по сумме, 3 - по максимуму)
# $pmas_group[$pi1][6] - Размер абонплаты (число или ноль)
# $pmas_group[$pi1][7] - Флаг - ежедневная ли абонплата (1 или 0)
# $pmas_group[$pi1][8] - Входящая скорость в kbps (число или ноль)
# $pmas_group[$pi1][9] - Исходящая скорость в kbps (число или ноль)
#================================================================================================================
*/
$ps_file101 = $ps_rep_logupd;
printlog("формируем из БД биллинга массив с тарифными планами");
$pi1 = 0;
//выцепляем скоростя всех тарифов
$allspeeds = zb_TariffGetAllSpeeds($conn1);
$rs = sqa($conn1, "SELECT * from `tariffs`");
if (!empty($rs)) {
foreach ($rs as $io => $eachtariff) {
$pi1++;
//бай дефолт скорость не режется - считаем 0
if (isset($allspeeds[$eachtariff['name']])) {
$speeddown = $allspeeds[$eachtariff['name']]['down'];
$speedup = $allspeeds[$eachtariff['name']]['up'];
} else {
$speeddown = 0;
$speedup = 0;
}
//выдираем тип подсчета трафика
if ($eachtariff['TraffType'] == 'up+down') {
$acctype = 2;
