$table .= '</tr><tr><td class="num">'.($key2+1).'</td><td class="name">'.$val[$key2]['name'].'</td><td class="quantity">'.$val[$key2]['quantity'].'</td><td class="price">'.$val[$key2]['price'].'</td><td class="currensy">р.</td><td class="price">'.$val[$key2]['summ'].'</td><td class="currensy">р.</td>';
$itogo += (float)$val[$key2]['summ'];
$nds += round(($val[$key2]['summ']/118*18), 2);
}
$table .= '</tr>';
$table .= '<tr class="bold_font"><td colspan="5">Итого с НДС</td><td class="price">'.number_format($itogo,"2",".",'').'</td><td class="currensy">р.</td></tr>';
$table .= '<tr class="bold_font"><td colspan="5">Из них НДС (18%)</td><td class="price">'.number_format($nds,"2",".",'').'</td><td class="currensy">р.</td></tr>';
$table .= '</table>';
$date_arr = explode('-',$val[0]['date']);
$specification_date =$date_arr[2].' '.$month_day_name_arr[(int)$date_arr[1]].' '.$date_arr[0] .' г.';
list($first_part,$second_part) = explode('-',number_format($itogo,2,'-',''));
$for_pay = num_word_transfer($first_part);
$for_pay = strtr($for_pay,$desjatichn_word_transfer_arr);
list($first_part_nds,$second_part_nds) = explode('-',number_format($nds,2,'-',''));
//$for_pay_nds = num_word_transfer($first_part_nds);
//$for_pay_nds = strtr($for_pay_nds,$desjatichn_word_transfer_arr);
$for_pay = '('.$for_pay.' рублей '.$second_part.' коп.), в т.ч. НДС 18% '.$first_part_nds.' руб. '.$second_part_nds.' коп.';
$for_pay = strtr($for_pay,$change_word_ending_arr_I);
$for_pay = strtr($for_pay,$change_word_ending_arr_II);
$for_pay = strtr($for_pay,$change_word_ending_arr_III);
$for_pay = strtr($for_pay,$change_word_ending_arr_IV);
$our_requisit_id = fetchOneValFromGeneratedAgreementTbl(array('retrieve'=>'our_requisit_id','coll'=>'id','val'=>$agreement_id));
$client_requisit_id = fetchOneValFromGeneratedAgreementTbl(array('retrieve'=>'client_requisit_id','coll'=>'id','val'=>$agreement_id));
$agreement_num = '<?php echo $agreement[\'agreement_num\']; ?>';
$agreementDate = '<?php echo $agreement_date; ?>';
$specificationDate = '<?php echo $specification_date; ?>';
$specification_table = '<?php echo $table_data[\'table\']; ?>';
/*$production_term = '<span class="field_for_fill" managed="text" bd_row_id="<?php echo $specifications_arr[$key][0][\'id\']; ?>" bd_field="item_production_term" file_link="1"><?php echo $specifications_arr[$key][0][\'item_production_term\']; ?> </span>';*/
$production_term = '<?php echo $production_term_in_days.\' (\'.$production_term_in_days_word.\')\'; ?>';
if($specifications_arr[$key][0]['specification_type'] == 'days'){
$prepayment_term = '<?php include ($_SERVER[\'DOCUMENT_ROOT\'].\'/os/modules/agreement/agreements_templates/\'.$specifications_arr[$key][0][\'prepayment\'].\'_prepaiment_conditions.tpl\'); ?>';
//$production_term_in_days = getWorkingDays($val[0]['date']." 00:00:00",$specifications_arr[$key][0]['shipping_date_time']);
$production_term_in_days = $specifications_arr[$key][0]['item_production_term'];
$production_term_in_days_word = (trim((int)$production_term_in_days)==0)? 'ноль' : trim(num_word_transfer((int)$production_term_in_days));
$production_delivery_term = $production_term_in_days;//.'('. $production_term_in_days_word.')';
}
if($specifications_arr[$key][0]['specification_type'] == 'date'){
$delivery_date_arr = explode(' ',$specifications_arr[$key][0]['shipping_date_time']);
$delivery_date_arr[0] = implode('.',array_reverse(explode('-',$delivery_date_arr[0])));
$delivery_date_arr[1] = explode(':',$delivery_date_arr[1]);
$delivery_date_arr[1] = $delivery_date_arr[1][0].' часов '.$delivery_date_arr[1][1].' минут ';
$delivery_date = '<?php echo $delivery_date_arr[1].$delivery_date_arr[0]."г."; ?>';
$final_date_time_arr = explode(' ',$specifications_arr[$key][0]['final_date_time']);
$final_date_time_arr[0] = implode('.',array_reverse(explode('-',$final_date_time_arr[0])));
$final_date_time_arr[1] = explode(':',$final_date_time_arr[1]);
static function prepare_general_doc($doc, $general_data, $table_data)
{
//global $mysqli;
global $desjatichn_word_transfer_arr;
global $change_word_ending_arr_I;
global $change_word_ending_arr_II;
global $change_word_ending_arr_III;
global $change_word_ending_arr_IV;
list($first_part, $second_part) = explode('-', number_format($table_data['itogo'], 2, '-', ''));
$for_pay = num_word_transfer($first_part);
$for_pay = strtr($for_pay, $desjatichn_word_transfer_arr);
//list($first_part_nds,$second_part_nds) = explode('-',number_format($table_data['nds'],2,'-',''));
$for_pay = $for_pay . ' рублей ' . $second_part . ' коп.';
//$for_pay = '('.$for_pay.' рублей '.$second_part.' коп.), в т.ч. НДС 18% '.$first_part_nds.' руб. '.$second_part_nds.' коп.';
$for_pay = strtr($for_pay, $change_word_ending_arr_I);
$for_pay = strtr($for_pay, $change_word_ending_arr_II);
$for_pay = strtr($for_pay, $change_word_ending_arr_III);
$for_pay = strtr($for_pay, $change_word_ending_arr_IV);
$delivery_adderss_tpl_path = $general_data['address'] == 'samo_vivoz' ? ROOT . '/modules/agreement/agreements_templates/samo_vivoz.tpl' : ROOT . '/modules/agreement/agreements_templates/nasha_dostavka.tpl';
$fd = fopen($delivery_adderss_tpl_path, 'rb');
$delivery_adderss_string = fread($fd, filesize($delivery_adderss_tpl_path));
fclose($fd);
$delivery_adderss = str_replace('[DELIVERY_ADDRESS]', $general_data['address'], $delivery_adderss_string);
if ($general_data['type'] == 'days') {
//$prepayment_term = '<?php include ($_SERVER[\'DOCUMENT_ROOT\'].\'/os/modules/agreement/agreements_templates/\'.$general_data[\'prepayment\'].\'_prepaiment_conditions.tpl\'); ? >';
/**/
$prepayment_term_tpl_path = ROOT . '/modules/agreement/agreements_templates/' . $general_data['prepayment'] . '_prepaiment_conditions_oferta.tpl';
$fd = fopen($prepayment_term_tpl_path, 'rb');
$prepayment_term = fread($fd, filesize($prepayment_term_tpl_path));
fclose($fd);
$prepayment_term_block = str_replace('[FOR_PAY_TEXT]', number_format($table_data['itogo'], "2", ".", " ") . ' (' . $for_pay . ') в том числе 18% НДС ' . number_format($table_data['nds'], "2", ".", " ") . 'руб.', $prepayment_term);
}
if ($general_data['type'] == 'date') {
$delivery_date_arr = explode(' ', $general_data['shipping_date_time']);
$delivery_date_arr[0] = implode('.', array_reverse(explode('-', $delivery_date_arr[0])));
$delivery_date_arr[1] = explode(':', $delivery_date_arr[1]);
$delivery_date_arr[1] = $delivery_date_arr[1][0] . ' часов ' . $delivery_date_arr[1][1] . ' минут ';
$delivery_date = $delivery_date_arr[1] . $delivery_date_arr[0] . "г.";
$final_date_time_arr = explode(' ', $general_data['final_date_time']);
$final_date_time_arr[0] = implode('.', array_reverse(explode('-', $final_date_time_arr[0])));
$final_date_time_arr[1] = explode(':', $final_date_time_arr[1]);
$final_date_time_arr[1] = $final_date_time_arr[1][0] . ' часов ' . $final_date_time_arr[1][1] . ' минут ';
$maket_handing_date = $final_date_time_arr[1] . $final_date_time_arr[0] . "г.";
$maket_sign_date = $final_date_time_arr[1] . $final_date_time_arr[0] . "г.";
$paymnet_date = $final_date_time_arr[1] . $final_date_time_arr[0] . 'г.';
$doc = str_replace('[PAYMENT_DATE]', $paymnet_date, $doc);
$doc = str_replace('[DELIVERY_DATE]', $delivery_date, $doc);
$doc = str_replace('[MAKET_HANDING_DATE]', $maket_handing_date, $doc);
$doc = str_replace('[MAKET_SIGN_DATE]', $maket_sign_date, $doc);
$prepayment_term_tpl_path = ROOT . '/modules/agreement/agreements_templates/' . $general_data['prepayment'] . '_prepaiment_conditions_oferta_by_date.tpl';
$fd = fopen($prepayment_term_tpl_path, 'rb');
$prepayment_term = fread($fd, filesize($prepayment_term_tpl_path));
fclose($fd);
$prepayment_term_block = str_replace('[PAYMENT_DATE]', $paymnet_date, $prepayment_term);
}
//$doc = str_replace('[SPECIFICATION_NUM]',$specification_num,$doc );
//$doc = str_replace('[SPECIFICATION_DATE]',$specificationDate,$doc );
//$doc = str_replace('[AGREEMENT_NUM]',$agreement_num,$doc );
//$doc = str_replace('[AGREEMENT_DATE]',$agreementDate,$doc );
$doc = str_replace('[DOC_NUM]', '<?php echo $general_data[\'num\']; ?>', $doc);
$doc = str_replace('[DOC_DATE]', implode('.', array_reverse(explode('-', substr($general_data['date_time'], 0, 10)))), $doc);
$doc = str_replace('[PRODUCTION_TERM]', '<?php echo $general_data[\'item_production_term\']; ?>', $doc);
$doc = str_replace('[PREPAMENT_TERM_BLOCK]', $prepayment_term_block, $doc);
$doc = str_replace('[PREPAMENT_TERM]', '<?php echo $general_data[\'prepayment\']; ?>', $doc);
$doc = str_replace('[PRODUCTON_DELIVERY_TERM]', '<?php echo $general_data[\'item_production_term\']; ?>', $doc);
//$doc = str_replace('[PREPAMENT_SUMM]','100',$doc );
$doc = str_replace('[DELIVERY_TERM]', '<?php echo $general_data[\'shipping_date_time\']; ?>', $doc);
$doc = str_replace('[DELIVERY_ADDRESS]', $delivery_adderss, $doc);
$doc = str_replace('[ITEMS_NUM]', $table_data['items_num'], $doc);
$doc = str_replace('[FOR_PAY]', number_format($table_data['itogo'], "2", ".", ""), $doc);
$doc = str_replace('[FOR_PAY_TEXT]', $for_pay, $doc);
$doc = str_replace('[SPECIFICATION_TABLE]', $table_data['table'], $doc);
$doc = str_replace('[OUR_DIRECTOR]', '<?php echo $general_data[\'our_chief\']; ?>', $doc);
$doc = str_replace('[OUR_COMP_FULL_NAME]', '<?php echo $our_firm[\'comp_full_name\']; ?>', $doc);
$doc = str_replace('[OUR_COMP_LEGAL_ADDRESS]', '<?php echo $our_firm[\'legal_address\']; ?>', $doc);
$doc = str_replace('[OUR_COMP_POSTAL_ADDRESS]', '<?php echo $our_firm[\'postal_address\']; ?>', $doc);
$doc = str_replace('[OUR_COMP_INN]', '<?php echo $our_firm[\'inn\']; ?>', $doc);
$doc = str_replace('[OUR_COMP_OGRN]', '<?php echo $our_firm[\'ogrn\']; ?>', $doc);
$doc = str_replace('[OUR_COMP_KPP]', '<?php echo $our_firm[\'kpp\']; ?>', $doc);
$doc = str_replace('[OUR_COMP_R_ACCOUNT]', '<?php echo $our_firm[\'r_account\']; ?>', $doc);
$doc = str_replace('[OUR_COMP_BANK]', '<?php echo $our_firm[\'bank\']; ?>', $doc);
$doc = str_replace('[OUR_COMP_BIK]', '<?php echo $our_firm[\'bik\']; ?>', $doc);
$doc = str_replace('[OUR_COMP_COR_ACCOUNT]', '<?php echo $our_firm[\'cor_account\']; ?>', $doc);
$doc = str_replace('[CLIENT_COMP_FULL_NAME]', '<?php echo $client_firm[\'comp_full_name\']; ?>', $doc);
$doc = str_replace('[CLIENT_COMP_LEGAL_ADDRESS]', '<?php echo $client_firm[\'legal_address\']; ?>', $doc);
$doc = str_replace('[CLIENT_COMP_POSTAL_ADDRESS]', '<?php echo $client_firm[\'postal_address\']; ?>', $doc);
$doc = str_replace('[CLIENT_COMP_INN]', '<?php echo $client_firm[\'inn\']; ?>', $doc);
$doc = str_replace('[CLIENT_COMP_OGRN]', '<?php echo $client_firm[\'ogrn\']; ?>', $doc);
$doc = str_replace('[CLIENT_COMP_KPP]', '<?php echo $client_firm[\'kpp\']; ?>', $doc);
$doc = str_replace('[CLIENT_COMP_R_ACCOUNT]', '<?php echo $client_firm[\'r_account\']; ?>', $doc);
$doc = str_replace('[CLIENT_COMP_BANK]', '<?php echo $client_firm[\'bank\']; ?>', $doc);
$doc = str_replace('[CLIENT_COMP_BIK]', '<?php echo $client_firm[\'bik\']; ?>', $doc);
$doc = str_replace('[CLIENT_COMP_COR_ACCOUNT]', '<?php echo $client_firm[\'cor_account\']; ?>', $doc);
$director_data = explode(' ', $general_data['our_chief']);
$short_director = $director_data[0];
if (count($director_data) > 1) {
for ($i = 1; $i < count($director_data); $i++) {
$short_director .= ' ' . mb_substr($director_data[$i], 0, 1, 'UTF-8') . '.';
}
}
$doc = str_replace('[OUR_DIRECTOR_SHORT]', $short_director, $doc);
return $doc;
}
