function fetch_rows_from_rt($query_num){
global $mysqli;
global $Position_no_catalog;
$rows = array();
$query = "SELECT main_tbl.id AS main_id ,main_tbl.type AS main_row_type ,main_tbl.art_id AS art_id ,main_tbl.art AS art ,main_tbl.name AS item_name ,main_tbl.master_btn AS master_btn , main_tbl.svetofor_display AS svetofor_display ,
dop_data_tbl.id AS dop_data_id , dop_data_tbl.row_id AS dop_t_row_id , dop_data_tbl.quantity AS dop_t_quantity , dop_data_tbl.price_in AS dop_t_price_in , dop_data_tbl.price_out AS dop_t_price_out , dop_data_tbl.discount AS dop_t_discount , dop_data_tbl.row_status AS row_status, dop_data_tbl.glob_status AS glob_status, dop_data_tbl.expel AS expel, dop_data_tbl.shipping_date AS shipping_date,dop_data_tbl.shipping_type AS shipping_type, dop_data_tbl.shipping_time AS shipping_time, dop_data_tbl.status_snab AS status_snab, dop_data_tbl.dop_men_text AS dop_men_text,
dop_uslugi_tbl.id AS uslgi_t_id ,dop_uslugi_tbl.other_name AS uslugi_t_other_name ,dop_uslugi_tbl.uslugi_id AS uslgi_t_uslugi_id ,dop_uslugi_tbl.dop_row_id AS uslugi_t_dop_row_id ,dop_uslugi_tbl.type AS uslugi_t_type ,
dop_uslugi_tbl.glob_type AS uslugi_t_glob_type , dop_uslugi_tbl.quantity AS uslugi_t_quantity , dop_uslugi_tbl.price_in AS uslugi_t_price_in , dop_uslugi_tbl.price_out AS uslugi_t_price_out, dop_uslugi_tbl.discount AS uslugi_t_discount , dop_uslugi_tbl.for_how AS uslugi_t_for_how , dop_uslugi_tbl.print_details AS uslugi_t_print_details
FROM
`".RT_MAIN_ROWS."` main_tbl
LEFT JOIN
`".RT_DOP_DATA."` dop_data_tbl ON main_tbl.id = dop_data_tbl.row_id
LEFT JOIN
`".RT_DOP_USLUGI."` dop_uslugi_tbl ON dop_data_tbl.id = dop_uslugi_tbl.dop_row_id
WHERE main_tbl.query_num ='".$query_num."' ORDER BY main_tbl.sort,dop_data_tbl.id";
// echo $query;
$result = $mysqli->query($query) or die($mysqli->error);
$multi_dim_arr = array();
while($row = $result->fetch_assoc()){
if(!isset($multi_dim_arr[$row['main_id']])){
$multi_dim_arr[$row['main_id']]['row_type'] = $row['main_row_type'];
$multi_dim_arr[$row['main_id']]['master_btn'] = $row['master_btn'];
$multi_dim_arr[$row['main_id']]['art_id'] = $row['art_id'];
$multi_dim_arr[$row['main_id']]['art'] = $row['art'];
$multi_dim_arr[$row['main_id']]['name'] = $row['item_name'];
$multi_dim_arr[$row['main_id']]['svetofor_display'] = $row['svetofor_display'];
if($row['main_row_type']=='cat'){
$data = RT::getArtRelatedPrintInfo($row['art_id']);
$multi_dim_arr[$row['main_id']]['dop_details'] = $data;
}
}
//$multi_dim_arr[$row['main_id']]['uslgi_t_id'][] = $row['uslgi_t_id'];
if(isset($multi_dim_arr[$row['main_id']]) && !isset($multi_dim_arr[$row['main_id']]['dop_data'][$row['dop_data_id']]) &&!empty($row['dop_data_id'])){
$multi_dim_arr[$row['main_id']]['dop_data'][$row['dop_data_id']] = array(
'expel' => $row['expel'],
'shipping_date' => $row['shipping_date'],
'shipping_type' => $row['shipping_type'],
'shipping_time' => $row['shipping_time'],
'row_status' => $row['row_status'],
'glob_status' => $row['glob_status'],
'status_snab' => $row['status_snab'],
'dop_men_text_class' => ($row['dop_men_text']!='')?'filled':'empty',
'quantity' => $row['dop_t_quantity'],
'discount' => $row['dop_t_discount'],
'price_in' => $row['dop_t_price_in'],
'price_out' => $row['dop_t_price_out']);
}
if(isset($multi_dim_arr[$row['main_id']]['dop_data'][$row['dop_data_id']]) && !empty($row['uslgi_t_id'])){
$multi_dim_arr[$row['main_id']]['dop_data'][$row['dop_data_id']]['dop_uslugi'][$row['uslugi_t_glob_type']][$row['uslgi_t_id']] = array(
'type' => $row['uslugi_t_type'],
'id' => $row['uslgi_t_id'],
'uslugi_id' => $row['uslgi_t_uslugi_id'],
'quantity' => $row['uslugi_t_quantity'],
'other_name' => $row['uslugi_t_other_name'],
'price_in' => $row['uslugi_t_price_in'],
'price_out' => $row['uslugi_t_price_out'],
'discount' => $row['uslugi_t_discount'],
'for_how' => $row['uslugi_t_for_how'],
'print_details' => $row['uslugi_t_print_details']
);
}
//print_r( $multi_dim_arr[$row['main_id']]['dop_data'][$row['dop_data_id']]['print_data']); echo "<br>";
$rows[]= '<tr><td>'.implode('</td><td>',$row).'</td></tr>';
}
return array($multi_dim_arr,$rows);
}
