if ($letter['docs']) { $table_post_our = true; $t = preg_split('/-/', $key); if ($t[1] == 't') { $company = letters::getCompany($t[0]); if ($company['frm_type']) { $user_name = $company['frm_type'] . ' "' . $company['name'] . '"'; } else { $user_name = $company['name']; } $address = "{$company['index']}, {$company['country_title']}, {$company['city_title']}, {$company['address']}"; $phone = ''; $fio = $company['fio']; array_push($envelopes, array('user' => $user_name, 'address' => $address)); } else { $recipient = letters::getUserReqvs($t[0]); $user = new users(); $user->GetUserByUID($t[0]); $address = ($recipient['form_type'] == 1 ? $recipient[1]['index'] : $recipient[2]['index']) . ', ' . ($recipient['form_type'] == 1 ? $recipient[1]['country'] : $recipient[2]['country']) . ', ' . ($recipient['form_type'] == 1 ? $recipient[1]['city'] : $recipient[2]['city']) . ', ' . ($recipient['form_type'] == 1 ? $recipient[1]['address'] : $recipient[2]['address']); $user_name = $recipient['form_type'] == 1 ? $recipient[1]['fio'] : $recipient[2]['full_name']; $phone = $recipient['form_type'] == 1 ? $recipient[1]['phone'] : $recipient[2]['phone']; $fio = $recipient['form_type'] == 1 ? $recipient[1]['fio'] : $recipient[2]['fio']; array_push($envelopes, array('user' => $recipient['form_type'] == 1 ? $recipient[1]['fio'] : $recipient[2]['full_name'], 'address' => $address)); } $worksheet->setRow($n, 35); $worksheet->write($n, 0, $n - 2, $fmtMB); $worksheet->write($n, 1, $user_name, $fmtMB); $worksheet->write($n, 2, $address, $fmtMB); $worksheet->write($n, 3, $phone, $fmtMB); $worksheet->write($n, 4, $fio, $fmtMB); $worksheet->write($n, 5, '', $fmtMB);
/** * Получить список корреспонденции для пользователя. * * @param int $user_id ID пользователя * * @return object xajaxResponse */ function showByUser($user_id, $is_company) { global $objLetters; $objResponse = new xajaxResponse(); if (hasPermissions('letters') && hasPermissions('adm')) { $filter['letters_filter_get_user_db_id'] = $user_id; $filter['letters_filter_get_user_section'] = $is_company == 't' ? '1' : '0'; $letters = $objLetters->getLetters(0, $filter); if ($letters) { $qstatuses = $objLetters->getStatuses(); foreach ($qstatuses as $qstatus) { $statuses[$qstatus['id']] = $qstatus['title']; } $statuses[0] = 'Добавить статус'; $oletters = array(); foreach ($letters as $letter) { $oletters[intval($letter['group_id'])][] = $letter; } $html = ''; ob_start(); require_once $_SERVER['DOCUMENT_ROOT'] . '/siteadmin/letters/tpl.list.header.php'; $nn = 0; foreach ($oletters as $oletter) { echo '<div class="b-layout__txt b-layout__txt_padbot_5 b-layout__txt_bold">' . ($oletter[0]['group_title'] ? $oletter[0]['group_title'] : '[Без группы]') . '</div>'; foreach ($oletter as $letter) { if ($letter['is_user_1_company'] == 't') { $company = letters::getCompany($letter['user_1']); if ($company['frm_type']) { $company['name'] = $company['frm_type'] . ' "' . $company['name'] . '"'; } $letter['company1_name'] = $company['name']; $letter['company1'] = $company; } else { $user1 = new users(); $user1->GetUserByUID($letter['user_1']); $letter['user1_uname'] = $user1->uname; $letter['user1_usurname'] = $user1->usurname; $letter['user1_login'] = $user1->login; $letter['user1_i'] = letters::getUserReqvs($letter['user_1']); } if ($letter['is_user_2_company'] == 't') { $company = letters::getCompany($letter['user_2']); if ($company['frm_type']) { $company['name'] = $company['frm_type'] . ' "' . $company['name'] . '"'; } $letter['company2_name'] = $company['name']; $letter['company2'] = $company; } else { $user2 = new users(); $user2->GetUserByUID($letter['user_2']); $letter['user2_uname'] = $user2->uname; $letter['user2_usurname'] = $user2->usurname; $letter['user2_login'] = $user2->login; $letter['user2_i'] = letters::getUserReqvs($letter['user_2']); } if ($letter['user_3']) { if ($letter['is_user_3_company'] == 't') { $company = letters::getCompany($letter['user_3']); if ($company['frm_type']) { $company['name'] = $company['frm_type'] . ' "' . $company['name'] . '"'; } $letter['company3_name'] = $company['name']; $letter['company3'] = $company; } else { $user3 = new users(); $user3->GetUserByUID($letter['user_3']); $letter['user3_uname'] = $user3->uname; $letter['user3_usurname'] = $user3->usurname; $letter['user3_login'] = $user3->login; $letter['user3_i'] = letters::getUserReqvs($letter['user_3']); } } echo "<div id='letters_div_item_{$letter['id']}' class='b-fon b-fon_marglr_-10 b-fon_padbot_10'>"; require $_SERVER['DOCUMENT_ROOT'] . '/siteadmin/letters/tpl.list.item.php'; echo '</div>'; } } $html = ob_get_contents(); ob_end_clean(); $objResponse->assign('letters_wrapper_view', 'innerHTML', ''); $objResponse->assign('letters_data', 'innerHTML', $html); $objResponse->script('$("letters_data").show();'); $objResponse->script('$("letters_notfound").hide();'); if ($is_company == 't') { $company = letters::getCompany($user_id); if ($company['frm_type']) { $company['name'] = $company['frm_type'] . ' "' . $company['name'] . '"'; } $user_title = $company['name']; $user_address = "{$company['index']}, {$company['country_title']}, {$company['city_title']}, {$company['address']}"; } else { $user = new users(); $user->GetUserByUID($user_id); $user_sbr = letters::getUserReqvs($user_id); $user_title = $user_sbr['form_type'] == 1 ? $user_sbr[1]['fio'] : $user_sbr[2]['full_name']; $user_address = ($user_sbr['form_type'] == 1 ? $user_sbr[1]['index'] : $user_sbr[2]['index']) . ', ' . ($user_sbr['form_type'] == 1 ? $user_sbr[1]['country'] : $user_sbr[2]['country']) . ', ' . ($user_sbr['form_type'] == 1 ? $user_sbr[1]['city'] : $user_sbr[2]['city']) . ', ' . ($user_sbr['form_type'] == 1 ? $user_sbr[1]['address'] : $user_sbr[2]['address']); } $objResponse->assign('letters_h_list_title1', 'innerHTML', $user_title); $objResponse->assign('letters_h_list_title2', 'innerHTML', $user_address); $objResponse->script('$("letters_h_list").setStyle("display", "none"); $("letters_h_list_group").setStyle("display", "block"); $("letters_h_list_title1").setStyle("display", "block"); $("letters_h_list_title2").setStyle("display", "block");'); } else { $objResponse->script('$("letters_data").hide();'); $objResponse->script('$("letters_notfound").show();'); } $objResponse->script('$("letters_wrapper_view").hide();'); $objResponse->script('$("letters_wrapper").show();'); $objResponse->script('letters.spinner.hide();'); } return $objResponse; }