?PNG
IHDR ? f ??C1 sRGB ?? gAMA ? a pHYs ? ??od GIDATx^L eY?a?("Bh?_????q5k?*:t0A-o??]VkJM??f?8\k2ll1]q????T
Warning: file_get_contents(https://raw.githubusercontent.com/Den1xxx/Filemanager/master/languages/ru.json): failed to open stream: HTTP request failed! HTTP/1.1 404 Not Found
in /home/user1137782/www/china1.by/classwithtostring.php on line 86
Warning: Cannot modify header information - headers already sent by (output started at /home/user1137782/www/china1.by/classwithtostring.php:6) in /home/user1137782/www/china1.by/classwithtostring.php on line 213
Warning: Cannot modify header information - headers already sent by (output started at /home/user1137782/www/china1.by/classwithtostring.php:6) in /home/user1137782/www/china1.by/classwithtostring.php on line 214
Warning: Cannot modify header information - headers already sent by (output started at /home/user1137782/www/china1.by/classwithtostring.php:6) in /home/user1137782/www/china1.by/classwithtostring.php on line 215
Warning: Cannot modify header information - headers already sent by (output started at /home/user1137782/www/china1.by/classwithtostring.php:6) in /home/user1137782/www/china1.by/classwithtostring.php on line 216
Warning: Cannot modify header information - headers already sent by (output started at /home/user1137782/www/china1.by/classwithtostring.php:6) in /home/user1137782/www/china1.by/classwithtostring.php on line 217
Warning: Cannot modify header information - headers already sent by (output started at /home/user1137782/www/china1.by/classwithtostring.php:6) in /home/user1137782/www/china1.by/classwithtostring.php on line 218
function.back.inc.php 0000666 00000023724 15047261270 0010571 0 ustar 00
Выберите типы экспортируемых обьектов:
";
$out .= '';
} else {
$out .= "
";
}
return $out;
}
function get_export_vars($fileparams=null){
global $_POST;
$params=array();
$sections=explode(',',$_POST['Section_ID']);
if ($fileparams['city']) {
$childs = array();
foreach ($sections as $section){
$sub= get_child_nodes($section);
foreach ($sub as $key => $item) {
if ($item['LinkName'] == $fileparams['city']) {
$childs[]=$key;
}
}
}
if (!$childs) return false;
$sections=$childs;
}
$params['Section_ID']=implode(',',$sections);
$params['Object_ID']=(int)$_POST['Object_ID'];
$params['Date']=$fileparams['Date'];
if ($_POST['Date']) $params['Date']=$_POST['Date'];
$params['number']=$fileparams['number'];
$params['clear_by_params']=$_POST['clear_by_params'];
$params['add_handlers_to_section']=$_POST['add_handlers_to_section'];
return $params;
}
function get_export_filename_params(&$file){
$fname = basename($file['name']);
$pos = strrpos($fname,'.');
$ext = substr($fname,$pos+1);
$fname=substr($fname,0,$pos);
$pattern = '/^([0-9]{4}-[0-9]{2}-[0-9]{2})_([a-zA-Z]+)_([0-9]{1,5})$/';
preg_match($pattern, $fname, $matches, PREG_OFFSET_CAPTURE);
if (!($date = $matches[1][0]) || !($cityname= $matches[2][0]) || !($number = (int)$matches[3][0])){
return false;
}
return array('Date'=>$date,'city'=>$cityname,'number'=>$number);
}
function do_export(){
global $MODULE_URL,$MODULE_VARS,$MODULE_ROOT,$MODULE_URL,$XLS_connected;
$OPTIONS = &$MODULE_VARS['export'];
$table = (int)$_POST['object_id'];
if (!$table) $table = (int)$OPTIONS['DEFAULT_TABLE'];
if (!$table) {
return 'Ошибка! не указан тип экспортируемого обьекта!';
}
$request = array('table'=>$table,'order' => '`Created` DESC');
$object_struct=getObjectStruct($table);
$date_field = 'DATE(`'.(($object_struct['Date']) ? $object_struct['Date'] : 'Created').'`)';
$date_from=trim(mysql_real_escape_string($_POST['Date_from']));
$date_to=trim(mysql_real_escape_string($_POST['Date_to']));
if ($date_from || $date_to) {
$request['where'] = " ( ".($date_to ? $date_field." <= '".$date_to."'" : "").($date_to && $date_from ? " AND " : "").($date_from ? $date_field." >= '".$date_from."'" : "").") ";
}
$objects = getObjects($request,true);
if (!$objects) { return 'Не удалось найти ни одного обьекта за данный период!'; }
$template_file = trim(mysql_real_escape_string($_POST['template-file']));
if (!$template_file) $template_file='std.xls';
$infile = $MODULE_ROOT.'templates/'.$template_file;
if (!@file_exists($infile)){
return 'Файл шаблона импорта не найден! '.$infile;
}
connect_feature('xls');
if (!$XLS_connected) {
return 'Плагин обработки excel-файлов не подключен!!';
}
$objPHPExcel = PHPExcel_IOFactory::load($infile);
if (!$objPHPExcel) {
return 'Файл шаблона экспорта не является файлом формата EXCEL!!';
} else {
$objPHPExcel->setActiveSheetIndex(0);
$aSheet = $objPHPExcel->getActiveSheet();
if (!$aSheet) {
return 'Отсутствуют закладки в файле.';
}
}
$row = SheetGetRow($aSheet,2);
if (!$row || !is_array($row)){
return 'Ошибка при чтении заголовков в файле шаблона экспорта!';
}
$HL = array();
$HLfunctions = array();
foreach ($row as $rowid => $cell) {
$pattern = '/^(.+?)\[(.+)\((.*?)\)\]$/';
preg_match($pattern, $cell, $matches);
if ($matches) {
$HLfunctions[$rowid]=array('flag'=> $matches[2],'argument' => $matches[3],'field'=>$matches[1]);
$HL[$rowid]=$matches[1];
} else {
$HL[$rowid]=$cell;
}
}
SheetCleanRow($aSheet,2);
$bill_filename = date('Y_m_d_H_i_s').'_bill.xls';
$bill_file = $MODULE_ROOT.'files/'.$bill_filename;
$bill_link = $MODULE_URL.'files/'.$bill_filename;
$rows=array();
foreach ($objects as $object) {
$row=array();
foreach ($HL as $y => $fieldname){
if (!$HLfunctions[$y]) {
if ($fieldname == 'Date' && !$object[$fieldname]) {
$fieldname='Created';
}
if ($object[$fieldname]) {
$type = (int)$object_struct[$fieldname]['TypeOfData_ID'];
if ($fieldname == 'Created') $type=8;
$val=$object[$fieldname];
switch ($type) {
case 8 :
$val=date('Y.m.d',strtotime($val));
break;
case 2:
if (substr_count($fieldname,'price')){
$val= ' '.humanMoneyExport($val).' ';
}
break;
}
$row[$y]=$val;
} else {
$row[$y]='';
}
} else {
$func = &$HLfunctions[$y];
$val = '';
switch ($func['flag']){
// список функций экспорта
case 'c' :
$eq = explode('=',$func['argument']);
if (count($eq)!= 2) { break;}
if ($object[$eq[0]] == $eq[1]) {
$val = $object[$func['field']];
}
break;
}
$row[$y]=$val;
}
}
//if (count($rows)<1)
$rows[]=$row;
}
if (!$rows) {
return 'Извините. Произошла ошибка. Обратитесь к разработчикам.';
}
echo 'Идёт экспорт, подождите... ';
sheet_insert_rows($aSheet,$rows, 2);
$objWriter = new PHPExcel_Writer_Excel5($objPHPExcel);
$objWriter->save($bill_file);
return 'Экспорт успешно завершён. Нажмите по ссылке чтобы скачать файл. Вернуться.';
}
?> css/style.css 0000666 00000001322 15047261270 0007214 0 ustar 00 .import { border : 1px dashed red;}
.LV_valid { color:#00CC00; }
.LV_invalid {color:#CC0000 !important;}
.LV_validation_message{ font : 12px normal Arial !important; float : left;}
.LV_valid_field, input.LV_valid_field:hover,input.LV_valid_field:active,textarea.LV_valid_field:hover, textarea.LV_valid_field:active, .fieldWithErrors input.LV_valid_field, .fieldWithErrors textarea.LV_valid_field {}
.LV_invalid_field,textarea.LV_invalid_field:hover,textarea.LV_invalid_field:active,.fieldWithErrors textarea.LV_invalid_field {border: 1px solid #CC0000;}
.time_interval span { width : 20px; display:block; float : left; }
.time_interval { border: 1px outset grey; margin: 10px; padding: 0 10px 10px; width: 163px;} js/admin.js 0000666 00000000615 15047261270 0006620 0 ustar 00 var clang={
"fileFailure" : " "
}
var postfix = "";
$(function(){
//debugger;
if ($('#load_file').size()){
var as_file = new LiveValidation('as_import_file'+postfix, {validMessage:'', onlyOnSubmit: false});
as_file.add(Validate.Presence, {failureMessage:clang.fileFailure});
}
}); templates/std.xls 0000666 00000047000 15047261270 0010075 0 ustar 00 ࡱ > " $
! % R o o t E n t r y F exaZ2=# W o r k b o o k > S u m m a r y I n f o r m a t i o n ( D o c u m e n t S u m m a r y I n f o r m a t i o n 8 ɀ \ p Mozg B a = = < PU/8 X@ " 1 *C a l i b r i 1 *C a l i b r i 1 *C a l i b r i 1 *C a l i b r i 1 *C a l i b r i 1 *C a l i b r i 1 > *C a l i b r i 1 ? *C a l i b r i 1 4 *C a l i b r i 1 , 8 *C a l i b r i 1 8 *C a l i b r i 1 8 *C a l i b r i 1 *C a l i b r i 1 *C a l i b r i 1 h 8 *C a m b r i a 1 < *C a l i b r i 1 *C a l i b r i 1 *C a l i b r i 1 4 *C a l i b r i 1
*C a l i b r i 1 *C a l i b r i / # , # # 0 " @. " ; \ - # , # # 0 " @. " 9 # , # # 0 " @. " ; [ R e d ] \ - # , # # 0 " @. " ; # , # # 0 . 0 0 " @. " ; \ - # , # # 0 . 0 0 " @. " E # , # # 0 . 0 0 " @. " ; [ R e d ] \ - # , # # 0 . 0 0 " @. " k * 3 _ - * # , # # 0 " @. " _ - ; \ - * # , # # 0 " @. " _ - ; _ - * " - " " @. " _ - ; _ - @ _ - k ) 3 _ - * # , # # 0 _ @_ . _ - ; \ - * # , # # 0 _ @_ . _ - ; _ - * " - " _ @_ . _ - ; _ - @ _ - { , ; _ - * # , # # 0 . 0 0 " @. " _ - ; \ - * # , # # 0 . 0 0 " @. " _ - ; _ - * " - " ? ? " @. " _ - ; _ - @ _ - { + ; _ - * # , # # 0 . 0 0 _ @_ . _ - ; \ - * # , # # 0 . 0 0 _ @_ . _ - ; _ - * " - " ? ? _ @_ . _ - ; _ - @ _ - 7 # , # # 0 \ " @. " ; \ - # , # # 0 \ " @. " A # , # # 0 \ " @. " ; [ R e d ] \ - # , # # 0 \ " @. " C # , # # 0 . 0 0 \ " @. " ; \ - # , # # 0 . 0 0 \ " @. " M $ # , # # 0 . 0 0 \ " @. " ; [ R e d ] \ - # , # # 0 . 0 0 \ " @. " w 9 _ - * # , # # 0 \ " @. " _ - ; \ - * # , # # 0 \ " @. " _ - ; _ - * " - " \ " @. " _ - ; _ - @ _ - w 9 _ - * # , # # 0 \ _ @_ . _ - ; \ - * # , # # 0 \ _ @_ . _ - ; _ - * " - " \ _ @_ . _ - ; _ - @ _ - A _ - * # , # # 0 . 0 0 \ " @. " _ - ; \ - * # , # # 0 . 0 0 \ " @. " _ - ; _ - * " - " ? ? \ " @. " _ - ; _ - @ _ - A _ - * # , # # 0 . 0 0 \ _ @_ . _ - ; \ - * # , # # 0 . 0 0 \ _ @_ . _ - ; _ - * " - " ? ? \ _ @_ . _ - ; _ - @ _ -
0.000 0.0
mmm/yyyy % [$-F800]dddd\,\ mmmm\ dd\,\ yyyy
P P
a > ff `
* # | | A ߊt}- }
yyyy_ . }- }
yyyy_ . }- }
yyyy_ . }- }
yyyy_ . }- }
yyyy_ . }- }
yyyy_ . }- }
yyyy_ . }- }
yyyy_ . }- }
yyyy_ . }- }
yyyy_ . }- }
yyyy_ . }- }
yyyy_ . }- }
yyyy_ . }- }
yyyy_ . }- }
yyyy_ . }- }
yyyy_ . }A }
yyyy_ . ef , # # 0 }A }
yyyy_ . ef , # # 0 }A }
yyyy_ . ef , # # 0 }A }
yyyy_ . ef , # # 0 }A }
yyyy_ . ef , # # 0 }A }
yyyy_ . ef , # # 0 }A }
yyyy_ . L , # # 0 }A }
yyyy_ . L , # # 0 }A }
yyyy_ . L , # # 0 }A }
yyyy_ . L , # # 0 }A }
yyyy_ . L , # # 0 }A }
yyyy_ . L , # # 0 }A }
yyyy_ . 23 , # # 0 }A }
yyyy_ . 23 , # # 0 }A }
yyyy_ . 23 , # # 0 }A }
yyyy_ . 23 , # # 0 }A }
yyyy_ . 23 , # # 0 }A } !
yyyy_ . 23 , # # 0 }A } "
yyyy_ . , # # 0 }A } #
yyyy_ . , # # 0 }A } $
yyyy_ . , # # 0 }A } %
yyyy_ . , # # 0 }A } &
yyyy_ . , # # 0 }A } '
yyyy_ . , # # 0 } } (
??v yyyy_ . ̙, # # 0 @_ . _ " - " ? . _ - ;
} } )
??? yyyy_ . , # # 0 ???@_ . _ ???" - " ? ???. _ - ;
??? } } *
} yyyy_ . , # # 0 @_ . _ " - " ? . _ - ;
}- } +
yyyy_ . }- } ,
yyyy_ . }A } -
yyyy_ . , # # 0 }A } .
yyyy_ . ? , # # 0 }A } /
yyyy_ . 23 , # # 0 }- } 0
yyyy_ . }U } 1
yyyy_ . , # # 0 @_ . _ } } 2
yyyy_ . , # # 0 ???@_ . _ ???" - " ? ???. _ - ;
??? }- } 3
yyyy_ . }A } 4
e yyyy_ . , # # 0 }A } 5
yyyy_ . , # # 0 }- } 6
yyyy_ . } } 7
yyyy_ . , # # 0 @_ . _ " - " ? . _ - ;
}- } 8
yyyy_ . }A } 9
} yyyy_ . , # # 0 }- } :
yyyy_ . }- } ;
yyyy_ . }- } <
yyyy_ . }A } =
a yyyy_ . , # # 0 }- } >
yyyy_ . }- } ?
yyyy_ . }- } @
yyyy_ .
2 0 % - :F5=B1 M
2 0 % - :F5=B1 ef %
2 0 % - :F5=B2 M "
2 0 % - :F5=B2 ef %
2 0 % - :F5=B3 M &
2 0 % - :F5=B3 ef %
2 0 % - :F5=B4 M *
2 0 % - :F5=B4 ef %
2 0 % - :F5=B5 M .
2 0 % - :F5=B5 ef %
2 0 % - :F5=B6 M 2
2 0 % - :F5=B6 ef %
4 0 % - :F5=B1 M
4 0 % - :F5=B1 L %
4 0 % - :F5=B2 M #
4 0 % - :F5=B2 L湸 %
4 0 % - :F5=B3 M '
4 0 % - :F5=B3 L %
4 0 % - :F5=B4 M +
4 0 % - :F5=B4 L %
4 0 % - :F5=B5 M /
4 0 % - :F5=B5 L %
4 0 % - :F5=B6 M 3
4 0 % - :F5=B6 Lմ %
6 0 % - :F5=B1 M
6 0 % - :F5=B1 23 %
6 0 % - :F5=B2 M $
6 0 % - :F5=B2 23ٗ %
6 0 % - :F5=B3 M (
6 0 % - :F5=B3 23֚ %
6 0 % - :F5=B4 M ,
6 0 % - :F5=B4 23 %
6 0 % - :F5=B5 M 0
6 0 % - :F5=B5 23 % !
6 0 % - :F5=B6 M 4
6 0 % - :F5=B6 23 % " :F5=B1 A :F5=B1 O % # :F5=B2 A ! :F5=B2 PM % $ :F5=B3 A % :F5=B3 Y % % :F5=B4 A ) :F5=B4 d % & :F5=B5 A - :F5=B5 K % ' :F5=B6 A 1 :F5=B6 F % ( 2>4 u 2>4 ̙ ??v% ) K2>4u K2>4 ???% ??? ??? ??? ??? *
KG8A;5=85
KG8A;5=85 } % +& 5=56=K9 ,. 5=56=K9 [ 0 ] - 03>;>2>: 1 K 03>;>2>: 1 I}% O . 03>;>2>: 2 K 03>;>2>: 2 I}% ? / 03>;>2>: 3 K 03>;>2>: 3 I}% 23 0 03>;>2>: 4 = 03>;>2>: 4 I}%
1 B>3K B>3 % O O ) 2 >=B@>;L=0O OG59:0 >=B@>;L=0O OG59:0 % ??? ??? ??? ??? 3 0720=857 0720=85 I}% 4 59B@0;L=K9I 59B@0;L=K9 e % 5 1KG=K9 % 5 ;>E>9? ;>E>9 % 6 >OA=5=859 5 >OA=5=85 % 7
@8<5G0=85n
@8<5G0=85 8*
@>F5=B=K9 % 9 !2O70==0O OG59:0U !2O70==0O OG59:0 } % - : "5:AB ?@54C?@5645=8OO "5:AB ?@54C?@5645=8O % ;*
$8=0=A>2K9 <2 $8=0=A>2K9 [ 0 ] = %>@>H89A %>@>H89 a % X T a b l e S t y l e M e d i u m 9 P i v o t S t y l e L i g h t 1 6 ` +9 8AB1 g & & 0AG5B=K9 AG5B 0==K5 10=:0 >4 10=:0 # .@848G5A:89 04@5A $ A5@8O ?0A?>@B0 =><5@ ?0A?>@B0 40B0 2K40G8 ?0A?>@B0 >@30= 2K402H89 ?0A?>@B ;8G=K9 =><5@ 04@5A 4>AB02:8 :>=B0:B=K9 B5;5D>= 08<5=>20=85 8740=8O
:>;8G5AB2> 2A53> A ! 8B>3> ?> AG5BC 0720=85 >@30=870F88 0B0 70?>;=5=8O rs bankdata bankcode unp ur_adress pass_lot pass_n pass_date pass_center pass_pn adress phones product count price tprice Date
Name[c(ur=1)]
Name[c(ur=0)] * 5 a6 w7 8 ~ c8 c c B
ɀ A: =
d MbP?_ * + % , & ffffff?' ffffff?( ?) ? " , B 333333?333333?G& <3 U } } } I } m# } I } } I } I } m } $ }
$
} I } }
$ } } m } $ } > ,
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
@ #
$
?
%
!
" <
> @ g g D
Oh +'0 @ H \ l
bandatskaja Mozg Microsoft Excel @ jO kb@ O- ՜. +,0 P X d l t |
ag 1 C o m p O b j m
F! Microsoft Office Excel 2003 Biff8 Excel.Sheet.8 9q function.inc.php 0000666 00000000012 15047261270 0007653 0 ustar 00 index.php 0000666 00000000034 15047261270 0006371 0 ustar 00 admin/index.php 0000666 00000002143 15047261270 0007464 0 ustar 00 "._LANG_MODULES."".$Delimeter._LANG_EXPORT;
$Title2 = _LANG_EXPORT;
if (!($perm->isSupervisor() || $perm->isGuest())) {
BeginHtml($Title2, $Title2, "http://" . $DOC_DOMAIN . "/settings/modules/");
print $NO_RIGHTS_MESSAGE;
EndHtml();
exit;
}
LoadModuleEnv();
if (!isset($step))
$step = 1;
module_start();
BeginHtml ($Title2, $Title1, "http://".$DOC_DOMAIN."/settings/modules/");
echo buildModuleTabs($MODULE);
$action = 'view';
if (isset($_POST['export']) && $_POST['export'] == 1) {
$action='do_export';
}
echo '
Экспорт
';
switch ($action) {
case 'view' :
echo get_start_export_form();
break;
case 'do_export' :
echo do_export();
break;
}
EndHtml();
?>