$cur],1,1,2); $tag = $currency->tag; $rate = $currency->rate; $iso = $currency->iso; Function select_shipping_product($db,$pro_id){ $sql="SELECT * ,shipping.id as id FROM shipping INNER JOIN list_companies_shipping ON shipping.compani_id=list_companies_shipping.id WHERE pro_id = $pro_id " ; $queryy=$db->prepare($sql); $queryy->execute(); return $employees = $queryy->fetchAll(); $queryy->CloseCursor();} function show_product_details($employees,$employe_item,$employe_option,$employe_option_val,$currency,$type) { $tag = $currency->tag; $iso = $currency->iso; $rate = $currency->rate; echo "
"; $dir = "../product_details/$employees->id/scr" ; if (is_dir($dir)) { if ($handle = opendir($dir)) { while (false !== ($entry = readdir($handle))) { if ($entry != "." && $entry != "..") { echo "
"; } } closedir($handle); } }else {echo 'لايوجد ملفات ';} echo "
"; if (is_dir($dir)) { if ($handle = opendir($dir)) { while (false !== ($entry = readdir($handle))) { if ($entry != "." && $entry != "..") { echo "
"; } } closedir($handle); } }else {echo 'لايوجد ملفات ';} if ($employees->type>2) { $price_min = formatMoney($employees->price_min*$rate) ; $price_max =formatMoney( $employees->price_max*$rate) ;} else{ $price_min = formatMoney( $employees->price_min) ; $price_max =formatMoney( $employees->price_max) ; } $uid =$_SESSION['uid']; $des = str_replace("%ID%", "$uid", $employees->des); $type_contract = $employees->type_contract; switch ($type_contract) { case "1"://eur $type_contract ='توكيل'; break; case "2"://usd $type_contract ='شراء'; break; default://DZA $type_contract ='مجهول تواصل مع دعم '; } echo "
$price_min - $price_max $tag

$des

"; $ProductId = $employees->productId; if ($_SESSION['access']==2){ echo "رابط الى المصدر";} /*------------------ for item---------------------------*/ $i=0; //print_r($employe_option_val); foreach($employe_option_val as $employee) { $option_name = $employe_option[$i]['option_name']; $typeshow = $employe_option[$i]['typeshow']; echo "
$option_name :
    "; $employe_val = $employee; // print_r($employe_val); foreach($employe_val as $emp_key => $emp_val) { $value_name = $emp_val['value_name']; if (($type==4) ){//|| ($type==5) $propertyValueIdv = $emp_val['propertyValueId'];//aliexprese $value_id = $emp_val['value_id']; } else{ $propertyValueIdv=$emp_val['value_id']; $value_id = $emp_val['value_id'];} echo ""; } /* echo " ";*/ echo "

"; $i++; } /* echo "
color :
";*/ /* foreach($employe_item as $employee) { $id=$employee['id']; $name_item=$employee['name_item']; $price_item=$employee['price_item']*$rate; echo " "; }*/ echo "

التوصيل :00.00

الوقت المقدر للتسليم : 00.00 يوم

- +
";} /*
متوفر :
$employees->count
*/ //------------------------------------------------------------- function show_ship($employees,$currency,$type) { $tag = $currency->tag; $iso = $currency->iso; $rate = $currency->rate; foreach($employees as $employee) { $id=$employee['id']; $name=$employee['name']; if ($type>2){ $price=number_format($employee['price']*$rate,2,'.',',') ; }else{ $price=number_format( $employee['price'],2,'.',',') ; } $des=$employee['des']; echo " $des day $price $tag $name " ; } } //------------------------------------------------------ $pro_id= cleanInput($_GET['pro_id']); if (!is_numeric($pro_id)){$pro_id=179;} $employees = select_where($db,'product','*',['id'=>$pro_id],1,1,2) ; $type = $employees->type; $keyword=$employees->keyword; $des=$employees->des; $employe_item = select_where($db,'product_item','*',['pro_id'=>$pro_id],1,20,1) ; $employe_ship = select_shipping_product($db,$pro_id); Function select_option_value_product($db,$pro_id){ $sql="SELECT * FROM option_product INNER JOIN option_values ON option_product.option_id=option_values.option_id WHERE product_id = $pro_id " ; $queryy=$db->prepare($sql); $queryy->execute(); return $employees = $queryy->fetchAll(PDO::FETCH_GROUP | PDO::FETCH_ASSOC); $queryy->CloseCursor();} $employe_option_val = select_option_value_product($db,$pro_id); // $results = array_map('reset', $employe_option); //print_r($employe_option); //echo json_encode($employe_option) $employe_option= select_where($db,'option_product','*',['product_id'=>$pro_id],1,20,1) ; $employe_sku= select_where($db,'product_item'," GROUP_CONCAT(id_sku) ,GROUP_CONCAT(value_arr SEPARATOR '#' ) ,GROUP_CONCAT(price_item) ,GROUP_CONCAT(name_item SEPARATOR '#'),GROUP_CONCAT(discount),GROUP_CONCAT(isActivity),GROUP_CONCAT(availQuantity) , GROUP_CONCAT(skuPropIds SEPARATOR '#' ) as skuPropIds ",['pro_id'=>$pro_id],1,90,1) ; $price_item=explode(',',$employe_sku[0][2]); $discount=explode(',', $employe_sku[0][4]); $arr_price=array(); $arr_orginal_price=array(); if ($employees->type>2){ for ($i=0; $i < count($price_item); $i++) { $dis = ($price_item[$i]*$discount[$i]) /100 ; $pr = $price_item[$i] - $dis; $arr_price[] = $pr*$rate ;//money_format $arr_orginal_price[]=$price_item[$i]*$rate ; } }else{ for ($i=0; $i < count($price_item); $i++) { $dis = ($price_item[$i]*$discount[$i]) /100 ; $pr = $price_item[$i] - $dis; $arr_price[] = $pr ; $arr_orginal_price[]=$price_item[$i]; } } //print_r ($arr_price); //echo $employees->name; //print_r($employe_sku['value_arr']); //print_r($employe_sku); //CAST(amount AS DECIMAL(10,2) ) ) //GROUP_CONCAT((price_item)*'$rate') //GROUP_CONCAT( ((price_item)*'$rate') AS DECIMAL(10,2) ) ?>
status==0){echo '';} ?> type_contract==3){ echo '';} ?>
full_des; ?>