// DROITS $query = "INSERT INTO users_permissions (ref_user,id_permission,value) SELECT DISTINCT '" . $ENTREPRISE_USER['ref_user'] . "',id_permission,'ALL' FROM permissions;"; $bdd->exec($query); $query = "DELETE FROM users_permissions WHERE id_permission IN (42,43);"; $bdd->exec($query); //FONCTIONS $query = "INSERT INTO annu_collab_fonctions (ref_contact, id_fonction)\r\n\t\t\t\t\t\tVALUES ('" . $ENTREPRISE_REF_CONTACT . "', '1')"; $bdd->exec($query); // ************************************************************************************************************* // CREATION DU STOCK ET MAGASIN $query = "INSERT INTO stocks (id_stock, lib_stock, ref_adr_stock, actif, abrev_stock)\r\n\t\t\t\t\t\tVALUES (1, 'Stock principal', '" . $ENTREPRISE_ADRESSES[0]['ref_adresse'] . "', 1, 'Stock')"; $bdd->exec($query); $nom_entreprise = str_replace(CHR(13), " ", str_replace(CHR(10), " ", $ENTREPRISE_NOM)); $query = "REPLACE INTO `magasins_enseignes` (\r\n\t\t\t\t\t\t`id_mag_enseigne` ,\r\n\t\t\t\t\t\t`lib_enseigne`\r\n\t\t\t\t\t\t)\r\n\t\t\t\t\t\tVALUES (\r\n\t\t\t\t\t\t'1' , '" . $nom_entreprise . "'\r\n\t\t\t\t\t\t);"; $bdd->exec($query); $bdd->Commit(); //mise à jour des textes de bas de page des pdf maj_configuration_file("config_generale.inc.php", "maj_line", "\$PIED_DE_PAGE_GAUCHE_0 =", "\$PIED_DE_PAGE_GAUCHE_0 = \"" . addslashes(stripslashes(str_replace("\n", " ", $ENTREPRISE_NOM) . " - " . str_replace("\n", " ", $ENTREPRISE_ADRESSES[0]['text_adresse']) . " " . $ENTREPRISE_ADRESSES[0]['code_postal'] . " " . $ENTREPRISE_ADRESSES[0]['ville'])) . "\";", "config/"); maj_configuration_file("config_generale.inc.php", "maj_line", "\$PIED_DE_PAGE_GAUCHE_1 =", "\$PIED_DE_PAGE_GAUCHE_1 = \"Siret: " . addslashes(stripslashes($ENTREPRISE_NOTE)) . "\";", "config/"); maj_configuration_file("config_generale.inc.php", "maj_line", "\$PIED_DE_PAGE_DROIT_0 =", "\$PIED_DE_PAGE_DROIT_0 = \"Site Internet: " . addslashes(stripslashes($url_site)) . "\";", "config/"); maj_configuration_file("config_generale.inc.php", "maj_line", "\$PIED_DE_PAGE_DROIT_1 =", "\$PIED_DE_PAGE_DROIT_1 = \"Email: " . addslashes(stripslashes($ENTREPRISE_COORDONNEES[0]['email'])) . "\";", "config/"); //générer image du entete_doc_pdf $source = imagecreatefromjpeg("fichiers/images/entete_doc_pdf.jpg"); $nom_contact = explode("\n", $ENTREPRISE_NOM); $l = 60; $c = 10; $size = 30; $couleur = imagecolorallocate($source, 0, 0, 0); $font = 'fichiers/arial.ttf'; foreach ($nom_contact as $line) { imagettftext($source, $size, 0, $c, $l, $couleur, $font, utf8_encode(str_replace("\\S", "", str_replace("\t", "", $line))));