function get_clients_list_for_user($user_id, $order = array('id', ''), $limit_str = '', $full_data_flag = false) { global $db; $flag_none_clients = FALSE; if ($user_id != 0) { $query_prev = "SELECT*FROM `" . RELATE_CLIENT_MANAGER_TBL . "` WHERE `manager_id` = '" . $user_id . "'"; } else { $query_prev = "SELECT id AS client_id FROM `" . CLIENTS_TBL . "` WHERE `id` NOT IN(SELECT client_id FROM `" . RELATE_CLIENT_MANAGER_TBL . "` )"; } $result_prev = mysql_query($query_prev, $db); if (!$result_prev) { echo mysql_error(); } if (mysql_num_rows($result_prev) > 0) { // создаем строку содержащую список id клиентов $in_string = ''; while ($item = mysql_fetch_assoc($result_prev)) { $in_string .= $item['client_id'] . ','; } $in_string = trim($in_string, ","); //echo $in_string; // если передан параметр time_change сверяем список клиентов датами изменеий в расчетной таблице if ($order[0] == 'time_change') { if ($in_string != '') { $query = "SELECT `client_id` FROM `" . CALCULATE_TBL . "` WHERE `manager_id` = '" . $user_id . "' AND `client_id` IN (" . $in_string . ") ORDER BY `" . $order[0] . "`"; // $result = mysql_query($query, $db); $in_string = ''; while ($item = mysql_fetch_assoc($result)) { $id_arr[] = $item['client_id']; } //print_r($id_arr); krsort($id_arr); reset($id_arr); $id_arr = array_unique($id_arr); if ($limit_str != '') { $id_arr = array_slice($id_arr, intval(substr($limit_str, strpos($limit_str, 'LIMIT') + 6)), intval(substr($limit_str, strpos($limit_str, ',') + 2))); } // echo '<br>'; //print_r($id_arr); if (isset($id_arr)) { foreach ($id_arr as $id) { $query = "SELECT*FROM `" . CLIENTS_TBL . "` WHERE `id` = '" . $id . "'"; // $result = mysql_query($query, $db); if (!$result) { echo mysql_error(); } $item = mysql_fetch_assoc($result); $client_id_arr[] = array('id' => $item['id'], 'name' => $item['name'], 'company' => $item['company']); } } else { $flag_none_clients = TRUE; } } } elseif ($order[0] == 'search') { $query = "SELECT*FROM `" . CLIENTS_TBL . "` WHERE `id` IN (" . $in_string . ") AND `company` LIKE '%" . cor_data_for_SQL($order[1]) . "%' ORDER BY `company` " . $limit_str; $result = mysql_query($query, $db); if (!$result) { echo mysql_error(); } if (mysql_num_rows($result) > 0) { if ($full_data_flag) { while ($item = mysql_fetch_assoc($result)) { $client_id_arr[] = array($item['id'], $item['name'], $item['company'], $item['cont_face1'], $item['phone_cont_face1'], $item['email_cont_face1'], $item['dop_info']); } } else { while ($item = mysql_fetch_assoc($result)) { $client_id_arr[] = array('id' => $item['id'], 'name' => $item['name'], 'company' => $item['company']); } } } else { $flag_none_clients = TRUE; } } else { if ($in_string != '') { if (isset($_GET['show_clients']) && $_GET['show_clients'] == "all_my" || $_SESSION['access']['access'] != 5 || !isset($_GET['page'])) { $query = "SELECT*FROM `" . CLIENTS_TBL . "` WHERE `id` IN (" . $in_string . ") ORDER BY `" . $order[0] . "` " . $order[1] . " " . $limit_str; } else { $query = "SELECT*FROM `" . CLIENTS_TBL . "` WHERE `id` IN (" . $in_string . ") AND`favorite` = 1 ORDER BY `" . $order[0] . "` " . $order[1] . " " . $limit_str; } $result = mysql_query($query, $db); if (!$result) { echo mysql_error(); } if (mysql_num_rows($result) > 0) { if ($full_data_flag) { while ($item = mysql_fetch_assoc($result)) { $client_id_arr[] = array($item['id'], $item['name'], $item['company'], $item['cont_face1'], $item['phone_cont_face1'], $item['email_cont_face1'], $item['dop_info']); } } else { while ($item = mysql_fetch_assoc($result)) { $client_id_arr[] = array('id' => $item['id'], 'name' => $item['name'], 'company' => $item['company']); } } } else { $flag_none_clients = TRUE; } } else { $flag_none_clients = TRUE; } } } else { $flag_none_clients = TRUE; } if ($flag_none_clients) { $client_id_arr[] = array('id' => '', 'name' => 'нет клиентов', 'company' => 'нет клиентов'); } return $client_id_arr; }
static function changeRepresentedData($id, $val, $bd_field) { global $mysqli; $query = "UPDATE `" . KP_MAIN_ROWS . "` SET `" . $bd_field . "`='" . cor_data_for_SQL($val) . "' WHERE `id`='" . $id . "'"; "'"; $mysqli->query($query) or die($mysqli->error); }
} } // foreach($data->tbl_data as $val){ $query ="SELECT*FROM `".BASE__CALCULATORS_Y_PRICE_PARAMS."` WHERE id = '".$val[0]."'"; echo $query; $result = $mysqli->query($query)or die($mysqli->error); if($result->num_rows>0){ $query2 ="UPDATE `".BASE__CALCULATORS_Y_PRICE_PARAMS."` SET print_type_id='".$usluga_id."' , param_type='".cor_data_for_SQL($val[1])."', value='".cor_data_for_SQL($val[2])."', percentage='".(float)$val[3]."' WHERE id = '".$val[0]."'"; $mysqli->query($query2)or die($mysqli->error); } else{ $query2 ="INSERT INTO `".BASE__CALCULATORS_Y_PRICE_PARAMS."` VALUES('','".$usluga_id."','".cor_data_for_SQL($val[1])."','".cor_data_for_SQL($val[2])."','".(float)$val[3]."')"; //echo $query2; $mysqli->query($query2)or die($mysqli->error); } } header('location:'.$_SERVER['HTTP_REFERER']); exit; } $td1 = '<td contenteditable="true">'; $td1_hidden = '<td style="display:none;">'; $td2 = '</td>'; $td_td = $td2.$td1;
static function save_calculatoins_result($details_obj) { global $mysqli; //print_r($details_obj); foreach ($details_obj->print_details->dop_params->YPriceParam as $key => $data) { if (isset($data->cmyk)) { $details_obj->print_details->dop_params->YPriceParam[$key]->cmyk = base64_encode($data->cmyk); } } $details_obj->print_details->comment = isset($details_obj->print_details->comment) ? base64_encode($details_obj->print_details->comment) : ''; // если PHP 5.4 то достаточно этого /* $print_details = json_encode($details_obj->print_details,JSON_UNESCAPED_UNICODE);*/ // но пришлось использовать это $print_details = self::json_fix_cyr(json_encode($details_obj->print_details)); // если нет dop_uslugi_id или он равен ноль, добавляем новый расчет доп услуг для ряда // иначе перезаписываем данные в строке где `id` = $details_obj->dop_uslugi_id if (!isset($details_obj->dop_uslugi_id) || $details_obj->dop_uslugi_id == 0) { $query = "INSERT INTO `" . RT_DOP_USLUGI . "` SET\n\t\t\t\t `dop_row_id` ='" . $details_obj->dop_data_row_id . "',\n\t\t\t\t\t\t\t\t\t `uslugi_id` ='" . $details_obj->print_details->print_id . "',\n\t\t\t\t\t\t\t\t\t `performer` ='" . self::get_performer_id($details_obj->print_details->print_id) . "',\n\t\t\t\t\t\t\t\t\t `glob_type` ='print',\n\t\t\t\t\t\t\t\t\t `tz` ='" . cor_data_for_SQL($details_obj->print_details->comment) . "',\n\t\t\t\t\t\t\t\t\t `quantity` ='" . $details_obj->quantity . "',\n\t\t\t\t\t\t\t\t\t `price_in` = '" . $details_obj->price_in . "',\n\t\t\t\t\t\t\t\t\t `price_out` ='" . $details_obj->price_out . "',\n\t\t\t\t\t\t\t\t\t `discount` ='" . $details_obj->discount . "',\n\t\t\t\t\t\t\t\t\t `creator_id` ='" . $details_obj->creator_id . "',\n\t\t\t\t\t\t\t\t\t `print_details` ='" . cor_data_for_SQL($print_details) . "'"; //echo $query; $mysqli->query($query) or die($mysqli->error); //echo 1; } else { if (isset($details_obj->dop_uslugi_id) && $details_obj->dop_uslugi_id != 0) { $query = "UPDATE `" . RT_DOP_USLUGI . "` SET\n\t\t\t\t `dop_row_id` ='" . $details_obj->dop_data_row_id . "',\n\t\t\t\t\t\t\t\t\t `uslugi_id` ='" . $details_obj->print_details->print_id . "',\n\t\t\t\t\t\t\t\t\t `performer` ='" . self::get_performer_id($details_obj->print_details->print_id) . "',\n\t\t\t\t\t\t\t\t\t `glob_type` ='print',\n\t\t\t\t\t\t\t\t\t `tz` ='" . $details_obj->print_details->comment . "',\n\t\t\t\t\t\t\t\t\t `quantity` ='" . $details_obj->quantity . "',\n\t\t\t\t\t\t\t\t\t `price_in` = '" . $details_obj->price_in . "',\n\t\t\t\t\t\t\t\t\t `price_out` ='" . $details_obj->price_out . "',\n\t\t\t\t\t\t\t\t\t `creator_id` ='" . $details_obj->creator_id . "',\n\t\t\t\t\t\t\t\t\t `print_details` ='" . $print_details . "'\n\t\t\t\t\t\t\t\t\t WHERE `id` ='" . $details_obj->dop_uslugi_id . "'"; //echo $query; $mysqli->query($query) or die($mysqli->error); } } }
} } //exit; // foreach($data->tbl_data as $val){ $query ="SELECT*FROM `".BASE__CALCULATORS_PRINT_TYPES_SIZES_PLACES_REL_TBL."` WHERE id = '".$val[0]."'"; $result = $mysqli->query($query)or die($mysqli->error); if($result->num_rows>0){ $query2 ="UPDATE `".BASE__CALCULATORS_PRINT_TYPES_SIZES_PLACES_REL_TBL."` SET place_id='".$val[1]."', print_id='".$usluga_id."' , size='".cor_data_for_SQL($val[2])."', val='".(float)$val[3]."', type='".cor_data_for_SQL($val[4])."', target='".cor_data_for_SQL($val[5])."', `default`='".(int)$val[6]."' WHERE id = '".$val[0]."'"; echo $query2; $mysqli->query($query2)or die($mysqli->error); } else{ $query2 ="INSERT INTO `".BASE__CALCULATORS_PRINT_TYPES_SIZES_PLACES_REL_TBL."` VALUES('','".(int)$val[1]."','".$usluga_id."','".cor_data_for_SQL($val[2])."','','".(float)$val[3]."','".cor_data_for_SQL($val[4])."','".cor_data_for_SQL($val[5])."','".(int)$val[6]."')"; //echo $query2; $mysqli->query($query2)or die($mysqli->error); } } header('location:'.$_SERVER['HTTP_REFERER']);// exit; } $td1 = '<td contenteditable="true">'; $td1_hidden = '<td style="display:none;">'; $td1_unedit = '<td>'; $td2 = '</td>';
} } } // foreach($data->tbl_data as $val){ $query ="SELECT*FROM `".BASE__PRINT_PLACES_TYPES_TBL."` WHERE id = '".$val[0]."'"; $result = $mysqli->query($query)or die($mysqli->error); if($result->num_rows>0){ $query2 ="UPDATE `".BASE__PRINT_PLACES_TYPES_TBL."` SET name='".cor_data_for_SQL($val[1])."', comment='".cor_data_for_SQL($val[2])."' WHERE id = '".$val[0]."'"; $mysqli->query($query2)or die($mysqli->error); } else{ $query2 ="INSERT INTO `".BASE__PRINT_PLACES_TYPES_TBL."` VALUES('','".cor_data_for_SQL($val[1])."','".cor_data_for_SQL($val[2])."')"; //echo $query2; $mysqli->query($query2)or die($mysqli->error); } } // header('location:'.$_SERVER['HTTP_REFERER']); exit; } $td1 = '<td contenteditable="true">'; $td1_hidden = '<td style="display:none;">'; $td1_grey = '<td style="color:#AEC7EC;">'; $td1_unedit = '<td>';
} } } } foreach($data->tbl_data as $val){ $query ="SELECT*FROM `".BASE__CALCULATORS_ADDITIONS."` WHERE id = '".$val[0]."'"; $result = $mysqli->query($query)or die($mysqli->error); if($result->num_rows>0){ $query2 ="UPDATE `".BASE__CALCULATORS_ADDITIONS."` SET print_id='".$usluga_id."' , type='".cor_data_for_SQL($val[1])."', title='".cor_data_for_SQL($val[2])."', value='".(float)$val[3]."', optional='".(int)$val[4]."', multi='".(int)$val[5]."', target='".cor_data_for_SQL($val[6])."' WHERE id = '".$val[0]."'"; $mysqli->query($query2)or die($mysqli->error); } else{ $query2 ="INSERT INTO `".BASE__CALCULATORS_ADDITIONS."` VALUES('','".$usluga_id."','".cor_data_for_SQL($val[1])."','".cor_data_for_SQL($val[2])."','".(float)$val[3]."','".(int)$val[4]."','".(int)$val[5]."','".cor_data_for_SQL($val[6])."')"; //echo $query2; $mysqli->query($query2)or die($mysqli->error); } } header('location:'.$_SERVER['HTTP_REFERER']); exit; } $td1 = '<td contenteditable="true">'; $td1_unedit = '<td>';
} } } } foreach($data->tbl_data as $val){ $query ="SELECT*FROM `".BASE__CALCULATORS_COEFFS."` WHERE id = '".$val[0]."'"; $result = $mysqli->query($query)or die($mysqli->error); if($result->num_rows>0){ $query2 ="UPDATE `".BASE__CALCULATORS_COEFFS."` SET print_id='".$data->print_type_id."' , type='".cor_data_for_SQL($val[1])."', title='".cor_data_for_SQL($val[2])."', percentage='".(float)$val[3]."', optional='".(int)$val[4]."', multi='".(int)$val[5]."', target='".cor_data_for_SQL($val[6])."' WHERE id = '".$val[0]."'"; $mysqli->query($query2)or die($mysqli->error); } else{ $query2 ="INSERT INTO `".BASE__CALCULATORS_COEFFS."` VALUES('','".$data->print_type_id."','".cor_data_for_SQL($val[1])."','".cor_data_for_SQL($val[2])."','".(float)$val[3]."','".(int)$val[4]."','".(int)$val[5]."','".cor_data_for_SQL($val[6])."')"; //echo $query2; $mysqli->query($query2)or die($mysqli->error); } } header('location:'.$_SERVER['HTTP_REFERER']); exit; } $usluga_id = $_GET['usluga']; $td1 = '<td contenteditable="true">'; $td1_unedit = '<td>';
} $query2 .=" WHERE id = '".$val[0]."'"; //echo $query2.'<br>';// $mysqli->query($query2)or die($mysqli->error); } else{ $query2 ="INSERT INTO `".BASE__CALCULATORS_PRICE_TABLES_TBL."` VALUES('',"; $query2.= "'".$data->print_type_id."','".$data->price_type."','".$data->level."','".$data->count."'"; for($i=1;$i<=22;$i++){ if(isset($val[$i])){ if($i==1) $query2.= ",'".(int)$val[$i]."'"; if($i==2) $query2.= ",'".cor_data_for_SQL($val[$i])."'"; if($i>=3) $query2.= ",'".(float)$val[$i]."'"; } else $query2.= ",''"; } $query2.= ")"; // echo $query2; $mysqli->query($query2)or die($mysqli->error);// } } header('location:'.$_SERVER['HTTP_REFERER']); exit; }
static function add_data_from_basket($client_id, $manager_id_arr, $customer_data = FALSE, $dop_info = FALSE) { global $mysqli; // print_r($manager_id_arr); echo '--'; exit; $user_id = $_SESSION['access']['user_id']; // $date = date('Y-m-d H:i:s'); // содержимое корзины $basket_arr = $_SESSION['basket']; //print_r($dop_info_arr); //exit; foreach ($basket_arr as $key => $basket_data) { $id = $basket_data['article']; $characteristics = array(); // выбираем из базы каталога данные об артикуле $query = "SELECT*FROM `" . BASE_TBL . "` WHERE id = '" . $id . "'"; $result = $mysqli->query($query) or die($mysqli->error); $art_data = $result->fetch_assoc(); /////////////////////////////////////////////////////////////////////////////////////////////////////////////// // получаем цвета артикула // /////////////////////////////////////////////////////////////////////////////////////////////////////////////// $query = "SELECT color FROM `" . BASE_COLORS_TBL . "` WHERE art_id ='" . $id . "' AND color<>''"; $result = $mysqli->query($query) or die($mysqli->error); while ($item = $result->fetch_assoc()) { $characteristics['colors'][] = $item['color']; } /////////////////////////////////////////////////////////////////////////////////////////////////////////////// // получаем материалы артикула // /////////////////////////////////////////////////////////////////////////////////////////////////////////////// $query = "SELECT*FROM `" . BASE_MATERIALS_TBL . "` WHERE art_id ='" . $id . "'"; $result = $mysqli->query($query) or die($mysqli->error); while ($item = $result->fetch_assoc()) { $characteristics['materials'][] = $item['material']; } require_once ROOT . "/libs/php/classes/rt_calculators_class.php"; $characteristics = count($characteristics) > 0 ? rtCalculators::json_fix_cyr(json_encode($characteristics)) : ''; //print_r($dop_info); if ($dop_info) { $data_arr[$key]['dop_info'] = $dop_info[$key]; } $data_arr[$key]['art_id'] = $basket_data['article']; $data_arr[$key]['art'] = $art_data['art']; $data_arr[$key]['type'] = 'cat'; $data_arr[$key]['name'] = $art_data['name']; $data_arr[$key]['description'] = $art_data['description']; $data_arr[$key]['characteristics'] = $characteristics; /////////////////////////////////////////////////////////////////////////////////////////////////////////////// // формируем tirage_json // /////////////////////////////////////////////////////////////////////////////////////////////////////////////// if (!empty($basket_data['size_id']) && $basket_data['size_id'] != 'undefined') { // если id размера( id строки из BASE_DOP_PARAMS_TBL) указано в корзине используем эту информацию $tirage_json = array(); $tirage_json[$basket_data['size_id']] = array("dop" => "0", "tir" => $basket_data['quantity']); $tirage_json = json_encode($tirage_json); } else { // иначе обращаемся к BASE_DOP_PARAMS_TBL и считываем данные $query = "SELECT*FROM `" . BASE_DOP_PARAMS_TBL . "` WHERE art_id ='" . $id . "'"; $result = $mysqli->query($query) or die($mysqli->error); if ($result->num_rows > 0) { $item = $result->fetch_assoc(); $tirage_json = array(); $tirage_json[$item['id']] = array("dop" => "0", "tir" => $basket_data['quantity']); $tirage_json = json_encode($tirage_json); } else { $tirage_json = '{}'; } } $data_arr[$key]['dop_data'][0]['quantity'] = $basket_data['quantity']; $data_arr[$key]['dop_data'][0]['price_out'] = $basket_data['price']; $data_arr[$key]['dop_data'][0]['tirage_json'] = $tirage_json; unset($tirage_json); /* // пока нет калькуляторов это не востребованно // это просто пример $data_arr[$key]['dop_data'][0]['dop_uslugi'][0]['glob_type'] = 'print'; $data_arr[$key]['dop_data'][0]['dop_uslugi'][0]['type'] = ''; $data_arr[$key]['dop_data'][0]['dop_uslugi'][0]['quantity'] = $basket_data['quantity']; $data_arr[$key]['dop_data'][0]['dop_uslugi'][0]['price_in'] = 1; $data_arr[$key]['dop_data'][0]['dop_uslugi'][0]['price_out'] = 10; */ } $query_num = RT::create_new_query($client_id, $manager_id_arr, $data_arr); /** * сохраняем данные введённые в форму * отправки заказа из корзины в комментарии по запросу * * @author Алексей Капитонов * @version 15:60 30.10.2015 */ // ini_set('error_reporting', E_ALL); // ini_set('display_errors', 1); // ini_set('display_startup_errors', 1); // --> START <-- // if ($customer_data) { include_once ROOT . "/libs/php/classes/comments_class.php"; $COMMENTS = new Comments_for_query_class(); $text = trim($customer_data['name']) != '' ? 'Имя: ' . $customer_data['name'] . '<br>' : ''; $text .= trim($customer_data['reg_phone']) != '' ? 'Телефон: ' . $customer_data['reg_phone'] . '<br>' : ''; $text .= trim($customer_data['email']) != '' ? 'E-mail: ' . $customer_data['email'] . '<br>' : ''; $text .= trim(cor_data_for_SQL($customer_data['coment'])) != '' ? 'Пожелания: ' . cor_data_for_SQL($customer_data['coment']) . '<br>' : ''; $COMMENTS->save_query_comment_Pub(0, $query_num, 'Клиент', $text); // --> END <-- // } return $query_num; }
} if(isset($_GET['add_rows_to_rt'])) { add_rows_to_rt(intval($_GET['id']),cor_data_for_SQL($_GET['type_row']),intval($_GET['num']),intval($_GET['control_num'])); exit; } if(isset($_GET['make_rows_changes_in_rt'])) { if($_GET['action'] == 'delete') { if(trim($_GET['id_nums_str']) != '') { delete_rows(cor_data_for_SQL($_GET['id_nums_str']),(int)$_GET['control_num']); header('Location:?'.addOrReplaceGetOnURL('','make_rows_changes_in_rt&action&id_nums_str&control_num')); exit; } } // make_rows_changes_in_rt(cor_data_for_SQL($_GET['action']),intval($_GET['num'])); exit; } ob_start(); $query = "SELECT*FROM `".CALCULATE_TBL."` WHERE `client_id` = '".$client_id."'