/**
* получить запись по умолчанию для списка пользователей и компаний.
* */
private function getUserOrCompanyRecord()
{
require_once $_SERVER['DOCUMENT_ROOT'] . '/classes/letters.php';
if ($_POST['type'] == 'user') {
$user = users::GetUserShortInfoFinInfo((int) $_POST['uid']);
$user['record']['isContacts'] = 1;
//т. к. компании должны идти вторыми по дизайну
return json_encode($user);
} else {
//Здесь надо получить запись о компании use (int)$_POST["uid"]
$company = letters::getCompany((int) $_POST['uid']);
$i['uid'] = $company['id'];
$i['uname'] = iconv('WINDOWS-1251', 'UTF-8//IGNORE', $company['name']);
$i['address'] = iconv('WINDOWS-1251', 'UTF-8//IGNORE', "{$company['country_title']}, {$company['city_title']}, {$company['index']}, {$company['address']}");
$i['usurname'] = '';
$i['login'] = '';
$i['photo'] = '';
$i['isContacts'] = 0;
$i['isCompany'] = 1;
$data = array('record' => $i, 'found' => 1, 'dav' => WDCPREFIX);
return json_encode($data);
}
}
$worksheet->write(2, 7, 'Дата получения', $fmtTB);
$worksheet->write(2, 8, 'Подпись получателя', $fmtTB);
$worksheet->write(2, 9, 'ФИО получателя', $fmtTB);
$worksheet->setRow(2, 35);
$worksheet->setColumn(0, 0, 6);
$worksheet->setColumn(1, 1, 25);
$worksheet->setColumn(2, 2, 30);
$worksheet->setColumn(3, 9, 20);
//$worksheet->setColumn(3,9,45);
$n = 3;
foreach ($data_post_our as $key => $letter) {
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'];
/**
* Получить список корреспонденции для пользователя.
*
* @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;
}
$old_value = $huser->uname . ' ' . $huser->usurname . ' [' . $huser->login . ']';
} else {
$company = letters::getCompany(intval($v1));
$old_value = $company['name'];
}
} else {
$old_value = "Нет";
}
if ($ihistory['val_new']) {
list($v1, $v2) = preg_split("/-/", $ihistory['val_new']);
if (intval($v2) == 0) {
$huser = new users();
$huser->GetUserByUID(intval($v1));
$new_value = $huser->uname . ' ' . $huser->usurname . ' [' . $huser->login . ']';
} else {
$company = letters::getCompany(intval($v1));
$new_value = $company['name'];
}
} else {
$new_value = "Нет";
}
break;
default:
$old_value = reformat(htmlspecialchars($ihistory['val_old']), 20);
$new_value = reformat(htmlspecialchars($ihistory['val_new']), 20);
break;
}
?>
<?php
echo $old_value;
?>
default:
$msgstr = '';
break;
}
$inner_page = "inner_company.php";
break;
case 'add':
$inner_page = "inner_company_frm.php";
break;
case 'insert':
letters::addCompany($_POST);
header('Location: /siteadmin/letters/?mode=company&msg=aok');
exit;
break;
case 'edit':
$company = letters::getCompany($_GET['id']);
if (!$company) {
header('Location: /siteadmin/letters/?mode=company');
exit;
}
$inner_page = "inner_company_frm.php";
break;
case 'update':
letters::updateCompany($_POST);
header('Location: /siteadmin/letters/?mode=company&msg=eok');
exit;
break;
default:
$inner_page = "inner_index.php";
break;
}
/**
* получить запись по умолчанию для списка пользователей и компаний
* */
private function getUserOrCompanyRecord()
{
require_once $_SERVER["DOCUMENT_ROOT"] . "/classes/letters.php";
if ($_POST["type"] == "user") {
$user = users::GetUserShortInfoFinInfo((int) $_POST["uid"]);
$user["record"]["isContacts"] = 1;
//т. к. компании должны идти вторыми по дизайну
return json_encode($user);
} else {
//Здесь надо получить запись о компании use (int)$_POST["uid"]
$company = letters::getCompany((int) $_POST["uid"]);
$i["uid"] = $company['id'];
$i["uname"] = iconv("WINDOWS-1251", "UTF-8//IGNORE", $company['name']);
$i["address"] = iconv("WINDOWS-1251", "UTF-8//IGNORE", "{$company['country_title']}, {$company['city_title']}, {$company['index']}, {$company['address']}");
$i["usurname"] = "";
$i["login"] = "";
$i['photo'] = "";
$i["isContacts"] = 0;
$i["isCompany"] = 1;
$data = array("record" => $i, "found" => 1, "dav" => WDCPREFIX);
return json_encode($data);
}
}
