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;
}
