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
/*========================================================================================================================
== Bulk insertions ==
== Date : 10/10/2022 ==
==========================================================================================================================
 Creation of : 
 - 1 Project for each Client(Tiers)
 - 5 Tickets for each Project attached to a client (Prise de contact, Relance, Test-MEP, Monitoring, Echanges)
 - 5 Taches for each Project attached to a client (Prise de contact, Relance, Test-MEP, Monitoring, Echanges)
/*======================================================================================================================*/
$path = dirname(__FILE__) . '/';
require_once($path . "../../master.inc.php");
require_once($path . "../../projet/class/project.class.php");
$sqlGetTiers = "SELECT rowid,barcode,nom,tms FROM `llx_societe` WHERE `entity` = 5 and rowid = 8710"; //"SELECT rowid,barcode,nom FROM `llx_societe` WHERE `entity` = 5";
$resGetTiers = $db->query($sqlGetTiers);
if ($resGetTiers) {
 while ($objGetTiers= $resGetTiers->fetch_object()) {
 echo "======================================================================== ";
 if($objGetTiers->barcode){
 echo "[Supplier] Name : ".$objGetTiers->nom.' - GLN : '.$objGetTiers->barcode.' - ID : '.$objGetTiers->rowid.' ';
 $titleProject = 'DESADV - '.substr($objGetTiers->nom, 0, 10);
 $refProject = 'PR-'.$objGetTiers->barcode;
 // BULK PROJECTS CREATION - Creation des projets en masse -----------------------------------------
 $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);
 if($resultProject){
 $ProjectID = $db->last_insert_id(MAIN_DB_PREFIX."projet");
 echo "---> [SUCCESS] : Project created, ID : [".$ProjectID."] ";
 // 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 ";
 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;
 // BULK TASKS CREATION - Creation des tickets en masse -----------------------------------------
 $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] : Task created, ID : ".$TicketID." - ref : ".$refTicket." - ".$subject." ";
 }else{ echo "---> [ERROR] : Task not created : ".$TaskQuery." "; }
 // BULK PROJECT TASKS CREATION - Creation des taches en masse-----------------------------------------
 $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->nom.' - ID : '.$objGetTiers->rowid.' '; }
 } echo "======================================================================== ";
}else{ echo "No Supplier found."; die(); }
/*======================================================================================================================*/
?>