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."'
