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