Gecko [ www.foryou-vip.com ]

Name	Size	Permission	Date
ca_carrefour	[ DIR ]	drwxr-xr-x	2025-11-08 11:16
vraiscript	[ DIR ]	drwxr-xr-x	2025-11-08 11:16
byratecountry.php	17.88 KB	-rwxr-xr-x	2021-01-30 17:41
ca_custom_csv.php	9.11 KB	-rwxr-xr-x	2021-03-24 12:26
cabyprodserv.php	16.2 KB	-rwxr-xr-x	2021-03-24 23:43
cabyprodserv.php_NEW	16.27 KB	-rwxr-xr-x	2021-03-24 15:27
cabyuser.php	17.36 KB	-rwxr-xr-x	2021-01-30 17:41
carrefour_file.php	11.41 KB	-rwxr-xr-x	2021-03-24 23:35
casoc.php	22.38 KB	-rwxr-xr-x	2021-01-30 17:41
file_carrefour_download.csv	2.53 KB	-rwxr-xr-x	2021-03-24 12:26
index.php	23.3 KB	-rwxr-xr-x	2021-01-30 17:41
supplier_turnover.php	16.77 KB	-rwxr-xr-x	2021-01-30 17:41
supplier_turnover_by_prodserv.php	15.49 KB	-rwxr-xr-x	2021-01-30 17:41
supplier_turnover_by_thirdparty.php	20.31 KB	-rwxr-xr-x	2021-01-30 17:41

Rename

<?php
$sapi_type = php_sapi_name();
$script_file = basename(__FILE__);
$path=dirname(__FILE__).'/';

// Test if batch mode
if (substr($sapi_type, 0, 3) == 'cgi') {
  //  echo "Error: You are using PHP for CGI. To execute ".$script_file." from command line, you must use PHP for CLI mode.\n";
  //  exit;
}

// Global variables
$version='1.10';
$error=0;
// Include Dolibarr environment
require_once("../../master.inc.php");
//include_once DOL_DOCUMENT_ROOT.'/core/lib/company.lib.php';

// After this $db, $mysoc, $langs and $conf->entity are defined. Opened handler to database will be closed at end of file.

//$langs->setDefaultLang('en_US'); 	// To change default language of $langs
$langs->load("main");				// To load language file for default language
@set_time_limit(0);

// Load user and its permissions
$result=$user->fetch('','admin');	// Load user for login 'admin'. Comment line to run as anonymous user.
if (! $result > 0) { dol_print_error('',$user->error); exit; }
$user->getrights();

$cat_id = "";
$date_s = "";
$date_e = "";
$delis = "";

if($_REQUEST['delfile']=="1" && isset($_REQUEST['delfile']))
{
	unlink(getcwd()."/file_carrefour_download.csv");
	die();
}

