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 was already created manually without any project/tasks or tickets attached -----------------------------------------
$sqlGetTiers = "SELECT llx_societe.rowid, llx_societe.nom, llx_societe.barcode FROM llx_societe LEFT JOIN llx_projet ON llx_societe.rowid = llx_projet.fk_soc WHERE llx_projet.rowid IS NULL and llx_societe.entity= 5 and llx_societe.barcode != ''";
$resGetTiers = $db->query($sqlGetTiers);
if ($resGetTiers) {
 while ($objGetTiers= $resGetTiers->fetch_object()) {
 echo "======================================================================== ";
 if($objGetTiers->barcode){
 echo "[Supplier] Name : ".$objGetTiers->nom.' - GLN : '.$objGetTiers->barcode.' ';
 // PROJECT CREATION -----------------------------------------
 $titleProject = 'DESADV - '.substr($objGetTiers->nom, 0, 10);
 $refProject = 'PR-'.$objGetTiers->barcode;
 $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.'", "", '.$objGetTiers->rowid.', 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->barcode.'-'.$i;
 $refTache = 'TA-'.$objGetTiers->barcode.'-'.$i;
 $TrackIDTicket = 'TRK-'.$objGetTiers->barcode.'-'.$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.'",'.$objGetTiers->rowid.','.$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] : Ticket created, ID : ".$TicketID." - ref : ".$refTicket." - ".$subject." ";
 }else{ echo "---> [ERROR] : Ticket 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] : Task Created - ID : ".$TacheID." - ref : ".$refTache." - ".$subject." ";
 }else{ echo "---> [ERROR] : Task not created : ".$ProjectTaskQuery." "; }
 }
 }else{ echo "[ERROR] : Project not created. ";}
 }else{ echo "[ERROR] : GLN not found for this Supplier : ".$objGetTiers->nom.'. '; }
 } echo "======================================================================== [WARNING] : We didn't found any new supplier without his project/tasks/tickets ========================================================================";
}else{ echo "No Supplier found."; die(); }
/*======================================================================================================================*/
?>