function client_edit_form($p_id)
{
$result = $this->mysqli->query("SELECT\n\tP_ID,\n\tP_NAME,\n\tP_SURNAME,\n\tP_PATRON,\n\tP_COMPANY,\n\tP_DETAILS,\n\tP_TEL,\n\tP_MAIL,\n\tP_CITY_ID,\n\tP_ADDR,\n\tP_ATT_ID,\n\tP_ATT_DATE,\n\tP_RATE,\n\tP_MG_ID,\n\tP_MG_A_USR_ID,\n\tP_MG_DATE,\n\tP_LOGIN,\n\tP_ACC_ID,\t\n\tP_PT_ID,\n\tP_ST,\n\tUSERS.USR_ID,\n\tUSERS.USR_SURNAME,\n\tATTRACTION_TYPES.ATT_NAME,\n\tATTRACTION_TYPES.ATT_DESC,\n\tCITY.CITY_NAME,\n\tMARGIN_GROUPS.MG_NAME,\n USERS2.USR_SURNAME as USERSURNAME,\n\tCITY2.CITY_REG_ID as CITYREG,\n\tP_CT_ID,\n\tCOMPANY_TYPES.CT_LOGO ,\n\tCOMPANY_TYPES.CT_NAME\n\tFROM PARTNERS\n\tINNER JOIN USERS ON USERS.USR_ID= PARTNERS.P_A_USR_ID\n\tINNER JOIN ATTRACTION_TYPES ON ATTRACTION_TYPES.ATT_ID = PARTNERS.P_ATT_ID\n\tINNER JOIN CITY ON CITY.CITY_ID = PARTNERS.P_CITY_ID\n\tINNER JOIN MARGIN_GROUPS ON MARGIN_GROUPS.MG_ID = PARTNERS.P_MG_ID\n INNER JOIN USERS AS USERS2 ON USERS2.USR_ID= PARTNERS.P_MG_A_USR_ID\n\tINNER JOIN CITY AS CITY2 ON CITY2.CITY_ID = PARTNERS.P_CITY_ID\n\tINNER JOIN COMPANY_TYPES ON COMPANY_TYPES.CT_ID = PARTNERS.P_CT_ID\n \n\tWHERE P_ID =" . $p_id . ";");
$row = $result->fetch_row();
if ($style == 'multitable2' or $style == '') {
$style = 'multitable1';
} else {
$style = 'multitable2';
}
$p_id = $row[0];
$p_name = $row[1];
$p_surname = $row[2];
$p_patron = $row[3];
$p_company = $row[4];
$p_details = $row[5];
$p_tel = $row[6];
$p_mail = $row[7];
$p_city_id = $row[8];
$p_addr = $row[9];
$p_att_id = $row[10];
$p_att_date = $row[11];
$p_rate = $row[12];
$p_mg_id = $row[13];
$p_mg_a_usr_id = $row[14];
$p_mg_date = $row[15];
$p_login = $row[16];
$p_acc_id = $row[17];
$p_pt_id = $row[18];
$p_st = $row[19];
$p_autor_user_id = $row[20];
$p_autor_user = $row[21];
$p_att_name = $row[22];
$p_att_desc = $row[23];
$p_town = $row[24];
$p_mg_name = $row[25];
$p_mg_a_usr_sname = $row[26];
$p_reg_id = $row[27];
$p_ct_id = $row[28];
$p_ct_logo = $row[29];
$p_ct_name = $row[30];
// combine data
$p_fio = $p_surname . " " . $p_name . " " . $p_patron;
$p_full_addr = $p_town . " ," . $p_addr;
$p_rate_msg = $p_rate;
$p_sname_input = "<input type='text' size='35' maxlength='100' onchange=\"x_cl_call2('partners','save_p_sname'," . $p_id . ",\$('#sname_p_id_" . $p_id . "').val(),'zero');\" id='sname_p_id_" . $p_id . "' class='input_text' value='" . $p_surname . "' >";
$p_name_input = "<input type='text' size='35' maxlength='100' onchange=\"x_cl_call2('partners','save_p_name'," . $p_id . ",\$('#name_p_id_" . $p_id . "').val(),'zero');\" id='name_p_id_" . $p_id . "' class='input_text' value='" . $p_name . "' >";
$p_patron_input = "<input type='text' size='35' maxlength='100' onchange=\"x_cl_call2('partners','save_p_patron'," . $p_id . ",\$('#patron_p_id_" . $p_id . "').val(),'zero');\" id='patron_p_id_" . $p_id . "' class='input_text' value='" . $p_patron . "' >";
$p_company_input = "<input type='text' size='35' maxlength='100' onchange=\"x_cl_call2('partners','save_p_company'," . $p_id . ",\$('#company_p_id_" . $p_id . "').val(),'zero');\" id='company_p_id_" . $p_id . "' class='input_text' value='" . $p_company . "' >";
$p_tel = "<input type='text' size='35' maxlength='100' onchange=\"x_cl_call2('partners','save_p_tel'," . $p_id . ",\$('#tel_p_id_" . $p_id . "').val(),'zero');\" id='tel_p_id_" . $p_id . "' class='input_text' value='" . $p_tel . "' >";
$p_mail = "<input type='text' size='35' maxlength='100' onchange=\"x_cl_call2('partners','save_p_mail'," . $p_id . ",\$('#mail_p_id_" . $p_id . "').val(),'zero');\" id='mail_p_id_" . $p_id . "' class='input_text' value='" . $p_mail . "' >";
$p_addr = "<input type='text' size='35' maxlength='100' onchange=\"x_cl_call2('partners','save_p_addr'," . $p_id . ",\$('#addr_p_id_" . $p_id . "').val(),'zero');\" id='addr_p_id_" . $p_id . "' class='input_text' value='" . $p_addr . "' >";
$p_details_input = "<textarea rows='3' cols='35' maxlength='150' onchange=\"x_cl_call2('partners','save_p_details'," . $p_id . ",\$('#details_p_id_" . $p_id . "').val(),'zero');\" id='details_p_id_" . $p_id . "' class='input_text' >" . $p_details . "</textarea>";
$p_company_type = $this->company_type_selector($p_ct_id, "x_cl_call2('partners','save_p_ct_id'," . $p_id . ",\$('#company_type_selector').val(),'zero');");
// region and city selection
$action = "onchange=\"x_cl_call3('partners','city_selector',0,\$('#region_selector').val()," . $p_id . ",'city_sel');\";";
$p_reg_selector = $this->region_selector($p_reg_id, $action);
$p_city_selector = "<div id='city_sel_div'>" . $this->city_selector($p_city_id, $p_reg_id, $p_id) . "</div>";
// manager selector
$action = "x_cl_call2('partners','save_p_manager'," . $p_id . ",\$('#users_selector').val(),zero);";
$p_mng_sel = $this->users_selector($p_autor_user_id, $action);
//margin group
$mg_action = "onchange=\"x_cl_call2('partners','change_partner_margin_group'," . $p_id . ",\$('#margin_group_selector" . $p_id . "').val(),'show_result');\"";
$p_margin_group_selector = trade::get_margin_group_selector($p_mg_id, $mg_action, $p_id);
// attractions
$att_action = "onchange=\"x_cl_call2('partners','change_att_type'," . $p_id . ",\$('#attraction_type_selector').val(),'show_result');\";";
$att_selector = $this->attraction_type_selector($p_att_id, $att_action);
//user data form
$user_data_form = "\n\t<div align='center'>Карточка клиента #" . $p_id . "</div>\n\t<table class='multitable'>\n\t<tr><td>Кампания</td><td>" . $p_company_input . "</td></tr>\n\t<tr><td>Тип</td><td>" . $p_company_type . "</td></tr>\n\t<tr><td>Фамилия</td><td>" . $p_sname_input . "</td></tr>\n\t<tr><td>Имя</td><td>" . $p_name_input . "</td></tr>\n\t<tr><td>Отчество</td><td>" . $p_patron_input . "</td></tr>\n\t<tr><td>Телефон</td><td>" . $p_tel . "</td></tr>\n\t<tr><td>Почта</td><td>" . $p_mail . "</td></tr>\n\t<tr><td>Область,город</td><td>" . $p_reg_selector . $p_city_selector . "</td></tr>\n\t<tr><td>Адрес</td><td>" . $p_addr . "</td></tr>\n\t<tr><td>Примечание</td><td>" . $p_details_input . "</td></tr>\n\t<tr><td>Менеджер </td><td>" . $p_mng_sel . "</td></tr>\n\t<tr><td>Привлечение</td><td>" . date("d.m.Y", strtotime($p_att_date)) . " " . $att_selector . "</td></tr>\n\t<tr><td>Группа наценки</td><td>" . $p_margin_group_selector . "<br><b>" . $p_mg_a_usr_sname . "</b> " . date("d.m.Y", strtotime($p_mg_date)) . "</td></tr>\n\t</table>";
// user statistic form
$mg_action = "onchange=\"x_cl_call2('partners','change_partner_margin_group'," . $p_id . ",\$('#margin_group_selector" . $p_id . "').val(),'show_result');\"";
$p_margin_group_selector = trade::get_margin_group_selector($p_mg_id, $mg_action, $p_id);
// attractions
$att_action = "onchange=\"x_cl_call2('partners','change_att_type'," . $p_id . ",\$('#attraction_type_selector').val(),'show_result');\";";
$att_selector = $this->attraction_type_selector($p_att_id, $att_action);
// list deals
$result = $this->mysqli->query("SELECT COUNT(*) FROM DEALS WHERE D_DT_ID=4 AND D_2P_ID=" . $p_id . ";");
$row = $result->fetch_row();
$p_lists_but = "\n<button onclick=\"\$('#main_ds').val('bottom_block');x_cl_call2('partners','partner_deals','4','" . $p_id . "','show_result');\"><img class='menu_img' src='/img/site/order-1.png'> Спецификации - " . $row[0] . "</button>";
$trig = +$row[0];
// invoice <button $action > Счета </button>
$result = $this->mysqli->query("SELECT COUNT(*) FROM DEALS WHERE D_DT_ID=5 AND D_2P_ID=" . $p_id . ";");
$row = $result->fetch_row();
$p_invoice_but = "\n<button onclick=\"\$('#main_ds').val('bottom_block');x_cl_call2('partners','partner_deals','5','" . $p_id . "','show_result');\"> <img class='menu_img' src='/img/site/invoice.png'> Счета - " . $row[0] . " </button>";
$trig = +$row[0];
$result = $this->mysqli->query("SELECT COUNT(*) FROM DEALS WHERE D_DT_ID=6 AND D_2P_ID=" . $p_id . ";");
$row = $result->fetch_row();
$p_sellings_but = "\n<button onclick=\"\$('#main_ds').val('bottom_block');x_cl_call2('partners','partner_deals','6','" . $p_id . "','show_result');\"><img class='menu_img' src='/img/site/finished-work.png'> Проведённые - " . $row[0] . "</button>";
$trig = +$row[0];
if (!$trig) {
$p_hide_actions = "\n\n\t\t<tr><td>Действия</td><td><button onclick=\"x_cl_call2('partners','save_p_status'," . $p_id . ",1,'zero');\">Убрать покупателя</button></td></tr>";
}
$cli_deals_but = "";
$report_buttons .= "<button onclick=\"\$('#main_ds').val('bottom_block');x_cl_call3('reports','products_by_date_partner','" . $p_id . "',\$('#date_from').val(),\$('#date_to').val(),'show_result');\"><img class='menu_img' src='/img/site/statistics.png'> Товары за период</button>";
$user_statistic_form = "\n\t<div align='center'>Статистика</div>\n\t<table class='multitable' >\n\t<tr><td>Cделки </td><td>" . $p_lists_but . $p_invoice_but . $p_sellings_but . "</td></tr>\n\t<tr><td>Отчёты</td><td> \n\t\t<table cellspacing=0 cellpadding=0>\n\t\t<tr ><td>" . $this->date_selector(0, 0) . "</td><td>" . $report_buttons . "</td></tr>\n\t\t</table>\n\t</td></tr>\n\t" . $p_hide_actions . "\n\t</table>\n\t";
$out = "\n\t\t<table width=100% cellspacing=0><tr valign=top>\n\t\t<td width=30%><div id='left_param_block' class='left_param_block'>" . $user_data_form . "</div></td>\n\t\t<td width=70%><div id='right_param_block' class='right_param_block'>" . $user_statistic_form . "</div></td>\n\t\t</tr></table>\n\t\t<div id='bottom_block' class='bottom_block'></div>";
return $out;
}