if((isset($_REQUEST['cat_id']) && $_REQUEST['cat_id']!="") && (isset($_REQUEST['date_s']) && $_REQUEST['date_s']!="") && (isset($_REQUEST['date_e']) && $_REQUEST['date_e']!=""))
{
	if(file_exists(getcwd().'/file_carrefour_download.csv'))
	{
		unlink(getcwd()."/file_carrefour_download.csv");
	}
	$cat_id = $_REQUEST['cat_id'];
	$date_s = $_REQUEST['date_s'];
	$date_e = $_REQUEST['date_e'];
	$delis = $_REQUEST['delis'];
	
	if($cat_id == 5)
	{
		if($delis == 6)
		{
			$products = array(
				array("barcode"=>"3760184010789","idcarrefour"=>"6157071","nomprdt"=>"180G BRICK DE POULET"),
				array("barcode"=>"3760184010796","idcarrefour"=>"6157075","nomprdt"=>"210G SAMOSA POULET TIKA"),
				array("barcode"=>"3760184010802","idcarrefour"=>"6218967","nomprdt"=>"180G BOUCHEE VAPEUR HACAO"),
				array("barcode"=>"3760184010833","idcarrefour"=>"6219675","nomprdt"=>"200G BROCHETTE POULET YAKITORI"),
				array("barcode"=>"3760184010642","idcarrefour"=>"6219676","nomprdt"=>"240G NAAN FROMAGE"),
				array("barcode"=>"3760184010819","idcarrefour"=>"6219677","nomprdt"=>"180G RAVIOLI VAPEUR GYOZA"),
				array("barcode"=>"3760184010659","idcarrefour"=>"6219678","nomprdt"=>"240G GALETTE FOURREE"),
				array("barcode"=>"3760184010826","idcarrefour"=>"6219679","nomprdt"=>"240G BROCHETTE POULET SATAY")
			);
		
			$header = "PERIODE;FOURNISSEUR;NOM FOURNISSEUR;REGROUPEMENT;LIBELLE RGP;CA MENSUEL;QTE EN UVC;VOLUME;UNITE;TMP MENSUEL EN % HORS RPP;TMP CUMULE EN % HORS RPP;COMMENTAIRES;EAN13;CDBASE;LIBELLE PRODUIT;CA MENSUEL;QTE EN UVC;VOLUME;UNITE;COMMENTAIRES";
			$body 		= "";
			$totalca	= 0;
			$totqtyuvc	= 0;
			$totvolume	= 0;
			$totunite	= "";
			$i=0;
			foreach($products as $prdt)
			{
				
				//print $prdt['barcode']." - ".$prdt['nomprdt']." ";
				
				$sql = "
				SELECT DISTINCT p.rowid as rowid,p.ref as ref, p.label as label, p.barcode as barcode,
				p.weight as weight,SUM(l.qty) as qty, sum(l.total_ht) as amount, sum(l.total_ttc) as amount_ttc, 
				pef.pieces_produit 
				FROM llx_facture as f, llx_facturedet as l, llx_product as p, llx_societe as s, llx_categorie_societe as cs, llx_categorie as c, llx_categorie_product as cp, llx_product_extrafields as pef 
				WHERE p.rowid=pef.fk_object AND s.rowid=f.fk_soc AND s.rowid=cs.fk_societe AND cs.fk_categorie='5' 
				AND p.barcode='".$prdt['barcode']."' 
				AND l.fk_product = p.rowid AND l.fk_facture = f.rowid 
				AND f.fk_statut in (1,2) AND f.type IN (0,1,2,3) 
				AND f.datef >= '".$date_s."' AND f.datef <= '".$date_e."' 
				AND (c.rowid = 6) AND cp.fk_categorie = c.rowid 
				AND cp.fk_product = p.rowid AND f.entity = ".$conf->entity." GROUP BY p.rowid ORDER BY p.ref
				";
				$res = $db->query($sql);
				$ans = $db->fetch_array($res);
				if($i==0)
				{
					$body .= "".$prdt['barcode'].";".$prdt['idcarrefour'].";".$prdt['nomprdt'].";".round($ans['amount'],0).";".($ans['qty']*$ans['pieces_produit']).";".round(($ans['weight']*$ans['qty']),0).";".$ans['qty'].";__";
				}
				else
				{
					$body .= ";;;;;;;;;;;;".$prdt['barcode'].";".$prdt['idcarrefour'].";".$prdt['nomprdt'].";".round($ans['amount'],0).";".($ans['qty']*$ans['pieces_produit']).";".round(($ans['weight']*$ans['qty']),0).";".$ans['qty'].";__";
				}
				
				$totalca 	= $totalca 	 + 	round($ans['amount'],0);
				$totqtyuvc	= $totqtyuvc + 	($ans['qty']*$ans['pieces_produit']);
				$totvolume	= $totvolume + 	round(($ans['weight']*$ans['qty']),0);
				
				$i++;

}
			$info_total 	= "". substr($date_s,0,6) .";68204;ASIA FOOD CO SAS;".(($cat_id==5)?'01':'02').";GMS SURGELES MN DELIS WORLD;".$totalca.";".$totqtyuvc.";".$totvolume.";".$totunite.";0.0;0.0;;";
			$STRING = $header."__".$info_total.substr($body,0,-2);
			$FILE_NAME 		= "file_carrefour_download.csv";
			$FILE_FULL_PATH = getcwd()."/".$FILE_NAME;

$STRING_TAB		= EXPLODE("__", $STRING);
			
			//$f = fopen('php://output', 'w');
			$f = fopen($FILE_FULL_PATH, 'w');
			foreach ($STRING_TAB as $fields)
			{	
				//print $fields." ";
				fputcsv($f, explode(';', str_replace('"','',$fields) ),";" );
			}
			fseek($f, 0);
			foreach ($STRING_TAB as $fields)
			{
				//print $fields."\n";
			}
			fpassthru($f);
			fclose($f);
		
		}
		else
		{
			$products = array(
				array("barcode"=>"3760184010017","idcarrefour"=>"4789195","nomprdt"=>"400G M'SEMEN OUMMI"),
				array("barcode"=>"3760184010048","idcarrefour"=>"4789201","nomprdt"=>"360G M'HAJEB OUMMI"),
				array("barcode"=>"3760184010673","idcarrefour"=>"5824935","nomprdt"=>"400G PIZZA BOLOGNAISE HALAL"),
				array("barcode"=>"3760184010666","idcarrefour"=>"5825172","nomprdt"=>"400GR PIZZA ROYALE HALAL"),
				array("barcode"=>"3760184010130","idcarrefour"=>"5949145","nomprdt"=>"360G MINI MSEMEN OUMMI"),
				array("barcode"=>"3760184010727","idcarrefour"=>"5949151","nomprdt"=>"500GR TENDERS DE POULET HALAL"),
				array("barcode"=>"3760184010604","idcarrefour"=>"5949153","nomprdt"=>"1,6KG CREPE FEUILLETEE OUMMI"),
				array("barcode"=>"3760184010581","idcarrefour"=>"5949154","nomprdt"=>"400GR CREPE FEUILLETEE OUMMI"),
				array("barcode"=>"3760184010703","idcarrefour"=>"5949372","nomprdt"=>"500GR NUGGETS DE POULET HALAL"),
				array("barcode"=>"3760184010710","idcarrefour"=>"5949373","nomprdt"=>"500GR CORDON BLEU DE PLT HALAL"),
				array("barcode"=>"5060100301877","idcarrefour"=>"5949375","nomprdt"=>"600G ROULEAUX NEMS PLT HALAL"),
				array("barcode"=>"5060100305356","idcarrefour"=>"5949377","nomprdt"=>"330G SAMOSSA POULET HALAL"),
				array("barcode"=>"5060100305417","idcarrefour"=>"5949411","nomprdt"=>"330G ROULEAUX NEMS PLT HALAL"),
				array("barcode"=>"5060100305462","idcarrefour"=>"5949415","nomprdt"=>"330G SAMOSSA POULET TIKA HALAL"),
				array("barcode"=>"5060100305400","idcarrefour"=>"5949417","nomprdt"=>"330G ROULEAUX NEMS BOEUF HALAL"),
				array("barcode"=>"5060100301822","idcarrefour"=>"5949419","nomprdt"=>"600G SAMOSSA POULET HALAL"),
				array("barcode"=>"5060100305349","idcarrefour"=>"5949420","nomprdt"=>"330G SAMOSSA BOEUF HALAL"),
				array("barcode"=>"5060100305455","idcarrefour"=>"5949422","nomprdt"=>"480G PIZZA PLT PERI PERI HALAL"),
				array("barcode"=>"5060100300832","idcarrefour"=>"5957158","nomprdt"=>"480G PIZZA POULET TIKA HALAL"),
				array("barcode"=>"3760184010789","idcarrefour"=>"6157071","nomprdt"=>"180G BRICK DE POULET"),
				array("barcode"=>"3760184010796","idcarrefour"=>"6157075","nomprdt"=>"210G SAMOSA POULET TIKA"),
				array("barcode"=>"3760184010628","idcarrefour"=>"6279764","nomprdt"=>"270G NAAN FROMAGE OUMMI"),
				array("barcode"=>"3760184010758","idcarrefour"=>"6279765","nomprdt"=>"250G FEUILLE DE BRICK OUMMI"),
				array("barcode"=>"3760184010765","idcarrefour"=>"6283516","nomprdt"=>"270G BRICK AU POULET OUMMI"),
				array("barcode"=>"3760184010994","idcarrefour"=>"6463134","nomprdt"=>"180G MSEMEN CHOCOLAT OUMMI"),
				array("barcode"=>"3760184010963","idcarrefour"=>"6463135","nomprdt"=>"180G MSEMEN GOURMAND OUMMI"),
				array("barcode"=>"3760184010956","idcarrefour"=>"6463136","nomprdt"=>"240G CREPE MILLE TROU OUMMI"),
				array("barcode"=>"3760184010925","idcarrefour"=>"6532275","nomprdt"=>"200GR TOAST PANINI MEXICANO"),
				array("barcode"=>"3760184010949","idcarrefour"=>"6532306","nomprdt"=>"200GR TOAST PANINI TARTIFLETTE"),
				array("barcode"=>"3760184011120","idcarrefour"=>"6699975","nomprdt"=>"BUN'S BURGER 400GR ITAL'AL"),
				array("barcode"=>"3760184011113","idcarrefour"=>"6699976","nomprdt"=>"BUN'S JAMBON KETCHUP 400GR ITA")

);
			
			$header = "PERIODE;FOURNISSEUR;NOM FOURNISSEUR;REGROUPEMENT;LIBELLE RGP;CA MENSUEL;QTE EN UVC;VOLUME;UNITE;TMP MENSUEL EN % HORS RPP;TMP CUMULE EN % HORS RPP;COMMENTAIRES;EAN13;CDBASE;LIBELLE PRODUIT;CA MENSUEL;QTE EN UVC;VOLUME;UNITE;COMMENTAIRES";
			//$info_product	= "3760184010017;4789195;400G M'SEMEN OUMMI;3934;650;1248;130;";
			
			//print_r($products);
			$body 		= "";
			$totalca	= 0;
			$totqtyuvc	= 0;
			$totvolume	= 0;
			$totunite	= "";
			$i=0;
			foreach($products as $prdt)
			{
				
				//print $prdt['barcode']." - ".$prdt['nomprdt']." ";
				
				$sql = "
				SELECT DISTINCT p.rowid as rowid,p.ref as ref, p.label as label, p.barcode as barcode, 
				p.weight as weight,SUM(l.qty) as qty, sum(l.total_ht) as amount, sum(l.total_ttc) as amount_ttc, 
				pef.pieces_produit
				FROM llx_facture as f, llx_facturedet as l, llx_product as p, llx_societe as s, llx_categorie_societe as c, llx_product_extrafields as pef
				WHERE p.rowid=pef.fk_object AND s.rowid=f.fk_soc AND s.rowid=c.fk_soc AND c.fk_categorie='".$cat_id."'
				AND p.barcode='".$prdt['barcode']."' 
				AND l.fk_product = p.rowid AND l.fk_facture = f.rowid AND f.fk_statut in (1,2) 
				AND f.type IN (0,1,2,3) AND f.datef >= '".$date_s."' AND f.datef <= '".$date_e."' 
				AND f.entity = ".$conf->entity." GROUP BY p.rowid ORDER BY p.ref 
				";
				
				//print $sql." ";
				
				$res = $db->query($sql);
				$ans = $db->fetch_array($res);
					
				//$info_product	= "3760184010017;4789195;400G M'SEMEN OUMMI;3934;650;1248;130;";
				if($i==0)
				{
					$body .= "".$prdt['barcode'].";".$prdt['idcarrefour'].";".$prdt['nomprdt'].";".round($ans['amount'],0).";".($ans['qty']*$ans['pieces_produit']).";".round(($ans['weight']*$ans['qty']),0).";".$ans['qty'].";__";
				}
				else
				{
					$body .= ";;;;;;;;;;;;".$prdt['barcode'].";".$prdt['idcarrefour'].";".$prdt['nomprdt'].";".round($ans['amount'],0).";".($ans['qty']*$ans['pieces_produit']).";".round(($ans['weight']*$ans['qty']),0).";".$ans['qty'].";__";
				}
				
				$totalca 	= $totalca 	 + 	round($ans['amount'],0);
				$totqtyuvc	= $totqtyuvc + 	($ans['qty']*$ans['pieces_produit']);
				$totvolume	= $totvolume + 	round(($ans['weight']*$ans['qty']),0);
				
				$i++;

}
			$info_total 	= "". substr($date_s,0,6) .";68204;ASIA FOOD CO SAS;".(($cat_id==5)?'01':'02').";GMS SURGELES MN;".$totalca.";".$totqtyuvc.";".$totvolume.";".$totunite.";0.0;0.0;;";

$STRING = $header."__".$info_total.substr($body,0,-2);
			
			$FILE_NAME 		= "file_carrefour_download.csv";
			$FILE_FULL_PATH = getcwd()."/".$FILE_NAME;

$STRING_TAB		= EXPLODE("__", $STRING);
			
			//print("<pre>".print_r($STRING_TAB,true)."</pre>");
			
			//$f = fopen('php://output', 'w');
			$f = fopen($FILE_FULL_PATH, 'w');
			foreach ($STRING_TAB as $fields)
			{	
				//print $fields." ";
				fputcsv($f, explode(';', str_replace('"','',$fields) ),";" );
			}
			fseek($f, 0);
			foreach ($STRING_TAB as $fields)
			{
				//print $fields."\n";
			}
			fpassthru($f);
			fclose($f);
		}
		
	}
	
}