SELECT di.sku,di.nom,di.couleur ,s.name as size, m.name_model as modele_nom , m.id_model as modele_id , ma.name as marque_nom ,ma.id_mark as marque_id,di.qty,di.sexe,prix,di.etiquette,di.combined_width, di.warranty,di.prescription FROM product_simple as di inner join models as m on m.name_model=di.modele_nom inner join mark as ma on ma.name = di.marque_nom...
Category: MY PROJET
MY PROJET
check etiquette perdu script
$p_simple = DB::table('product_simple')->get(); foreach ($p_simple as $s) { $sku = $s->sku; $etiquette = $s->etiquette; $update_p = (array)DB::table('db_update')->where('sku', $s->sku)->get(); $new_label = ""; $new_label_arr = explode(',', $etiquette); $lost_label = array(); $exit_label=array(); foreach ($update_p as $u) { if ($u->qty === null && $u->etiquette...
MY PROJET
check product not only update qty to zero but also not deactivate
DATA CENTER SQL select * from product_simple where sku not in( select s.sku from product_simple as s inner join db_update as u on u.sku= s.sku where s.qty =0 and u.qty=0 )and sku not in( select s.sku from product_simple as s...