.-.-.-.-.-

IP : 216.73.216.207 Hostname : xhost1.intravision.ru Kernel : Linux xhost1.intravision.ru 3.16.0-7-amd64 #1 SMP Debian 3.16.59-1 (2018-10-03) x86_64 Disable Function : pcntl_alarm,pcntl_fork,pcntl_waitpid,pcntl_wait,pcntl_wifexited,pcntl_wifstopped,pcntl_wifsignaled,pcntl_wexitstatus,pcntl_wtermsig,pcntl_wstopsig,pcntl_signal,pcntl_signal_dispatch,pcntl_get_last_error,pcntl_strerror,pcntl_sigprocmask,pcntl_sigwaitinfo,pcntl_sigtimedwait,pcntl_exec,pcntl_getpriority,pcntl_setpriority, OS : Linux PATH: / var/ ./ ./ backup/ ./ ./ external_www/ new02.medcomp.ru/ downloadorder/ saving_akts.php/ /

<?require($_SERVER["DOCUMENT_ROOT"]."/bitrix/modules/main/include/prolog_before.php");
CModule::IncludeModule("iblock");
CModule::IncludeModule("catalog");
CModule::IncludeModule("sale");
require_once 'tcpdf/tcpdf.php';

function SaveFile($file_path, $file_name) {
    $arFile = explode("_", $file_name);
    $user_id = $arFile[0];
    
    $dbUser = CUser::GetByID($user_id);
    if($arUser = $dbUser->GetNext()) {
        $user_text = "Документ создал пользователь : ";
        $user_text .= "<br>ФИО ".$arUser["NAME"]." ".$arUser["LAST_NAME"]." ".$arUser["SECOND_NAME"];
        $user_text .= "<br>email ".$arUser["EMAIL"];
        $user_text .= "<br>Город ".$arUser["PERSONAL_CITY"];
        $user_text .= "<br>Компания ".$arUser["UF_COMPANY"];
        $user_text .= "<br>Сайт ".$arUser["WORK_WWW"];
        $user_text .= "<br>Телефон ".$arUser["UF_PHONE"];
        $user_text .= "<br>ИНН ".$arUser["UF_INN"];
    }
    else
        $user_text = "Пользователь, создавший документ не определен.";
        
    $el = new CIBlockElement;
    $arElement = Array(
        "IBLOCK_ID" => 29,
        "PROPERTY_VALUES" => array("USER" => $user_id, "FILE" => CFile::MakeFileArray($file_path)),
        "NAME" => $file_name
    );
}

