static function open_in_tbl($kp_id) { $arr = self::fetch_kp_rows($kp_id); //echo '<pre>';print_r($arr);echo '</pre>'; //exit; $glob_counter = 0; $mst_btn_summ = 0; $service_row[0] = array('quantity' => '', 'price_in' => '', 'price_out' => '', 'row_status' => '', 'glob_status' => ''); foreach ($arr as $key => $row) { $glob_counter++; // Проходим по первому уровню и определям некоторые моменты отображения таблицы, которые будут применены при проходе по второму // уровню массива, ряды таблицы будут создаваться там // если товарная позиция имеет больше одного варианта расчета вставляем пустой ряд вверх // echo '<pre>'; print_r($row['dop_data']); echo '</pre>'; if (isset($row['dop_data']) && count($row['dop_data']) > 1) { $row['dop_data'] = $service_row + $row['dop_data']; } // здесь мы определяем значение для атрибута rowspan тегов td которые будут выводится единой ячейкой для всей товарной позиции $row_span = count($row['dop_data']); $counter = 0; // echo '<pre>'; print_r($row['dop_data']); echo '</pre>---'; // Проходим в цикле по второму уровню массива($row['dop_data']) на основе которого строится основной шаблон таблицы foreach ($row['dop_data'] as $dop_key => $dop_row) { // определяем какие расчеты будут учитываться в конечных суммах а какие нет и их отображение в таблице // json_decode($row['details']); if ($dop_key != 0) { $expel = array("main" => 0, "print" => 0, "dop" => 0); if (@$dop_row['expel'] != '') { $obj = @json_decode($dop_row['expel']); foreach ($obj as $expel_key => $expel_val) { $expel[$expel_key] = $expel_val; } } //echo '<br />'; print_r($expel); // работаем с информацией о дополнительных услугах определяя что будет выводиться и где // 1. определяем данные описывающие варианты нанесения логотипа, они хранятся в $dop_row['dop_uslugi']['print'] if (isset($dop_row['dop_uslugi']['print'])) { // если $dop_row['dop_uslugi']['print'] есть выводим данные о нанесениях $summ_in = $summ_out = array(); foreach ($dop_row['dop_uslugi']['print'] as $extra_data) { $summ_in[] = $extra_data['quantity'] * $extra_data['price_in']; $extra_data['price_out'] = $extra_data['discount'] != 0 ? $extra_data['price_out'] / 100 * (100 + $extra_data['discount']) : $extra_data['price_out']; $summ_out[] = $extra_data['quantity'] * $extra_data['price_out']; } $print_btn = '<span>' . count($dop_row['dop_uslugi']['print']) . '</span>'; $print_in_summ = array_sum($summ_in); $print_out_summ = array_sum($summ_out); } else { // если данных по печати нет то проверяем - выводим кнопку добавление нанесения $print_btn = '<span>+</span>'; $print_in_summ = 0; $print_out_summ = 0; } // 2. определяем данные описывающие варианты дополнительных услуг, они хранятся в $dop_row['dop_uslugi']['extra'] if (isset($dop_row['dop_uslugi']['extra'])) { // если $dop_row['dop_uslugi']['extra'] есть выводим данные о дополнительных услугах $summ_in = $summ_out = array(); foreach ($dop_row['dop_uslugi']['extra'] as $extra_data) { $summ_in[] = $extra_data['for_how'] == 'for_all' ? $extra_data['price_in'] : $extra_data['quantity'] * $extra_data['price_in']; $extra_data['price_out'] = $extra_data['discount'] != 0 ? $extra_data['price_out'] / 100 * (100 + $extra_data['discount']) : $extra_data['price_out']; $summ_out[] = $extra_data['for_how'] == 'for_all' ? $extra_data['price_out'] : $extra_data['quantity'] * $extra_data['price_out']; } $dop_uslugi_btn = '<span>' . count($dop_row['dop_uslugi']['extra']) . '</span>'; $dop_uslugi_in_summ = array_sum($summ_in); $dop_uslugi_out_summ = array_sum($summ_out); } else { $dop_uslugi_btn = '<span>+</span>'; $dop_uslugi_in_summ = 0; $dop_uslugi_out_summ = 0; } // подсчет сумм в ряду $price_out = $dop_row['discount'] != 0 ? $dop_row['price_out'] / 100 * (100 + $dop_row['discount']) : $dop_row['price_out']; // 1. подсчитываем входящую сумму $price_in_summ = $dop_row['quantity'] * $dop_row['price_in']; $in_summ = $price_in_summ; if (!!!$expel["print"]) { $in_summ += $print_in_summ; } if (!!!$expel["dop"]) { $in_summ += $dop_uslugi_in_summ; } // 2. подсчитываем исходящую сумму $price_out_summ = $dop_row['quantity'] * $price_out; $out_summ = $price_out_summ; if (!!!$expel["print"]) { $out_summ += $print_out_summ; } if (!!!$expel["dop"]) { $out_summ += $dop_uslugi_out_summ; } $delta = $out_summ - $in_summ; $margin = $out_summ - $in_summ; $price_in_summ_format = number_format($price_in_summ, '2', '.', ''); $price_out_summ_format = number_format($price_out_summ, '2', '.', ''); $print_in_summ_format = number_format($print_in_summ, '2', '.', ''); $print_out_summ_format = number_format($print_out_summ, '2', '.', ''); $dop_uslugi_in_summ_format = number_format($dop_uslugi_in_summ, '2', '.', ''); $dop_uslugi_out_summ_format = number_format($dop_uslugi_out_summ, '2', '.', ''); $in_summ_format = number_format($in_summ, '2', '.', ''); $out_summ_format = number_format($out_summ, '2', '.', ''); $delta_format = number_format($delta, '2', '.', ''); $margin_format = number_format($margin, '2', '.', ''); // если ряд не исключен из расчетов добавляем значения в итоговый ряд if (!!!$expel["main"]) { @($total['price_in_summ'] += $price_in_summ); @($total['price_out_summ'] += $price_out_summ); if (!!!$expel["print"]) { @($total['print_in_summ'] += $print_in_summ); } if (!!!$expel["print"]) { @($total['print_out_summ'] += $print_out_summ); } if (!!!$expel["dop"]) { @($total['dop_uslugi_in_summ'] += $dop_uslugi_in_summ); } if (!!!$expel["dop"]) { @($total['dop_uslugi_out_summ'] += $dop_uslugi_out_summ); } @($total['in_summ'] += $in_summ); @($total['out_summ'] += $out_summ); } $img_design_path = HOST . '/skins/images/img_design/'; $currency = 'р'; $quantity_dim = 'шт'; $discount = $dop_row['discount'] . '%'; $srock_sdachi = implode('.', array_reverse(explode('-', $dop_row['shipping_date']))); if ($srock_sdachi == '00.00.0000') { $srock_sdachi = ''; } $expel_class_main = $expel['main'] == '1' ? ' red_cell' : ''; $expel_class_print = $expel['print'] == '1' ? ' red_cell' : ''; $expel_class_dop = $expel['dop'] == '1' ? ' red_cell' : ''; } else { $expel = array("main" => 0, "print" => 0, "dop" => 0); $currency = $print_btn = $dop_uslugi_btn = ''; $price_out = $price_in_summ_format = $price_out_summ_format = $print_in_summ_format = $print_out_summ_format = ''; $dop_uslugi_in_summ_format = $dop_uslugi_out_summ_format = $in_summ_format = $out_summ_format = ''; $delta_format = $margin_format = $expel_class_main = $expel_class_print = $expel_class_dop = $quantity_dim = $discount = $srock_sdachi = $print_exists_flag = ''; } $men_text_details_arr = isset($dop_row['dop_men_text_details']) && $dop_row['dop_men_text_details'] != '' ? explode('|', $dop_row['dop_men_text_details']) : array(0, 0); if ($row['row_type'] == 'cat') { $extra_panel = '<div class="pos_plank cat"> <a href="?page=client_folder§ion=rt_position&id=' . $key . '">' . $row['art'] . '</a> <div class="pos_link_plank"> <div class="catalog"> <a id="" href="/?page=description&id=' . $row['art_id'] . '" target="_blank" onmouseover="change_href(this);return false;">APL</a> </div> <div class="supplier"> ' . identify_supplier_by_prefix($row['art']) . ' </div> </div> </div> <div>' . $row['name'] . '</div>'; } else { $extra_panel = '<div class="pos_plank pol"> <a href="?page=client_folder§ion=rt_position&id=' . $key . '">' . $row['name'] . '</a> </div>'; } $cur_row = ''; $cur_row .= '<tr ' . ($counter == 0 ? 'pos_id="' . $key . '" type="' . $row['row_type'] . '"' : '') . ' row_id="' . $dop_key . '" art_id="' . $row['art_id'] . '" class="' . ($key > 1 && $counter == 0 ? 'pos_edge ' : '') . (count($row['dop_data']) - 1 == $counter ? 'lowest_row_in_pos ' : '') . '">'; $cur_row .= $counter == 0 ? '<td rowspan="' . $row_span . '" type="glob_counter" class="top glob_counter" width="30">' . $glob_counter . '</td>' : ''; $cur_row .= $counter == 0 ? '<td rowspan="' . $row_span . '" class="hidden">' . $dop_key . '</td>' : ''; $cur_row .= $counter == 0 ? '<td rowspan="' . $row_span . '" class="hidden">' . $row['row_type'] . '</td>' : ''; $cur_row .= $counter == 0 ? '<td rowspan="' . $row_span . '" width="270" type="name" class="top">' . $extra_panel . '</td>' : ''; $cur_row .= '<td width="30" style="position:relative;"><div class="comment_div" data-href="?page=client_folder§ion=rt_position&id=' . $men_text_details_arr[0] . '&client_id=' . $_GET['client_id'] . '" data-id="' . $men_text_details_arr[1] . '"></div></td> <td width="60" class="right">' . $dop_row['quantity'] . '</td> <td width="20" class="r_border left quantity_dim">' . $quantity_dim . '</td> <td width="90" type="price_in" connected_vals="art_price" c_stat="1" class="in right">' . $dop_row['price_in'] . '</td> <td width="15" connected_vals="art_price" c_stat="1" class="currency left">' . $currency . '</td> <td width="90" type="price_in_summ" connected_vals="art_price" c_stat="0" class="in right hidden">' . $price_in_summ_format . '</td> <td width="15" connected_vals="art_price" c_stat="0" class="currency left hidden">' . $currency . '</td> <td width="40" class="center">' . $discount . '</td> <td width="90" connected_vals="art_price" c_stat="1" class="out right">' . $price_out . '</td> <td width="15" class="currency left r_border" connected_vals="art_price" c_stat="1" >' . $currency . '</td> <td width="90" connected_vals="art_price" c_stat="0" class="out right hidden">' . $price_out_summ_format . '</td> <td width="15" connected_vals="art_price" c_stat="0" class="currency left r_border hidden">' . $currency . '</td> <td width="25" class="calc_btn_no_active">' . $print_btn . '</td> <td width="80" connected_vals="print" c_stat="0" class="test_data in hidden ' . $expel_class_print . '">' . $print_in_summ_format . $currency . '</td> <td width="80" connected_vals="print" c_stat="1" class="out ' . $expel_class_print . '">' . $print_out_summ_format . $currency . '</td> <td width="25" class="calc_btn_no_active">' . $dop_uslugi_btn . '</td>'; $cur_row .= '<td width="80" connected_vals="uslugi" c_stat="0" class="test_data r_border in hidden ' . $expel_class_dop . '">' . $dop_uslugi_in_summ_format . $currency . '</td>'; $cur_row .= '<td width="80" connected_vals="uslugi" c_stat="1" class="out r_border ' . $expel_class_dop . '">' . $dop_uslugi_out_summ_format . $currency . '</td> <td width="100" connected_vals="total_summ" c_stat="0" class="in right hidden ' . $expel_class_main . '">' . $in_summ_format . '</td> <td width="15" connected_vals="total_summ" c_stat="0" class="currency hidden r_border ' . $expel_class_main . '">' . $currency . '</td> <td width="100" connected_vals="total_summ" c_stat="1" class="out right ' . $expel_class_main . '">' . $out_summ_format . '</td> <td width="15" connected_vals="total_summ" c_stat="1" class="currency r_border left ' . $expel_class_main . '">' . $currency . '</td> <td width="70" class="grey r_border center">' . $srock_sdachi . '</td> <td width="80" type="delta" class="right">' . $delta_format . '</td> <td width="10" class="left">' . $currency . '</td> <td width="80" type="margin" class="right">' . $margin_format . '</td> <td width="10" class="left">' . $currency . '</td> <td stretch_column> </td>'; $cur_row .= '<td ></td>'; $cur_row .= '</tr>'; // загружаем сформированный ряд в итоговый массив $tbl_rows[] = $cur_row; $counter++; } } $rt = '<table class="rt_tbl_head" id="rt_tbl_head" scrolled="head" style="width: 100%;" border="0"> <tr class="w_border cap"> <td width="30"></td> <td class="hidden"></td> <td class="hidden">тип</td> <td width="270" class="right"></td> <td width="30"></td> <td width="60" class="right">тираж</td> <td width="20" class="r_border"></td> <td width="90" connected_vals="art_price" c_stat="1" class="grey w_border right pointer">$ товара<br /><span class="small">входящая штука</span></td> <td width="15" connected_vals="art_price" c_stat="1" class="grey w_border"></td> <td width="90" connected_vals="art_price" c_stat="0" class="grey w_border right hidden pointer">$ товара<br /><span class="small">входящая тираж</span></td> <td width="15" connected_vals="art_price" c_stat="0" class="grey w_border hidden"></td> <td width="40" class="grey w_border">наценка</td> <td width="90" connected_vals="art_price" c_stat="1" class="grey w_border right pointer">$ товара<br /><span class="small">исходящая штука</span></td> <td width="15" connected_vals="art_price" c_stat="1" class="grey w_border r_border"></td> <td width="90" connected_vals="art_price" c_stat="0" class="grey w_border right pointer hidden">$ товара<br /><span class="small">исходящая тираж</span></td> <td width="15" connected_vals="art_price" c_stat="0" class="grey w_border r_border hidden"></td> <td width="25"></td> <td width="80" connected_vals="print" c_stat="0" class="pointer hidden">$ печать<br /><span class="small">входящая тираж</span></td> <td width="80" connected_vals="print" c_stat="1" class="pointer">$ печать<br /><span class="small">исходящая тираж</span></td> <td width="25"></td>'; $rt .= '<td width="80" connected_vals="uslugi" c_stat="0" class="pointer r_border hidden">$ доп. услуги<br /><span class="small">входящая тираж</span></td> <td width="80" connected_vals="uslugi" c_stat="1" class="out pointer r_border">$ доп. услуги<br /><span class="small">исходящая тираж</span></td> <td width="100" connected_vals="total_summ" c_stat="0" class="pointer hidden center">итого<br /><span class="small">входящая</span></td> <td width="15" connected_vals="total_summ" c_stat="0" class="hidden r_border"></td> <td width="100" connected_vals="total_summ" c_stat="1" class="pointer center">итого<br /><span class="small">исходящая</span></td> <td width="15" connected_vals="total_summ" c_stat="1" class="r_border"></td> <td width="70" class="center grey r_border">срок сдачи</td> <td width="80" class="center">delta</td> <td width="10"></td> <td width="80" class="center">маржина-<br />льность</td> <td width="10"></td> <td stretch_column> </td> <td width="70">статус</td>'; $rt .= '</tr> <tr row_id="total_row" class="grey bottom_border"> <td width="30" height="18"></td> <td class="hidden"></td> <td class="hidden"></td> <td class="hidden"></td> <td></td> <td class="right"></td> <td></td> <td width="20" class="r_border"></td> <td connected_vals="art_price" c_stat="1"></td> <td width="15" connected_vals="art_price" c_stat="1"></td> <td type="price_in_summ" connected_vals="art_price" c_stat="0" class="right hidden">' . number_format(@$total['price_in_summ'], '2', '.', '') . '</td> <td width="15" connected_vals="art_price" c_stat="0" class="hidden">р</td> <td width="40" class=""></td> <td connected_vals="art_price" c_stat="1"></td> <td width="15" connected_vals="art_price" c_stat="1" class="r_border"></td> <td type="price_out_summ" connected_vals="art_price" c_stat="0" class="right hidden">' . number_format(@$total['price_out_summ'], '2', '.', '') . '</td> <td width="15" connected_vals="art_price" c_stat="0" class="r_border hidden">р</td> <td></td> <td type="print_in_summ" connected_vals="print" c_stat="0" class="hidden">' . number_format(@$total['print_in_summ'], '2', '.', '') . 'р</td> <td type="print_out_summ" connected_vals="print" c_stat="1">' . number_format(@$total['print_out_summ'], '2', '.', '') . 'р</td> <td></td>'; $rt .= '<td width="80" type="dop_uslugi_in_summ" connected_vals="uslugi" c_stat="0" class="r_border hidden">' . number_format(@$total['dop_uslugi_in_summ'], '2', '.', '') . 'р</td> <td width="80" type="dop_uslugi_out_summ" connected_vals="uslugi" c_stat="1" class="out r_border">' . number_format(@$total['dop_uslugi_out_summ'], '2', '.', '') . 'р</td> <td width="100" type="in_summ" connected_vals="total_summ" c_stat="0" class="right hidden">' . number_format(@$total['in_summ'], '2', '.', '') . '</td> <td width="15" connected_vals="total_summ" c_stat="0" class="left hidden r_border">р</td> <td width="100" type="out_summ" connected_vals="total_summ" c_stat="1" class="right">' . number_format(@$total['out_summ'], '2', '.', '') . '</td> <td width="15" connected_vals="total_summ" c_stat="1" class="left r_border">р</td> <td width="70" class="grey r_border"></td> <td width="80" type="delta" class="right">' . number_format(@$total['out_summ'] - @$total['in_summ'], '2', '.', '') . '</td> <td width="10" class="left">р</td> <td width="80" type="margin" class="right">' . number_format(@$total['out_summ'] - @$total['in_summ'], '2', '.', '') . '</td> <td width="10" class="left">р</td> <td stretch_column></td> <td></td>'; $rt .= '</tr> </table> <div id="scrolled_part_container" class="scrolled_tbl_movable_part"> <table class="rt_tbl_body" id="rt_tbl_body" scrolled="body" border="0">' . implode('', $tbl_rows) . '</table> </div>'; return $rt; }
private function check_exists_articul_AJAX() { $html = ''; if (strlen($_POST['art']) < 4) { $html .= '<div class="inform_message red">Количество символов в артикуле должно быть не менее 4 (четырёх) символов.</div>'; echo '{"response":"OK","html":"' . base64_encode($html) . '"}'; exit; } $html .= '<form>'; // делаем запрос в базу по артикулу $art_arr = $this->search_articule_Database($_POST['art']); // получаем количесвто найденных совпадений $count = count($art_arr); switch ($count) { case 1: // всё впорядке, мы нашли то, что искали $html .= '<div class="inform_message">Найдено <strong>одно</strong> совпадение</div>'; $html .= '<table id="choose_one_of_several_articles">'; $html .= '<tr>'; $html .= '<th>п</th>'; $html .= '<th>Арт.</th>'; $html .= '<th>Название</th>'; $html .= '<th>Поставщик</th>'; $html .= '<th>Апл</th>'; $html .= '</tr>'; $n = 1; $html .= '<tr data-art_id="' . $art_arr[0]['id'] . '" data-art_name="' . $art_arr[0]['name'] . '" data-art="' . $art_arr[0]['art'] . '" class="checked">'; $html .= '<td>' . $n++ . '</td>'; $html .= '<td>' . $art_arr[0]['art'] . '</td>'; $html .= '<td>' . $art_arr[0]['name'] . '</td>'; $html .= '<td>' . identify_supplier_by_prefix($art_arr[0]['art']) . '</td>'; $html .= '<td><a target="_blank" href="http://www.apelburg.ru/description/' . $art_arr[0]['id'] . '/">на сайт</a></td>'; $html .= '</tr>'; // добавляем полное описание артикула if (trim($art_arr[0]['description']) != '') { $html .= '<tr>'; $html .= '<td colspan="5">'; $html .= '<div>' . $art_arr[0]['description'] . '</div>'; $html .= '</td>'; $html .= '</tr>'; } $html .= '</table>'; // добавляем скрытые поля $html .= '<input type="hidden" name="AJAX" value="insert_in_database_new_catalog_position">'; $html .= '<input type="hidden" name="art_id" value="' . $art_arr[0]['id'] . '">'; $html .= '<input type="hidden" name="art" value="' . $art_arr[0]['art'] . '">'; $html .= '<input type="hidden" name="art_name" value="' . $art_arr[0]['name'] . '">'; $html .= '</form>'; break; case 0: // мы ненашли ничего $html = '<div class="inform_message red">Такого артикула нет в базе. Попробуйте ввести другое значение.</div>'; break; default: // мы нашли более одного совпадения $html .= '<div class="inform_message">Найдено <strong>' . $count . '</strong> совпадения(й). Пожалуйста уточните Ваш запрос.</div>'; $html .= '<table id="choose_one_of_several_articles">'; $html .= '<tr>'; $html .= '<th>п</th>'; $html .= '<th>Арт.</th>'; $html .= '<th>Название</th>'; $html .= '<th>Поставщик</th>'; $html .= '<th>Апл</th>'; $html .= '</tr>'; $n = 1; foreach ($art_arr as $key => $articul) { $html .= '<tr data-art_id="' . $articul['id'] . '" data-art_name="' . $articul['name'] . '" data-art="' . $articul['art'] . '" ' . ($key == 0 ? 'class="checked"' : '') . '>'; $html .= '<td>' . $n++ . '</td>'; $html .= '<td>' . $articul['art'] . '</td>'; $html .= '<td>' . $articul['name'] . '</td>'; $html .= '<td>' . identify_supplier_by_prefix($articul['art']) . '</td>'; $html .= '<td><a target="_blank" href="http://www.apelburg.ru/description/' . $articul['id'] . '/">на сайт</a></td>'; $html .= '</tr>'; } $html .= '</table>'; // добавляем скрытые поля $html .= '<input type="hidden" name="AJAX" value="insert_in_database_new_catalog_position">'; $html .= '<input type="hidden" name="art_id" value="' . $art_arr[0]['id'] . '">'; $html .= '<input type="hidden" name="art_name" value="' . $art_arr[0]['name'] . '">'; $html .= '<input type="hidden" name="art" value="' . $art_arr[0]['art'] . '">'; $html .= '</form>'; break; } echo '{"response":"OK","html":"' . base64_encode($html) . '"}'; }
private function table_order_positions_rows_for_design_Html() { //$this->position_item // получаем массив позиций $positions_rows = $this->positions_rows_Database($this->specificate['id']); $this->number_of_positions = count($positions_rows); $html = ''; $html_row_1 = ''; // формируем строки позиций (перебор позиций) $n = 0; foreach ($positions_rows as $key => $this->position) { $this->Position_status_list = array(); // в переменную заложим все статусы $this->id_dop_data = $this->position['id_dop_data']; // ТЗ на изготовление продукцию для НЕКАТАЛОГА // для каталога и НЕкаталога способы хранения и получения данной информации различны // $this->no_cat_TZ = ''; // if(trim($this->position['type'])!='cat'){ // // доп инфо по некаталогу берём из json // $this->no_cat_TZ = $this->decode_json_no_cat_to_html($this->position); // } // получаем массив услуг по позиции $this->position_services_arr = $this->get_order_dop_uslugi($this->id_dop_data); // выборка только массива услуг дизайна $this->services_design = $this->get_dop_services_for_production($this->position_services_arr, 9); // выборка только массива услуг производства $this->services_production = $this->get_dop_services_for_production($this->position_services_arr, 4); // выборка услуг оутсорс (которые ведёт снабжение) $this->services_production_snab = $this->get_dop_services_for_production($this->position_services_arr, 8); $this->services_num = count($this->services_design); $n++; // если услуг для производства в данной позиции нет - переходм к следующей if ($this->services_num == 0) { continue; } if (isset($_GET['subsection']) && $_GET['subsection'] == 'design_films_and_cliches') { if ($this->check_the_status_films(array('нужно делать', 'перевывод', 'готовы к отправке', 'отправлены на фотовывод', 'клише заказано'))) { continue; } } // плёнки клише $html_row_5 = '<td class="show-backlight" rowspan="' . $this->services_num . '">'; // подрядчик печати $html_row_5 .= $this->position['suppliers_name']; // пленки / клише $film_and_cliches = $this->get_film_and_cliches(); $html_row_5 .= $film_and_cliches; $html_row_5 .= '</td>'; // // порядковый номер позиции в заказе $html_row_1 = '<td rowspan="' . $this->services_num . '"><span class="orders_info_punct">' . $this->position['sequence_number'] . 'п<br>(' . $this->Order['number_of_positions'] . ')</span></td>'; // // описание позиции $html_row_1 .= '<td rowspan="' . $this->services_num . '" >'; $html_row_1 .= '<div style="position:relative">'; // вставляем номер заказа $html_row_1 .= '№ ' . $this->order_num_for_User . '<br>'; // наименование товара $html_row_1 .= '<span class="art_and_name">' . $this->position['art'] . ' ' . $this->position['name'] . '</span>'; // описание некаталожной продукции // $html_row_1 .= $this->no_cat_TZ; // места нанесения $html_row_1 .= $this->get_service_printing_list(); $html_row_1 .= 'Тираж: ' . $this->position['quantity'] . ' шт.'; // добавляем доп описание if ($this->position['type'] == 'cat') { $html_row_1 .= '<div>'; $html_row_1 .= '<input type="button" class="get_size_table_read" data-id_dop_data="' . $this->position['quantity'] . '" data-position_id="' . $this->position['id'] . '" value="Подробно" >'; $html_row_1 .= '</div>'; } else { $disabled_command_edit_tz = $this->user_access != 1 && $this->user_access != 8 && $this->user_access != 9 ? 'disabled ' : ''; $html_row_1 .= '<div title="необходимо исправить ТЗ" class="' . $disabled_command_edit_tz . 'command_for_edit_tz_for_no_cat ' . ($this->position['flag_need_edit_tz_no_cat'] == 1 ? 'checked' : '') . '" data-position_id="' . $this->position['id'] . '"></div>'; if ($this->user_access == 8 || $this->user_access == 1) { $html_row_1 .= '<div class="edit_tz_for_no_cat" data-id_dop_data="' . $this->position['quantity'] . '" data-position_id="' . $this->position['id'] . '" ></div>'; } $html_row_1 .= '<div>'; $html_row_1 .= '<input class="get_a_detailed_specifications" type="button" value="Подробно" data-position_id="' . $this->position['id'] . '">'; $html_row_1 .= '</div>'; } $html_row_1 .= '<div class="linked_div">' . identify_supplier_by_prefix($this->position['art']) . '</div>'; $html_row_1 .= '</div>'; $html_row_1 .= '</td>'; // дата сдачи макета $html_row_2 = '<td class="show-backlight" rowspan="' . $this->services_num . '">'; $this->shipping_date_limit = $this->specificate['shipping_date_limit'] != '00.00.0000' ? $this->specificate['shipping_date_limit'] : ''; $html_row_2 .= '<span class="greyText">' . $this->shipping_date_limit . '</span>'; $html_row_2 .= '</td>'; // дата утв. макета $html_row_3 = '<td class="show-backlight" rowspan="' . $this->services_num . '" ><span class="greyText">'; // проверка на отсутствие пустого значения // if($this->position['approval_date']!='' && $this->position['approval_date']!='00.00.0000 00:00:00'){ // $approval_date_timestamp = strtotime($this->position['approval_date']); // if($approval_date_timestamp != 0){ // // дата // $this->approval_date = date('d.m.Y',$approval_date_timestamp); // $html_row_3 .= $this->approval_date; // // время // $this->approval_time = date('H:i',$approval_date_timestamp); // if($this->approval_time != '00:00'){ // $html_row_3 .= '<br>'.$this->approval_time.''; // } // } // } if ($this->position['approval_date'] != '' && $this->position['approval_date'] != '00.00.0000 00:00:00') { // дата $approval_date_timestamp = strtotime($this->position['approval_date']); $this->approval_date = date('d.m.Y', $approval_date_timestamp); // $html_row_3 .= $this->approval_date; // время $this->approval_time = date('H:i', $approval_date_timestamp); // if($this->approval_time != '00:00'){ // $html_row_3 .= '<br>'.$this->approval_time.''; // } //$html_row_3 .= '<span class="greyText">'.$shipping_date_date.(($shipping_date_time!='00:00')?'<br>к '.$shipping_date_time:'').'</span>'; $html_row_3 .= '<a href="' . $this->link_enter_to_filters('approval_date', $this->approval_date) . '">' . $this->approval_date . '</a>' . ($this->approval_time != '00:00' ? '<br>к ' . $this->approval_time : ''); // $html .= '<div>'.$this->Order['date_of_delivery_of_the_order'].'</div>'; } $html_row_3 .= '</td>'; // дата печати $html_row_4 = '<td class="show-backlight" rowspan="' . $this->services_num . '" >'; $html_row_4 .= $this->get_date_printing(); $html_row_4 .= '</td>'; $html .= $this->get_service_content_for_designer_operations($this->position, $this->services_design, $html_row_1, $html_row_2, $html_row_3, $html_row_4, $html_row_5); // $this->position_item++; // $this->position_item = count($positions_rows) * $this->services_num+1; } return $html; }
protected function check_exists_articul_AJAX() { $html = ''; if (strlen($_POST['art']) < 2) { $html .= '<div class="inform_message red">Количество символов в артикуле должно быть не менее 2 (четырёх) символов.</div>'; echo '{"response":"OK","html":"' . base64_encode($html) . '"}'; exit; } $html .= '<form>'; // делаем запрос в базу по артикулу $art_arr = $this->search_articule_Database($_POST['art']); // получаем количесвто найденных совпадений $count = count($art_arr); switch ($count) { case 0: // мы ненашли ничего $html = '<div class="inform_message red">Такого артикула нет в базе. Попробуйте ввести другое значение.</div>'; break; // // default: // мы нашли более одного совпадения $html .= '<div class="inform_message">Найдено <strong>' . $count . '</strong> совпадения(й). Пожалуйста уточните Ваш запрос.</div>'; $html .= '<table id="choose_one_of_several_articles">'; $html .= '<tr>'; $html .= '<th class="admin_checkbox"></th>'; $html .= '<th>п</th>'; $html .= '<th>Арт.</th>'; $html .= '<th>Название</th>'; $html .= '<th>Поставщик</th>'; $html .= '<th>Апл</th>'; $html .= '</tr>'; $n = 1; foreach ($art_arr as $key => $articul) { $html .= '<tr data-art_id="' . $articul['id'] . '" data-art_name="' . $articul['name'] . '" data-art="' . $articul['art'] . '" ' . ($key == 0 ? 'class="checked"' : '') . '>'; $html .= '<td class="admin_checkbox">'; $html .= '<label style="width:100%;height100%;" for="' . $key . '_checkb">'; $html .= '<input name="article[]" type="checkbox" id="' . $key . '_checkb" value="' . $articul['id'] . '" ' . ($key == 0 ? 'checked="checked"' : '') . '>'; $html .= '</label>'; $html .= '</td>'; $html .= '<td>' . $n++ . '</td>'; $html .= '<td>' . $articul['art'] . '</td>'; $html .= '<td>' . $articul['name'] . '</td>'; $html .= '<td>' . identify_supplier_by_prefix($articul['art']) . '</td>'; $html .= '<td><a target="_blank" href="http://www.apelburg.ru/description/' . $articul['id'] . '/">на сайт</a></td>'; $html .= '</tr>'; } $html .= '</table>'; // добавляем скрытые поля $html .= '<input type="hidden" name="AJAX" value="insert_in_database_new_catalog_position">'; $html .= '<input type="hidden" name="art_id" value="' . $art_arr[0]['id'] . '">'; $html .= '<input type="hidden" name="art_name" value="' . $art_arr[0]['name'] . '">'; $html .= '<input type="hidden" name="art" value="' . $art_arr[0]['art'] . '">'; $html .= '</form>'; // if($this->user_access != 1){ // $html .= '<style type="text/css"> // .admin_checkbox{ // display: none; // } // </style>'; // } break; } echo '{"response":"OK","html":"' . base64_encode($html) . '"}'; // echo '{"response":"OK","html":"'.base64_encode($html).'","function":"treatment_choose_art_tbl"}'; exit; }
} //$art_id = get_base_art_id($row['art']); $dop_details = ''; //echo $row['row_type'].' = '; if($row['row_type'] == 'cat'){ $extra_panel = '<div class="pos_plank cat"> <a href="?page=client_folder§ion=rt_position&id='.$key.'&client_id='.$client_id.'">'.$row['art'].'</a> <div class="pos_link_plank"> <div class="catalog"> <a id="" href="/description/'.$row['art_id'].'/" target="_blank" onmouseover="change_href(this);return false;">APL</a> </div> <div class="supplier"> '.identify_supplier_by_prefix($row['art']).' </div> </div> </div> <div>'.$row['name'].'</div> <div><input type="button" class="getSizesBtn" pos_id="'.$key.'" value="Размеры"></div>'; // дополнительная скрытая инфа if($counter==0 && count($row['dop_details'])>0) $dop_details['allowed_prints'] = $row['dop_details']; } else if($row['row_type'] == 'ext'){ $extra_panel = '<div class="pos_plank ext"> <a href="?page=client_folder&client_id='.$_GET['client_id'].'§ion=rt_position&id='.$key.'">'.$row['name'].'</a> </div>'; } else if($row['row_type'] == 'pol'){ $extra_panel = '<div class="pos_plank pol">