function catvbs_ShowHash($hash) { $hash = vf($hash); $allrealnames = catv_GetAllRealnames(); $alladdress = catv_GetFullAddressList(); $montharr = months_array(); $checkarr = catvbs_SearchCheckArr($alladdress, $allrealnames); $alter_conf = rcms_parse_ini_file(CONFIG_PATH . 'catv.ini'); $query = "SELECT * from `catv_bankstaparsed` WHERE `hash`='" . $hash . "' ORDER BY `id` DESC"; $alldata = simple_queryall($query); if (!empty($alldata)) { $tablecells = wf_TableCell(__('ID')); $tablecells .= wf_TableCell(__('Real Name')); $tablecells .= wf_TableCell(__('Address')); $tablecells .= wf_TableCell(__('Cash')); $tablecells .= wf_TableCell(__('User poroposal')); $tablecells .= wf_TableCell(__('Month')); $tablecells .= wf_TableCell(__('Processed')); $tablecells .= wf_TableCell(__('Actions')); $tablerows = wf_TableRow($tablecells, 'row1'); foreach ($alldata as $io => $eachrow) { $tablecells = wf_TableCell($eachrow['id']); $tablecells .= wf_TableCell(bs_NameEditForm($eachrow['id'], $eachrow['realname'])); $tablecells .= wf_TableCell(bs_AddressEditForm($eachrow['id'], $eachrow['address'])); $tablecells .= wf_TableCell($eachrow['summ']); //proposal subroutine if (empty($eachrow['login'])) { $proposed_login = catvbs_SearchLoginByAddresspart($eachrow['address'], $eachrow['realname'], $checkarr); //if no one found if (sizeof($proposed_login) == 0) { $proposal_form = catvbs_LoginProposalForm($eachrow['id'], ''); } //if only one user found if (sizeof($proposed_login) == 1) { $proposal_form = bs_LoginProposalForm($eachrow['id'], $proposed_login[0]); //заполним со старта что-ли simple_update_field('catv_bankstaparsed', 'login', $proposed_login[0], "WHERE `id`='" . $eachrow['id'] . "'"); } //if many users found if (sizeof($proposed_login) > 1) { $proposal_form = __('Multiple users found'); } } else { $proposal_form = catvbs_LoginProposalForm($eachrow['id'], $eachrow['login']); } $tablecells .= wf_TableCell($proposal_form); $procflag = web_bool_led($eachrow['state']); if (!$eachrow['state']) { $actlink = wf_JSAlert("?module=catv_banksta&lockrow=" . $eachrow['id'] . "&showhash=" . $eachrow['hash'], web_key_icon('Lock'), __('Are you serious')); } else { $actlink = ''; } //month detection here $month_detected = catvbs_MonthDetect($eachrow['address']); if ($month_detected) { $monthname = web_bool_led($month_detected) . ' ' . rcms_date_localise($montharr[$month_detected]); } else { $monthname = web_bool_led($month_detected); } $tablecells .= wf_TableCell($monthname); $tablecells .= wf_TableCell($procflag); $tablecells .= wf_TableCell($actlink); $tablerows .= wf_TableRow($tablecells, 'row3'); } $result = wf_TableBody($tablerows, '100%', '0', 'sortable'); } else { $result = __('Strange exeption catched'); } show_window('', wf_Link("?module=catv_banksta", 'Back', true, 'ubButton')); show_window(__('Bank statement processing'), $result); }
function bs_ShowHash($hash) { $hash = vf($hash); $allrealnames = zb_UserGetAllRealnames(); $alladdress = zb_AddressGetFulladdresslist(); $checkarr = bs_SearchCheckArr($alladdress, $allrealnames); $alter_conf = rcms_parse_ini_file(CONFIG_PATH . 'alter.ini'); $query = "SELECT * from `bankstaparsed` WHERE `hash`='" . $hash . "' ORDER BY `id` DESC"; $alldata = simple_queryall($query); // проверяем врублены ли корпоративные пользователи if ($alter_conf['USER_LINKING_ENABLED']) { $alllinkedusers = cu_GetAllLinkedUsers(); $allparentusers = cu_GetAllParentUsers(); } if (!empty($alldata)) { $tablecells = wf_TableCell(__('ID')); $tablecells .= wf_TableCell(__('Real Name')); $tablecells .= wf_TableCell(__('Address')); $tablecells .= wf_TableCell(__('Cash')); $tablecells .= wf_TableCell(__('Login poroposal')); $tablecells .= wf_TableCell(__('Processed')); $tablecells .= wf_TableCell(__('Actions')); $tablerows = wf_TableRow($tablecells, 'row1'); foreach ($alldata as $io => $eachrow) { $tablecells = wf_TableCell($eachrow['id']); $tablecells .= wf_TableCell(bs_NameEditForm($eachrow['id'], $eachrow['realname'])); $tablecells .= wf_TableCell(bs_AddressEditForm($eachrow['id'], $eachrow['address'])); $tablecells .= wf_TableCell($eachrow['summ']); //proposal subroutine if (empty($eachrow['login'])) { $proposed_login = bs_SearchLoginByAddresspart($eachrow['address'], $eachrow['realname'], $checkarr); //if no one found if (sizeof($proposed_login) == 0) { $proposal_form = bs_LoginProposalForm($eachrow['id'], ''); } //if only one user found if (sizeof($proposed_login) == 1) { $proposal_form = bs_LoginProposalForm($eachrow['id'], $proposed_login[0]); //заполним со старта что-ли simple_update_field('bankstaparsed', 'login', $proposed_login[0], "WHERE `id`='" . $eachrow['id'] . "'"); } //if many users found if (sizeof($proposed_login) > 1) { //считаем что это корпоративный пользователь и достаем для него родительского if ($alter_conf['USER_LINKING_ENABLED']) { foreach ($proposed_login as $eachcorp) { if (bs_cu_IsParent($eachcorp, $allparentusers)) { $proposal_form = web_corporate_icon() . ' ' . $eachcorp; //заполним родительского пользователя simple_update_field('bankstaparsed', 'login', $eachcorp, "WHERE `id`='" . $eachrow['id'] . "'"); } } } else { // если корпоративщина не включена - вываливаем екзепшн $proposal_form = __('Multiple users found'); } } } else { $proposal_form = bs_LoginProposalForm($eachrow['id'], $eachrow['login']); } $tablecells .= wf_TableCell($proposal_form); $procflag = web_bool_led($eachrow['state']); if (!$eachrow['state']) { $actlink = wf_JSAlert("?module=bankstatements&lockrow=" . $eachrow['id'] . "&showhash=" . $eachrow['hash'], web_key_icon('Lock'), __('Are you serious')); } else { $actlink = ''; } $tablecells .= wf_TableCell($procflag); $tablecells .= wf_TableCell($actlink); $tablerows .= wf_TableRow($tablecells, 'row3'); } $result = wf_TableBody($tablerows, '100%', '0', 'sortable'); } else { $result = __('Strange exeption catched'); } show_window('', wf_Link("?module=bankstatements", 'Back', true, 'ubButton')); show_window(__('Bank statement processing'), $result); }