Gecko [ www.foryou-vip.com ]

Name	Size	Permission	Date
BulkInsertions.php	5.74 KB	-rw-r--r--	2022-11-29 10:11
EquilibreData.php	2.07 KB	-rw-r--r--	2022-11-25 12:43
GetSupplierData.php	1.57 KB	-rw-r--r--	2022-10-24 10:25
InjectionScript.php	2.05 KB	-rw-r--r--	2022-11-08 12:29
InsertNewSupplier.php	5.98 KB	-rw-r--r--	2024-01-10 11:02
RefreshList.php	8.74 KB	-rw-r--r--	2022-11-17 12:58
SetData.php	4.19 KB	-rw-r--r--	2022-10-24 18:12
SetProjectContact.php	1.61 KB	-rw-r--r--	2022-11-16 10:31
SetTags.php	3.75 KB	-rw-r--r--	2022-11-09 10:41

Rename

<?php
/*========================================================================================================================
=== API ITM ==
== Refresh list insertions ==
== Date : 10/10/2022 ==
========================================================================================================================*/

$path = dirname(__FILE__) . '/';
require_once($path . "../../master.inc.php");
require_once($path . "../../projet/class/project.class.php");
// GET Society list who send the forme but they dont have any Society/Society_extrafields/Project/Project_contact/Tasks/Project_task CREATED -----------------------------------------
$sqlGetTiers = "SELECT distinct llx_societe.rowid,iform.gln1,iform.raisonsociale,iform.adresse,iform.telephone,iform.email, iform.sendingdate,iform.presta_nom,iform.redi,iform.sscc,iform.gitn,iform.eligibility,iform.startdate,iform.commentaire,month(iform.startdate) as month,year(iform.startdate) as year
FROM iform left join llx_societe on llx_societe.barcode = iform.gln1 where llx_societe.rowid is null and llx_societe.entity=5";
$resGetTiers = $db->query($sqlGetTiers);
if ($resGetTiers) {
 while ($objGetTiers= $resGetTiers->fetch_object()) {
 echo "======================================================================== ";
 if($objGetTiers->gln1){
 echo "[Supplier] Name : ".$objGetTiers->raisonsociale.' - GLN : '.$objGetTiers->gln1.' ';
 // Society CREATION -----------------------------------------
 $SocietyQuery = 'INSERT INTO `llx_societe`(`nom`, `entity`, `statut`, `status`, `address`, `phone`, `barcode`,`client`,`twitter`) 
 VALUES ("'.$objGetTiers->raisonsociale.'",5,0,1,"'.$objGetTiers->adresse.'","'.$objGetTiers->telephone.'","'.$objGetTiers->gln1.'",1,"2")';
 $resultSociety = $db->query($SocietyQuery);
 $SocietyID = $db->last_insert_id(MAIN_DB_PREFIX."societe");
 // Society extrafields CREATION -----------------------------------------
 if($objGetTiers->redi == '1'){$redi = 1;}else{$redi=4;}
 $SocietyEXTRQuery = 'INSERT INTO `llx_societe_extrafields`(`tms`, `fk_object`, `sscc`, `gtin`, `escalade`, `datetest`, `portailredi`, 
 `commentaire`, `nomprestataire`, `formulaire`, `dateenvoie`) 
 VALUES (NOW(),'.$SocietyID.',"'.$objGetTiers->sscc.'","'.$objGetTiers->gitn.'","'.$objGetTiers->eligibility.'","'.$objGetTiers->startdate.'",
 "'.$redi.'","'.$objGetTiers->commentaire.'","'.$objGetTiers->presta_nom.'","1","'.$objGetTiers->sendingdate.'")';
 $resultSocietyEXT = $db->query($SocietyEXTRQuery);
 echo "[Supplier Extrafield] ";
 $titleProject = 'DESADV - '.substr($objGetTiers->raisonsociale, 0, 10);
 $refProject = 'PR-'.$objGetTiers->gln1;
 // Project Tag CREATION -----------------------------------------
 if($objGetSC->year == '2025'){$Tag = 19;
 }else if($objGetTiers->year == '2022'){
 if($objGetTiers->month == '12'){$Tag = 6;}
 else if($objGetTiers->month == '11'){$Tag = 5;}
 else if($objGetTiers->month == '10'){$Tag = 4;}
 }else if($objGetTiers->year == '2023'){
 if($objGetTiers->month == '1'){$Tag = 7;}
 else if($objGetTiers->month == '2'){$Tag = 8;}
 else if($objGetTiers->month == '3'){$Tag = 9;}
 else if($objGetTiers->month == '4'){$Tag = 10;}
 else if($objGetTiers->month == '5'){$Tag = 11;}
 else if($objGetTiers->month == '6'){$Tag = 12;}
 else if($objGetTiers->month == '7'){$Tag = 13;}
 else if($objGetTiers->month == '8'){$Tag = 18;}
 else if($objGetTiers->month == '9'){$Tag = 14;}
 else if($objGetTiers->month == '10'){$Tag = 15;}
 else if($objGetTiers->month == '11'){$Tag = 16;}
 else if($objGetTiers->month == '12'){$Tag = 17;}
 }else{$Tag = 19;}
 $ClientTagQuery = "INSERT INTO `llx_categorie_societe`(`fk_categorie`, `fk_soc`) VALUES (".$Tag.",".$objGetTiers->rowid.")";
 $resultClientTag = $db->query($ClientTagQuery);
 echo "[Client Tag] ";
 // PROJECT CREATION -----------------------------------------
 $ProjectQuery = 'INSERT INTO llx_projet (ref, title, description, fk_soc, fk_user_creat, fk_statut, fk_opp_status, opp_percent, public, datec, dateo, datee, opp_amount, budget_amount, usage_opportunity, usage_task, usage_bill_time, usage_organize_event, note_private, note_public, entity) 
 VALUES ("'.$refProject.'", "'.$titleProject.'", "", '.$SocietyID.', 1, 1, NULL, NULL, 0, NOW(), NOW(), null, null, null, 0, 0, 0, 0, null, null, 5)';
 $resultProject = $db->query($ProjectQuery);
 echo "[Supplier Project] Title : ".$titleProject." - Ref :".$refProject." ";
 $ProjectID = $db->last_insert_id(MAIN_DB_PREFIX."projet");
 // PROJECT Contact default CREATION -----------------------------------------
 $TagQuery = "INSERT INTO `llx_element_contact` (`datecreate`, `statut`, `element_id`, `fk_c_type_contact`, `fk_socpeople`) VALUES (Now(), '4', ".$ProjectID.", '161', '4');";
 $resultContactTag = $db->query($TagQuery);
 echo "[Contact Project] Created ";
 // TASKS CREATION -----------------------------------------
 if($resultProject){
 $ProjectID = $db->last_insert_id(MAIN_DB_PREFIX."projet");
 echo "---> [SUCCESS] : Project created, ID : [".$ProjectID."] ";
 for($i=1;$i<=5;$i++){
 if($i == 1){$subject="Prise de contact";}
 if($i == 2){$subject="Relance";}
 if($i == 3){$subject="Test-MEP";}
 if($i == 4){$subject="Monitoring";}
 if($i == 5){$subject="Echanges";}
 $refTicket = 'TK-'.$objGetTiers->gln1.'-'.$i;
 $refTache = 'TA-'.$objGetTiers->gln1.'-'.$i;
 $TrackIDTicket = 'TRK-'.$objGetTiers->gln1.'-'.$i;
 echo "---> [SUCCESS] : Task created, ref : ".$refTicket." - ".$subject." ";
 echo "---> [SUCCESS] : Project Task Created, ref : ".$refTache." - ".$subject." ";
 $TaskQuery = 'INSERT INTO `llx_ticket` 
 (`entity`, `track_id`, `ref`, `fk_soc`, `fk_project`, `fk_user_create`, `subject`, `fk_statut`, `severity_code`, `datec`,`type_code`,`category_code`,`fk_user_assign`) 
 VALUES (5,"'.$TrackIDTicket.'","'.$refTicket.'",'.$SocietyID.','.$ProjectID.',1,"'.$subject.'",2,"NORMAL",NOW(),"DEPLOI","DEPLO",4)';
 $resultTicket = $db->query($TaskQuery);
 if($resultTicket){
 $TicketID = $db->last_insert_id(MAIN_DB_PREFIX."ticket");
 echo "---> [SUCCESS] : Task created, ID : ".$TicketID." - ref : ".$refTicket." - ".$subject." ";
 }else{ echo "---> [ERROR] : Task not created : ".$TaskQuery." "; }
 // PROJECT TASKS CREATION -----------------------------------------
 $ProjectTaskQuery = 'INSERT INTO `llx_projet_task` (`ref`, `entity`, `fk_projet`, `fk_task_parent`, `datec`,`tms`,`dateo`,`label`, `description`, `progress`, `priority`, `fk_user_creat`, `fk_statut`,`planned_workload`)
 VALUES ("'.$refTache.'", 5, '.$ProjectID.', 0, NOW(), NOW(), NOW(),"'.$subject.'", "", NULL, 0, 1,0,NULL)';
 $resultTache = $db->query($ProjectTaskQuery);
 if($resultTache){
 $TacheID = $db->last_insert_id(MAIN_DB_PREFIX."projet_task");
 echo "---> [SUCCESS] : Project Task Created - ID : ".$TacheID." - ref : ".$refTache." - ".$subject." ";
 }else{ echo "---> [ERROR] : Project task not created : ".$ProjectTaskQuery." "; }
 }
 }else{ echo "[ERROR] : Project not created. ";}
 }else{ echo "[ERROR] : GLN not found for this Supplier : ".$objGetTiers->raisonsociale.'. '; }
 } echo "======================================================================== ";
}else{ echo "No Supplier found."; die(); }
/*======================================================================================================================*/
?>