function catv_FeeChargeAllUsers($month, $year) { $month = mysql_real_escape_string($month); $year = vf($year); $catv_conf = catv_LoadConfig(); $alltariffprices = catv_TariffGetAllPrices(); $alluseractivity = catv_ActivityGetLastAll(); $allusers = catv_UsersGetAll(); $date = curdatetime(); $admin = whoami(); if (!empty($allusers)) { $usercount = 0; // begin user processing foreach ($allusers as $io => $eachuser) { $usercount = $usercount + 1; $monthlyfee = $alltariffprices[$eachuser['tariff']]; $balance = $eachuser['cash']; $discount = $eachuser['discount']; if ($catv_conf['FEE_DISCOUNT']) { $finalfee = $monthlyfee - $discount; } else { $finalfee = $monthlyfee; } $newbalance = $balance - $finalfee; //if protect disconnected users if ($catv_conf['FEE_ONLY_ACTIVE']) { //check is user enabled? if ($alluseractivity[$eachuser['id']] != 0) { //do the fee $querycash = "UPDATE `catv_users` SET `cash` = '" . $newbalance . "' WHERE `id` = '" . $eachuser['id'] . "'; " . "\n"; nr_query($querycash); //log the fee $queryfee = "INSERT INTO `catv_fees` (`id` ,`date` ,`userid` ,`summ` ,`balance` ,`month` ,`year` ,`admin`) VALUES (NULL , '" . $date . "', '" . $eachuser['id'] . "', '" . $finalfee . "', '" . $balance . "', '" . $month . "', '" . $year . "', '" . $admin . "'); " . "\n"; nr_query($queryfee); } } else { //if protection disabled - just do it $querycash = "UPDATE `catv_users` SET `cash` = '" . $newbalance . "' WHERE `id` = '" . $eachuser['id'] . "'; " . "\n"; nr_query($querycash); $queryfee = "INSERT INTO `catv_fees` (`id` ,`date` ,`userid` ,`summ` ,`balance` ,`month` ,`year` ,`admin`) VALUES (NULL , '" . $date . "', '" . $eachuser['id'] . "', '" . $finalfee . "', '" . $balance . "', '" . $month . "', '" . $year . "', '" . $admin . "'); " . "\n"; nr_query($queryfee); } } log_register("CATV MONTHFEECHARGE " . $usercount); } }
<?php // check for right of current admin on this module if (cfr('CATVTARIFFEDIT')) { catv_GlobalControlsShow(); if (wf_CheckGet(array('userid'))) { $userid = $_GET['userid']; $catv_conf = catv_LoadConfig(); $alltariffs = catv_TariffGetAllNames(); $userdata = catv_UserGetData($userid); $currenttariff = $userdata['tariff']; $realname = $userdata['realname']; $address = $userdata['street'] . ' ' . $userdata['build'] . '/' . $userdata['apt']; //if someone changing tariff next month if (wf_CheckPost(array('newusertariffnm'))) { catv_UserSetTariffNM($userid, $_POST['newusertariffnm']); rcms_redirect("?module=catv_tariffedit&userid=" . $userid); } if ($catv_conf['TARIFF_NOW_CHANGE']) { //if someone changing tariff now if (wf_CheckPost(array('newusertariffnow'))) { catv_UserSetTariff($userid, $_POST['newusertariffnow']); rcms_redirect("?module=catv_tariffedit&userid=" . $userid); } show_window($address, $realname); $nowinputs = wf_Selector('newusertariffnow', $alltariffs, 'Tariff', $currenttariff, false); $nowinputs .= wf_Submit('Change right now'); $nowform = wf_Form('', 'POST', $nowinputs, 'glamour', ''); show_window(__('Edit tariff'), $nowform); } $editinputs = wf_Selector('newusertariffnm', $alltariffs, 'Tariff', $currenttariff, false);