function SavePDF($data, $toBrowser = false) {
	global $USER;
	global $DB;
	
	$q = CUser::GetByID($USER->GetID());
	$aUser = $q->GetNext();
	
    $pdf = new TCPDF('P', 'mm', 'A4', true, 'UTF-8');
    $pdf->AddPage(); 
    $pdf->SetDrawColor(0, 0, 0);
    $pdf->SetTextColor(0, 0, 0);
    
    $pdf->SetFont('arialmy', '', 10, true);
	
	$strToHTML = "";
	
	$strToHTML .= '<table border="0" cellpadding="0" cellspacing="0" width="100%">';
    $strToHTML .= '
			<tr>
				<td colspan="15" align="center">&nbsp;</td>
			</tr>
			<tr>
				<td colspan="15" align="center"><b>Акт сверки</b></td>
			</tr>
			<tr>
				<td colspan="15" align="center">взаимных расчетов за период: 2016 г.</td>
			</tr>
			<tr>
				<td colspan="15" align="center">между ООО "МедКомплекс "А.В.К."</td>
			</tr>
			<tr>
				<td colspan="15" align="center">и ООО "Альянс СПК"</td>
			</tr>
			<tr>
				<td colspan="15" align="center">&nbsp;</td>
			</tr>
			<tr>
				<td colspan="15" align="left">Мы, нижеподписавшиеся, ________________ ООО "МедКомплекс "А.В.К." _______________________, с одной стороны, и ________________ ООО "Альянс СПК" _______________________, с другой стороны, составили настоящий акт сверки в том, что состояние взаимных расчетов по данным учета следующее:</td>
			</tr>
			<tr>
				<td colspan="15" align="center">&nbsp;</td>
			</tr>
			<tr>
				<td colspan="7" align="left" style="border: 1px solid black;">По данным ООО "МедКомплекс "А.В.К.", руб</td>
				<td colspan="7" align="left" style="border: 1px solid black;">По данным ООО "Альянс СПК", руб</td>
			</tr>
			<tr>
				<td align="center" style="border: 1px solid black;">Дата</td>
				<td colspan="4" align="center" style="border: 1px solid black;">Документ</td>
				<td align="center" style="border: 1px solid black;">Дебет</td>
				<td align="center" style="border: 1px solid black;">Кредит</td>
				
				<td align="center" style="border: 1px solid black;">Дата</td>
				<td colspan="4" align="center" style="border: 1px solid black;">Документ</td>
				<td align="center" style="border: 1px solid black;">Дебет</td>
				<td align="center" style="border: 1px solid black;">Кредит</td>
			</tr>
			<tr>
				<td colspan="5" align="left" style="border: 1px solid black;">Сальдо начальное</td>
				<td align="center" style="border: 1px solid black;">&nbsp;</td>
				<td align="center" style="border: 1px solid black;">&nbsp;</td>
				
				<td colspan="5" align="left" style="border: 1px solid black;">Сальдо начальное</td>
				<td align="center" style="border: 1px solid black;">&nbsp;</td>
				<td align="center" style="border: 1px solid black;">&nbsp;</td>
			</tr>
			';
	
	$arFilter = Array(
		"USER_ID"=>$USER->GetID()
	);
	
	if(strlen($data['DATE_FROM'])>0){
		if (substr_count($data['DATE_FROM'], " 00:00:00")) {
		}else{
			$data['DATE_FROM'] .= ' 00:00:00';
		}
		$arFilter['>=DATE_INSERT'] = date($DB->DateFormatToPHP(CSite::GetDateFormat("FULL")), strtotime($data['DATE_FROM']));
	}
	if(strlen($data['DATE_TO'])>0){
		if (substr_count($data['DATE_TO'], " 23:59:59")) {
		}else{
			$data['DATE_TO'] .= ' 23:59:59';
		}
		$arFilter['<=DATE_INSERT'] = date($DB->DateFormatToPHP(CSite::GetDateFormat("FULL")), strtotime($data['DATE_TO']));
	}
	
	$q_order = CSaleOrder::GetList(Array("ID"=>"DESC"), $arFilter);
	$arResult = array();
	while ($a_order = $q_order->GetNext()){
		$db_vals = CSaleOrderPropsValue::GetList(
		array("SORT" => "ASC"),
			array(
				"ORDER_ID" => $a_order['ID'],
				"ORDER_PROPS_ID" => 19
			)
		);
		$arVals = $db_vals->Fetch();
		$arTMP = explode('|',$arVals['VALUE']);
		foreach($arTMP as $str){
			$arCharge = getChargeArray($str);
			$arResult[] = $arCharge;
		}
		
		$db_vals = CSaleOrderPropsValue::GetList(
		array("SORT" => "ASC"),
			array(
				"ORDER_ID" => $a_order['ID'],
				"ORDER_PROPS_ID" => 21
			)
		);
		$arVals = $db_vals->Fetch();
		$arTMP = explode('|',$arVals['VALUE']);
		foreach($arTMP as $str){
			$arPayment = getPaymentArray($str);
			$arResult[] = $arPayment;
		}
	}
	
	foreach($arResult as $key=>$arVal){
		$datetime[$key]=$arVal['DATETIME'];
	}
	array_multisort($datetime, SORT_ASC, $arResult);
	//echo '<pre>'; print_r($arResult); echo '</pre>';
	
	$TOTAL_DEBET = 0;
	$TOTAL_KREDIT = 0;
	foreach($arResult as $arElem){
		if($arElem['TYPE']=='Payment'){
			$TYPE = 'Оплата ('.$arElem['NUMBER'].' от '.date($DB->DateFormatToPHP(CSite::GetDateFormat("SHORT")), strtotime($arElem['DATETIME'])).')';
			$DEBET = '';
			$KREDIT = $arElem['SUM'];
			$TOTAL_KREDIT += $TOTAL_KREDIT;
		}else{
			$TYPE = 'Продажа ('.$arElem['NUMBER'].' от '.date($DB->DateFormatToPHP(CSite::GetDateFormat("SHORT")), strtotime($arElem['DATETIME'])).')';
			$DEBET = $arElem['SUM'];
			$TOTAL_DEBET += $DEBET;
			$KREDIT = '';
		}
		$strToHTML .= '
			<tr>
				<td align="left" style="border: 1px solid black;">'.date($DB->DateFormatToPHP(CSite::GetDateFormat("SHORT")), strtotime($arElem['DATETIME'])).'</td>
				<td colspan="4" align="left" style="border: 1px solid black;">'.$TYPE.'</td>
				<td align="left" style="border: 1px solid black;">'.$DEBET.'</td>
				<td align="left" style="border: 1px solid black;">'.$KREDIT.'</td>
				
				<td align="left" style="border: 1px solid black;">&nbsp;</td>
				<td colspan="4" align="left" style="border: 1px solid black;">&nbsp;</td>
				<td align="left" style="border: 1px solid black;">&nbsp;</td>
				<td align="left" style="border: 1px solid black;">&nbsp;</td>
			</tr>
		';
	}
	
	$TOTAL_DEBET_ = $TOTAL_DEBET;
	if($TOTAL_DEBET==0){$TOTAL_DEBET_ = '';}
	$TOTAL_KREDIT_ = $TOTAL_KREDIT;
	if($TOTAL_KREDIT==0){$TOTAL_KREDIT_ = '';}
	
	$SALDO = $TOTAL_DEBET - $TOTAL_KREDIT;
	$zad = 'задолженность отсутствует.';
	if($SALDO>0){
		$zad = 'задолженность составляет '.number_format($SALDO, 0, '', ' ').' руб.';
	}elseif($SALDO<0){
		$zad = 'переплата составляет '.number_format($SALDO*(-1), 0, '', ' ').' руб.';
	}
	
	$strToHTML .= '
		<tr>
			<td colspan="5" align="left" style="border: 1px solid black;">Обороты за период</td>
			<td align="left" style="border: 1px solid black;">'.$TOTAL_DEBET_.'</td>
			<td align="left" style="border: 1px solid black;">'.$TOTAL_KREDIT_.'</td>
			
			<td colspan="5" align="left" style="border: 1px solid black;">&nbsp;</td>
			<td align="left" style="border: 1px solid black;">&nbsp;</td>
			<td align="left" style="border: 1px solid black;">&nbsp;</td>
		</tr>
		
		<tr>
			<td colspan="5" align="left" style="border: 1px solid black;">Конечное сальдо</td>
			<td align="left" style="border: 1px solid black;">'.$SALDO.'</td>
			<td align="left" style="border: 1px solid black;">&nbsp;</td>
			
			<td colspan="5" align="left" style="border: 1px solid black;">Конечное сальдо</td>
			<td align="left" style="border: 1px solid black;">&nbsp;</td>
			<td align="left" style="border: 1px solid black;">&nbsp;</td>
		</tr>
		
		<tr>
			<td colspan="15" align="center">&nbsp;</td>
		</tr>
		
		<tr>
			<td colspan="7" align="left">По данным ООО "МедКомплекс "А.В.К."</td>
		</tr>
		<tr>
			<td colspan="7" align="left">на '.date($DB->DateFormatToPHP(CSite::GetDateFormat("SHORT")), strtotime($data['DATE_TO'])).' '.$zad.'</td>
		</tr>
	';
	
	$strToHTML .= '</table>';

$pdf->writeHTML($strToHTML, true, false, false, false, '');
    
    $pdf->Output($_SERVER["DOCUMENT_ROOT"]."charge/".$data["FILE_NAME"].".pdf", 'F');
    
    if($toBrowser === true)
        $pdf->Output($data["FILE_NAME"].".pdf", 'D');
    
    return $_SERVER["DOCUMENT_ROOT"]."charge/".$data["FILE_NAME"].".pdf";
}
?>

/var/././backup/././external_www/new02.medcomp.ru/downloadorder/saving_akts.php