function addevent($titrfr, $titren, $titrar, $contfr, $conten, $contar, $img, $id, $autfr, $auten, $autar, $dat) { global $db; $date = date('Y-m-d-', strtotime($dat)); $values["titrfr"] = MySQL::SQLValue($titrfr); $values["titren"] = MySQL::SQLValue($titren); $values["titrar"] = MySQL::SQLValue($titrar); $values["contfr"] = MySQL::SQLValue($contfr); $values["conten"] = MySQL::SQLValue($conten); $values["contar"] = MySQL::SQLValue($contar); $values["autfr"] = MySQL::SQLValue($autfr); $values["auten"] = MySQL::SQLValue($auten); $values["autar"] = MySQL::SQLValue($autar); $values["app"] = MySQL::SQLValue('?_tsk=event&id=' . $id); $values["dat"] = MySQL::SQLValue($date); // Execute the insert $result = $db->InsertRow("event", $values); // If we have an error if (!$result) { // Show the error and kill the script $db->Kill('Error Insert'); return false; } else { if ($img != "") { $basedir = "upload/event"; if (!file_exists($basedir)) { mkdir($basedir, 0, true); } $newdir = "../upload/event/"; copyfile($img, $id, $newdir, "event_"); autoarchive($newdir . changnom($img, $id, 'event_'), "Image Evénement {$id} ", 12, $id, "event", "img", $_SESSION['userid'], cryptage(session::get('service'), 0)); } return true; } }
function editreform($nextid, $titre, $desc, $montant, $pj, $date) { global $db; $usrid = $_SESSION['userid']; $date_operation = date('Y-m-d-', strtotime($date)); $values["titre"] = MySQL::SQLValue($titre); $values["description"] = MySQL::SQLValue($desc); $values["montant"] = MySQL::SQLValue($montant); $values["date_operation"] = MySQL::SQLValue($date_operation); $where["id"] = MySQL::SQLValue($nextid); if (!$db->UpdateRows("produit_reform", $values, $where)) { $db->Kill($db->Error()); return false; } else { $sql = $db->BuildSQLInsert("produit_reform", $values); logg('Enregistrement Produit Reform ', 167, $nextid, $_SESSION['userid']); if ($pj != "") { $basedir = "upload/produit"; if (!file_exists($basedir)) { mkdir($basedir, 0, true); } $newdir = $basedir . "/"; copyfile($pj, $nextid, $newdir, "Attachement_produit_reform"); autoarchive($newdir . changnom($pj, $nextid, 'Attachement_produit_reform'), "Fichier joint produit Reform {$nextid}", 100, $nextid, "produit_reform", "pj", $_SESSION['userid'], cryptage(session::get('service'), 0)); } return true; } }
function addnews($titrfr, $titren, $titrar, $img, $id, $art, $typ) { global $db; $values["titrfr"] = MySQL::SQLValue($titrfr); $values["titren"] = MySQL::SQLValue($titren); $values["titrar"] = MySQL::SQLValue($titrar); $values["article"] = MySQL::SQLValue($art); $values["typ"] = MySQL::SQLValue($typ); // Execute the insert $result = $db->InsertRow("document", $values); // If we have an error if (!$result) { // Show the error and kill the script $db->Kill($result); return false; } else { if ($img != "") { $basedir = "upload/doc"; if (!file_exists($basedir)) { mkdir($basedir, 0, true); } $newdir = "../upload/doc/"; if (!file_exists($newdir)) { mkdir($newdir, 0, true); } $file = "./upload/doc/" . changnom($img, $id, 'doc_'); copyfile($img, $id, $newdir, "doc_"); autoarchive($file, "Document page {$id} ", 12, $id, "document", "img", $_SESSION['userid'], cryptage(session::get('service'), 0)); } return true; } }
function addalbum($titrfr, $titren, $img, $id, $titrear) { global $db; $values["titrfr"] = MySQL::SQLValue($titrfr); $values["titren"] = MySQL::SQLValue($titren); $values["titrar"] = MySQL::SQLValue($titrear); $values["album"] = MySQL::SQLValue(changnom($img, $id, 'Album_')); $values["arch"] = MySQL::SQLValue("0"); // Execute the insert $result = $db->InsertRow("album", $values); // If we have an error if (!$result) { // Show the error and kill the script $db->Kill($result); return false; } else { $basedir = "upload/album/"; //if(!file_exists($basedir)){mkdir($basedir);} if (!file_exists($basedir . "/" . $id)) { mkdir($basedir . "/" . $id, 0, true); } $newdir = "../upload/album/" . $id . "/"; if (!file_exists($newdir)) { mkdir($newdir, 0, true); } if ($img != "") { copyfile($img, $id, $basedir, "Album_"); clearDir($newdir); extractzip($basedir, "Album_" . $id . ".zip", $id, $newdir); } return true; } }
function add_contrat($nextid, $titre, $fournisseur, $date, $montant_global, $article, $paragraphe, $chapitre, $pj) { global $db; $usrid = $_SESSION['userid']; $date = date('Y-m-d-', strtotime($date)); $values["titre"] = MySQL::SQLValue($titre); $values["date"] = MySQL::SQLValue($date); $values["id_fournisseur"] = MySQL::SQLValue($fournisseur); $values["id_chapitre"] = MySQL::SQLValue($chapitre); $values["id_article"] = MySQL::SQLValue($article); $values["id_paragraphe"] = MySQL::SQLValue($paragraphe); $values["montant_global"] = MySQL::SQLValue($montant_global); $values["montant_paye"] = MySQL::SQLValue(0); $values["pourcentage"] = MySQL::SQLValue(0); $values["montant_rest"] = MySQL::SQLValue($montant_global); $values["addby"] = MySQL::SQLValue($usrid); if (!$db->InsertRow("contrat", $values)) { $db->Kill($db->Error()); return false; } else { logg('Enregistrement Contrat Fournisseur ', 254, $nextid, $_SESSION['userid']); // Save PJ to archive if ($pj != "") { $basedir = "upload/contrat"; if (!file_exists($basedir)) { mkdir($basedir, 0, true); } $newdir = $basedir . "/"; copyfile($pj, $nextid, $newdir, "Attachement_contrat_"); autoarchive($newdir . changnom($pj, $nextid, 'Attachement_contrat_'), "Fichier joint contrat fournisseur {$nextid}", 254, $nextid, "contrat", "pj", $_SESSION['userid'], cryptage(session::get('service'), 0)); } } return true; }
function editsalarie($id, $nom, $prenom, $fonction, $salarie, $date, $agence, $service, $matricule, $nom_banque, $num_compte, $taux_anc, $status, $photo, $etatf, $nbrf) { global $db; global $db2; $date_embauche = date('Y-m-d-', strtotime($date)); $values["nom"] = MySQL::SQLValue($nom); $values["prenom"] = MySQL::SQLValue($prenom); $values["fonction"] = MySQL::SQLValue($fonction); $values["date_embauche"] = MySQL::SQLValue($date_embauche); $values["agence"] = MySQL::SQLValue($agence); $values["service"] = MySQL::SQLValue($service); $values["matricule"] = MySQL::SQLValue($matricule); $values["situation_familiale"] = MySQL::SQLValue($etatf); $values["nbr_enfant"] = MySQL::SQLValue($nbrf); $values["status"] = MySQL::SQLValue($status); if ($photo != null) { $values["photo"] = MySQL::SQLValue(changnom($photo, $id, 'photo_')); } $where["id"] = MySQL::SQLValue($id); if (!$db->UpdateRows("info_personnel", $values, $where)) { $db->Kill($db->Error()); return false; } else { $sql = $db->BuildSQLInsert("info_personnel", $values); if ($photo != "") { $basedir = "upload/salarie/"; if (!file_exists($basedir)) { mkdir($basedir, 0, true); } $newdir = $basedir . "/"; copyfile($photo, $id, $newdir, "photo_"); } return true; } }
function addaemploi($id_aemploi, $montant, $date_paiement, $mode_paiement, $ref_pj, $pj) { global $db; $nextid = getnextidtable('autorisation_emploi'); $usrid = $_SESSION['userid']; $date = date('Y-m-d-', strtotime($date_paiement)); $values["pj"] = MySQL::SQLValue($pj); $values["ref_pj"] = MySQL::SQLValue($ref_pj); $values["id_aemploi"] = MySQL::SQLValue($id_aemploi); $values["mode_paiement"] = MySQL::SQLValue($mode_paiement); $values["date_paiement"] = MySQL::SQLValue($date); $values["montant"] = MySQL::SQLValue($montant); $values["addby"] = MySQL::SQLValue($usrid); if (!$db->InsertRow("autorisation_emploi", $values)) { $db->Kill($db->Error()); return false; } else { $sql = $db->BuildSQLInsert("autorisation_emploi", $values); logg('Enregistrement Autorisation Emploi ', 246, $nextid, $_SESSION['userid']); if ($pj != "") { $basedir = "upload/Autorisation"; if (!file_exists($basedir)) { mkdir($basedir, 0, true); } $newdir = $basedir . "/"; copyfile($pj, $nextid, $newdir, "Attachement_autorisation_"); autoarchive($newdir . changnom($pj, $nextid, 'Attachement_autorisation_'), "Fichier joint autorisation emploi {$nextid}", 246, $nextid, "autorisation_emploi", "pj", $_SESSION['userid'], cryptage(session::get('service'), 0)); } } return true; }
function editlocation($nextid, $nom, $adresse, $pj, $tel, $mail, $villa, $date_debut, $date_fin, $type_paiement, $montant_location, $agarantie_location) { global $db; $usrid = $_SESSION['userid']; $datedebut = date('Y-m-d-', strtotime($date_debut)); $datefin = date('Y-m-d-', strtotime($date_fin)); $values["nomlocataire"] = MySQL::SQLValue($nom); $values["adresse"] = MySQL::SQLValue($adresse); $values["tel"] = MySQL::SQLValue($tel); $values["mail"] = MySQL::SQLValue($mail); $values["idvilla"] = MySQL::SQLValue($villa); $values["date_debut"] = MySQL::SQLValue($datedebut); $values["date_fin"] = MySQL::SQLValue($datefin); $values["montant"] = MySQL::SQLValue($montant_location); $values["depot_garantie"] = MySQL::SQLValue($agarantie_location); $values["type_paiement"] = MySQL::SQLValue($type_paiement); $where["id"] = MySQL::SQLValue($nextid); if (!$db->UpdateRows("contrat_location_villa", $values, $where)) { $db->Kill($db->Error()); return false; } else { $sql = $db->BuildSQLInsert("contrat_location_villa", $values); logg('Enregistrement Location Villa ', 100, $nextid, $_SESSION['userid']); if ($pj != "") { $basedir = "upload/location"; if (!file_exists($basedir)) { mkdir($basedir, 0, true); } $newdir = $basedir . "/"; copyfile($pj, $nextid, $newdir, "Attachement_location_"); autoarchive($newdir . changnom($pj, $nextid, 'Attachement_location_'), "Fichier joint location ville {$nextid}", 100, $nextid, "location_villa", "pj", $_SESSION['userid'], cryptage(session::get('service'), 0)); } return true; } }
function edit_quote($id, $date, $montant, $pj) { global $db; $date = date('Y-m-d-', strtotime($date)); $values["datinsert"] = MySQL::SQLValue($date); $values["montant"] = MySQL::SQLValue($montant); $where["id"] = MySQL::SQLValue($id); if (!$db->UpdateRows("quotpatronal", $values, $where)) { $db->Kill($db->Error()); return false; } else { $sql = $db->BuildSQLInsert("quotpatronal", $values); logg('Enregistrement Quote Part Patronal ', 175, $id, $_SESSION['userid']); if ($pj != "") { $basedir = "upload/quotpatronal"; if (!file_exists($basedir)) { mkdir($basedir, 0, true); } $newdir = $basedir . "/"; copyfile($pj, $id, $newdir, "Attachement_quotpatronal_"); autoarchive($newdir . changnom($pj, $id, 'Attachement_quotpatronal_'), "Fichier joint Quote Part Patronal {$id}", 175, $id, "quotpatronal", "piece_jointe", $_SESSION['userid'], cryptage(session::get('service'), 0)); } return true; } }
function adduser($nom, $fnom, $lnom, $pass, $mail, $service, $signe, $id, $agence, $tel, $img) { // $arrayVariable["column name"] = formatted SQL value global $db; $values["nom"] = MySQL::SQLValue($nom); $values["mail"] = MySQL::SQLValue($mail); $values["pass"] = MySQL::SQLValue(md5($pass)); $values["servic"] = MySQL::SQLValue($service); $values["fnom"] = MySQL::SQLValue($fnom); $values["lnom"] = MySQL::SQLValue($lnom); $values["tel"] = MySQL::SQLValue($tel); $values["active"] = MySQL::SQLValue(1); $values["defapp"] = MySQL::SQLValue(3); $values["agence"] = MySQL::SQLValue($agence); $values["signature"] = MySQL::SQLValue(changnom($signe, $id, 'signature_')); $values["photo"] = MySQL::SQLValue(changnom($img, $id, 'photo_')); // Execute the insert $result = $db->InsertRow("users_sys", $values); // If we have an error if (!$result) { // Show the error and kill the script $db->Kill($db->Error()); return false; } else { addrules($id, $service); $newdir = "upload/signature/"; if ($signe != "") { copyfile($signe, $id, $newdir, "signature_"); } if ($img != "") { copyfile($img, $id, $newdir, "signature_"); } return true; } }
function setcontrat($id, $date, $pj) { global $db; $etat = "Résilié"; $nextid = getnextidtable('contrat_location_villa'); $date = date('Y-m-d-', strtotime($date)); $values["date_resiliation"] = MySQL::SQLValue($date); $values["etat"] = MySQL::SQLValue($etat); $where["id"] = MySQL::SQLValue($id); if (!$db->UpdateRows("contrat_location_villa", $values, $where)) { $db->Kill($db->Error()); return false; } else { $sql = $db->BuildSQLInsert("contrat_location_villa", $values); logg('Enregistrement Location Villa ', 233, $id, $_SESSION['userid']); if ($pj != "") { $basedir = "upload/location"; if (!file_exists($basedir)) { mkdir($basedir, 0, true); } $newdir = $basedir . "/"; copyfile($pj, $id, $newdir, "Attachement_location_"); autoarchive($newdir . changnom($pj, $id, 'Attachement_location_'), "Fichier joint location ville {$id}", 233, $id, "contrat_location_villa", "pj_resiliation", $_SESSION['userid'], cryptage(session::get('service'), 0)); } return true; } }
function editdoc($titrfr, $titren, $titrar, $img, $id, $art, $typ) { global $db; $values["titrfr"] = MySQL::SQLValue($titrfr); $values["titren"] = MySQL::SQLValue($titren); $values["titrar"] = MySQL::SQLValue($titrar); $values["article"] = MySQL::SQLValue($art); $values["typ"] = MySQL::SQLValue($typ); if ($img != "") { $values["img"] = MySQL::SQLValue(changnom($img, $id, 'doc_')); } $where["id"] = MySQL::SQLValue($id); // Execute the insert $result = $db->UpdateRows("document", $values, $where); // If we have an error if (!$result) { // Show the error and kill the script $db->Kill('Error Update'); return false; } else { if ($img != "") { $olddir = "upload/doc/"; $newdir = "../upload/doc/"; copyfile($img, $id, $newdir, "doc_"); autoarchive($newdir . changnom($img, $id, 'doc_'), "Document page {$id} ", 12, $id, "document", "img", $_SESSION['userid'], cryptage(session::get('service'), 0)); } return true; } }
function setcollecte($id, $mode_paiement, $pj, $date_paiement) { global $db; //$nextid=getnextidtable('collecte'); $date = date('Y-m-d-', strtotime($date_paiement)); $values["mode_paiement"] = MySQL::SQLValue($mode_paiement); $values["date_paiement"] = MySQL::SQLValue($date); $values["etat_paiement"] = MySQL::SQLValue("Payé"); $where["id"] = MySQL::SQLValue($id); if (!$db->UpdateRows("collecte", $values, $where)) { $db->Kill($db->Error()); return false; } else { $sql = $db->BuildSQLInsert("collecte", $values); logg('Enregistrement collecte ', 195, $id, $_SESSION['userid']); if ($pj != "") { $basedir = "upload/collecte"; if (!file_exists($basedir)) { mkdir($basedir, 0, true); } $newdir = $basedir . "/"; copyfile($pj, $id, $newdir, "Attachement_collecte_"); autoarchive($newdir . changnom($pj, $id, 'Attachement_collecte_'), "Fichier joint collecte {$id}", 195, $id, "collecte", "piece_jointe", $_SESSION['userid'], cryptage(session::get('service'), 0)); } return true; } }
function editalbum($titrfr, $titren, $titrar, $img, $id) { global $db; $values["titrfr"] = MySQL::SQLValue($titrfr); $values["titren"] = MySQL::SQLValue($titren); $values["titrar"] = MySQL::SQLValue($titrar); if ($img != "") { $values["album"] = MySQL::SQLValue(changnom($img, $id, "album_")); } $where["id"] = MySQL::SQLValue($id); // Execute the insert $result = $db->UpdateRows("album", $values, $where); // If we have an error if (!$result) { // Show the error and kill the script $db->Kill($result); return false; } else { if ($img != "") { $olddir = "upload/album/"; $newdir = "../upload/album/" . $id . "/"; copyfile($img, $id, $olddir, "album_"); clearDir($newdir); extractzip($olddir, "album_" . $id . ".zip", $id, $newdir); } return true; } }
function editcollecte($idcontrat, $paiement, $date, $pj) { global $db; $usrid = $_SESSION['userid']; $nextid = getnextidtable('collecte'); //$date1=date_create($date); //$datep=date_format($date1,"Y-m-d"); $date_paiement = date('Y-m-d-', strtotime($date)); $values["mode_paiement"] = MySQL::SQLValue($paiement); $values["date_paiement"] = MySQL::SQLValue($date_paiement); $where["id"] = MySQL::SQLValue($idcontrat); if (!$db->UpdateRows("collecte", $values, $where)) { $db->Kill($db->Error()); return false; } else { $sql = $db->BuildSQLInsert("collecte", $values); logg('Enregistrement collecte ', 201, $nextid, $_SESSION['userid']); if ($pj != "") { $basedir = "upload/collecte"; if (!file_exists($basedir)) { mkdir($basedir, 0, true); } $newdir = $basedir . "/"; copyfile($pj, $nextid, $newdir, "collecte"); autoarchive($newdir . changnom($pj, $nextid, 'collecte'), "Fichier joint collecte {$nextid}", 201, $nextid, "collecte", "piece_jointe", $_SESSION['userid'], cryptage(session::get('service'), 0)); } return true; } }
function edituser($fnom, $lnom, $service, $tel, $id, $signe, $agence) { global $db; if ($service != NULL) { $values["servic"] = MySQL::SQLValue($service); } $values["fnom"] = MySQL::SQLValue($fnom); $values["lnom"] = MySQL::SQLValue($lnom); $values["active"] = MySQL::SQLValue(1); $values["tel"] = MySQL::SQLValue($tel); $values["agence"] = MySQL::SQLValue($agence); $where["id"] = MySQL::SQLValue($id); if ($signe != NULL) { $values["signature"] = MySQL::SQLValue(changnom($signe, $id, 'signature_')); } // Execute the insert $result = $db->UpdateRows("users_sys", $values, $where); // ajout champs table synchrone $sql = $db->BuildSQLUpdate("users_sys", $values, $where); $valuesf["req"] = MySQL::SQLValue($sql); $r = $db->InsertRow("temprequet", $valuesf); // If we have an error if (!$result) { // Show the error and kill the script $db->Kill($result); return false; } else { $newdir = "upload/signature/"; if ($signe != NULL) { copyfile($signe, $id, $newdir, "signature_"); } return true; } }
function addcontenu($titrfr, $titren, $titrar, $contfr, $conten, $contar, $module, $img, $id, $vod, $fileuploadid, $dat) { $next_id_vod = getnextidtable('vod'); global $db; $newdir = "../upload/contenu/image/"; $date = date('Y-m-d-', strtotime($dat)); $values["titrfr"] = MySQL::SQLValue($titrfr); $values["titren"] = MySQL::SQLValue($titren); $values["titrar"] = MySQL::SQLValue($titrar); $values["contfr"] = MySQL::SQLValue($contfr); $values["conten"] = MySQL::SQLValue($conten); $values["contar"] = MySQL::SQLValue($contar); $values["modul"] = MySQL::SQLValue($module); $values["app"] = MySQL::SQLValue('?_tsk=page&id=' . $id); if ($vod != "") { $values["video"] = MySQL::SQLValue($next_id_vod); } $values["dat"] = MySQL::SQLValue($date); $values["img"] = MySQL::SQLValue(changnom($newdir . $img, $id, 'contenu_')); // Execute the insert $result = $db->InsertRow("contenu", $values); // If we have an error if (!$result) { // Show the error and kill the script $db->Kill('error'); return false; } else { if ($img != "") { $basedir = "upload/contenu/image"; if (!file_exists($basedir)) { mkdir($basedir, 0, true); } if (!file_exists($newdir)) { mkdir($newdir, 0, true); } copyfile($img, $id, $newdir, "contenu_"); } if ($fileuploadid != "") { $basedir = "upload/contenu/doc"; if (!file_exists($basedir)) { mkdir($basedir, 0, true); } $newdir = "../upload/contenu/doc/"; if (!file_exists($newdir)) { mkdir($newdir, 0, true); } copyfile($fileuploadid, $id, $newdir, "document_"); $file = "./upload/contenu/doc/" . changnom($fileuploadid, $id, 'document_'); autoarchive($file, "Document Contenu {$id} ", 12, $id, "contenu", "document", $_SESSION['userid'], cryptage(session::get('service'), 0)); } if ($vod != "") { addvod($titrfr, $titren, $titrar, $vod); } return true; } }
function addnews($titrfr, $titren, $titrar, $contfr, $conten, $contar, $img, $id, $autfr, $auten, $autar, $slider, $dat, $flash, $lien, $photot) { global $db; $basedir = UPLD_REP . "news"; if (!file_exists($basedir)) { mkdir($basedir, 0, true); } $newdir = $basedir . "/"; $next_id_vod = getnextidtable('vod'); $date = date('Y-m-d-', strtotime($dat)); $values["titrfr"] = MySQL::SQLValue($titrfr); $values["titren"] = MySQL::SQLValue($titren); $values["titrar"] = MySQL::SQLValue($titrar); $values["contfr"] = MySQL::SQLValue($contfr); $values["conten"] = MySQL::SQLValue($conten); $values["contar"] = MySQL::SQLValue($contar); $values["autfr"] = MySQL::SQLValue($autfr); $values["auten"] = MySQL::SQLValue($auten); $values["autar"] = MySQL::SQLValue($autar); $values["modul"] = MySQL::SQLValue("9"); $values["slider"] = MySQL::SQLValue($slider); $values["flash"] = MySQL::SQLValue($flash); $values["arch"] = MySQL::SQLValue("0"); if ($lien != "") { $values["video"] = MySQL::SQLValue($next_id_vod); } $values["img"] = MySQL::SQLValue(changnom($newdir . $img, $id, 'nws_')); $values["img_d"] = MySQL::SQLValue(changnom($newdir . $photot, $id, 'nwst_')); $values["app"] = MySQL::SQLValue('?_tsk=news&id=' . $id); $values["dat"] = MySQL::SQLValue($date); // Execute the insert $result = $db->InsertRow("contenu", $values); // If we have an error if (!$result) { // Show the error and kill the script $db->Kill($db->Error()); return false; } else { if ($img != "") { copyfile($img, $id, $newdir, "nws_"); } if ($photot != "") { copyfile($photot, $id, $newdir, "nwst_"); } if ($lien != "") { addvod($titrfr, $titren, $titrar, $lien); } return true; } }
function editpage($titrfr, $titren, $titrar, $contfr, $conten, $contar, $parent, $img, $id, $titrimgfr, $titrimgar, $ximg, $yimg) { global $db; $newdir = "../upload/page/"; $values["titrfr"] = MySQL::SQLValue($titrfr); $values["titren"] = MySQL::SQLValue($titren); $values["titrar"] = MySQL::SQLValue($titrar); $values["contfr"] = MySQL::SQLValue($contfr); $values["conten"] = MySQL::SQLValue($conten); $values["contar"] = MySQL::SQLValue($contar); $values["parent"] = MySQL::SQLValue($parent); if ($titrimgfr != NULL) { $values["titrimgfr"] = MySQL::SQLValue($titrimgfr); } if ($titrimgar != NULL) { $values["titrimgar"] = MySQL::SQLValue($titrimgar); } if ($ximg != NULL) { $values["ximg"] = MySQL::SQLValue($ximg); } if ($yimg != NULL) { $values["yimg"] = MySQL::SQLValue($yimg); } if ($img != "") { $values["img"] = MySQL::SQLValue(changnom($newdir . $img, $id, 'page_')); } $where["id"] = MySQL::SQLValue($id); // Execute the Update $result = $db->UpdateRows("page", $values, $where); // If we have an error if (!$result) { // Show the error and kill the script $db->Kill('Error'); return false; } else { if ($img != "") { $basedir = "upload/page"; if (!file_exists($basedir)) { mkdir($basedir, 0, true); } if (!file_exists($newdir)) { mkdir($newdir, 0, true); } copyfile($img, $id, $newdir, "page_"); } return true; } }
function addpage($titrfr, $titren, $titrar, $contfr, $conten, $contar, $parent, $img, $id, $titrimgfr, $titrimgar, $ximg, $yimg) { $basedir = UPLD_REP . "page"; if (!file_exists($basedir)) { mkdir($basedir, 0, true); } $newdir = $basedir . "/"; global $db; $values["titrfr"] = MySQL::SQLValue($titrfr); $values["titren"] = MySQL::SQLValue($titren); $values["titrar"] = MySQL::SQLValue($titrar); $values["contfr"] = MySQL::SQLValue($contfr); $values["conten"] = MySQL::SQLValue($conten); $values["contar"] = MySQL::SQLValue($contar); $values["parent"] = MySQL::SQLValue($parent); $values["app"] = MySQL::SQLValue('?_tsk=page&id=' . $id); if ($titrimgfr != NULL) { $values["titrimgfr"] = MySQL::SQLValue($titrimgfr); } if ($titrimgar != NULL) { $values["titrimgar"] = MySQL::SQLValue($titrimgar); } if ($ximg != NULL) { $values["ximg"] = MySQL::SQLValue($ximg); } if ($yimg != NULL) { $values["yimg"] = MySQL::SQLValue($yimg); } $values["img"] = MySQL::SQLValue(changnom($newdir . $img, $id, 'page_')); // Execute the insert $result = $db->InsertRow("page", $values); //updat link parent $valuesu["app"] = MySQL::SQLValue('#'); $whereu["id"] = MySQL::SQLValue($parent); // Execute the Update $resultu = $db->UpdateRows("page", $valuesu, $whereu); // If we have an error if (!$result && !$resultu) { // Show the error and kill the script $db->Kill('error'); return false; } else { if ($img != "") { copyfile($img, $id, $newdir, "page_"); } return true; } }
function editnews($titrfr, $titren, $titrar, $contfr, $conten, $contar, $img, $id, $autfr, $auten, $autar, $slider, $dat, $lien, $idvd) { global $db; $newdir = "../upload/news/"; $date = date('Y-m-d-', strtotime($dat)); $values["titrfr"] = MySQL::SQLValue($titrfr); $values["titren"] = MySQL::SQLValue($titren); $values["titrar"] = MySQL::SQLValue($titrar); $values["contfr"] = MySQL::SQLValue($contfr); $values["conten"] = MySQL::SQLValue($conten); $values["contar"] = MySQL::SQLValue($contar); $values["autfr"] = MySQL::SQLValue($autfr); $values["auten"] = MySQL::SQLValue($auten); $values["autar"] = MySQL::SQLValue($autar); $values["slider"] = MySQL::SQLValue($slider); if ($img != "") { $values["img"] = MySQL::SQLValue(changnom($newdir . $img, $id, 'nws_')); } $values["dat"] = MySQL::SQLValue($date); $where["id"] = MySQL::SQLValue($id); // Execute the insert $result = $db->UpdateRows("contenu", $values, $where); // If we have an error if (!$result) { // Show the error and kill the script $db->Kill('Error Update'); return false; } else { if ($img != "") { $basedir = "upload/news"; if (!file_exists($basedir)) { mkdir($basedir, 0, true); } if (!file_exists($newdir)) { mkdir($newdir, 0, true); } copyfile($img, $id, $newdir, "nws_"); } if ($lien != "") { editvod($titrfr, $titren, $titrar, $lien, $idvd); } return true; } }
function addalbum($titrfr, $titren, $titrar, $img, $id) { global $db; $values["titrfr"] = MySQL::SQLValue($titrfr); $values["titren"] = MySQL::SQLValue($titren); $values["titrar"] = MySQL::SQLValue($titrar); $values["album"] = MySQL::SQLValue(changnom($img, $id, 'Album_')); // Execute the insert $result = $db->InsertRow("album", $values); // If we have an error if (!$result) { // Show the error and kill the script $db->Kill($result); return false; } else { copyfile($img, $id); return true; } }
function addnote($objet, $note, $id, $dat) { global $db; $date = date('Y-m-d', strtotime($dat)); $getan = date('Y', strtotime($dat)); $usrid = $_SESSION['userid']; $values["objet"] = MySQL::SQLValue($objet); $values["file"] = MySQL::SQLValue(changnom($note, $id, 'note_')); $values["dat"] = MySQL::SQLValue($date); $values["addby"] = MySQL::SQLValue($usrid); // Execute the insert $result = $db->InsertRow("noteservice", $values); $sql = $db->BuildSQLInsert("noteservice", $values); $valuesf["req"] = MySQL::SQLValue($sql); $r = $db->InsertRow("temprequet", $valuesf); // If we have an error if (!$result) { // Show the error and kill the script $db->Kill('Error insert'); return false; } else { logg('Enregistrement Note de service', 12, $id, $_SESSION['userid']); $basedir = "upload/noteservice/{$getan}"; // save file if (!file_exists($basedir)) { mkdir($basedir, 0, true); } $newdir = $basedir . "/"; if ($note != "") { copyfile($note, $id, $newdir, "note_"); autoarchive($newdir . changnom($note, $id, 'note_'), "Note de service N° {$id} ", 12, $id, "noteservice", "file", $_SESSION['userid'], cryptage(session::get('service'), 0)); } return true; } /* if($lettre!=""){ copyfile($lettre,$id,$newdir,"lettre_"); autoarchive($newdir.changnom($lettre,$id,'lettre_'),"Lettre demande Autorisation d'Emploi $id ",44,$id,"aemploi", "lettre", $_SESSION['userid'],cryptage(session::get('service'),0)); } */ }
function addlocation($nextid, $nomlocataire, $nomresponsable, $adresse, $tel, $mail, $villa, $date_debut, $date_fin, $montant, $depot_garantie, $pj, $cycle) { global $db; $usrid = $_SESSION['userid']; $datedebut = date('Y-m-d-', strtotime($date_debut)); $datefin = date('Y-m-d-', strtotime($date_fin)); $values["nomlocataire"] = MySQL::SQLValue($nomlocataire); $values["nomresponsable"] = MySQL::SQLValue($nomresponsable); $values["adresse"] = MySQL::SQLValue($adresse); $values["tel"] = MySQL::SQLValue($tel); $values["mail"] = MySQL::SQLValue($mail); $values["date_debut"] = MySQL::SQLValue($datedebut); $values["date_fin"] = MySQL::SQLValue($datefin); $values["montant"] = MySQL::SQLValue($montant); $values["depot_garantie"] = MySQL::SQLValue($depot_garantie); //$values["type_paiement"] = MySQL::SQLValue($type_paiement); $values["addby"] = MySQL::SQLValue($usrid); $values["etat"] = MySQL::SQLValue('Attente Validation'); $values["cycle_paiement"] = MySQL::SQLValue($cycle); $values["idvilla"] = MySQL::SQLValue($villa); //if(($db->QuerySingleValue0("SELECT id FROM contrat_location_villa where etat='en cours' and idvilla ='".tp('villa')."'")==0) if (!$db->InsertRow("contrat_location_villa", $values)) { $db->Kill($db->Error()); return false; } else { $sql = $db->BuildSQLInsert("contrat_location_villa", $values); logg('Enregistrement Location Villa ', 196, $nextid, $_SESSION['userid']); if ($pj != "") { $basedir = "upload/location"; if (!file_exists($basedir)) { mkdir($basedir, 0, true); } $newdir = $basedir . "/"; copyfile($pj, $nextid, $newdir, "Attachement_location_"); autoarchive($newdir . changnom($pj, $nextid, 'Attachement_location_'), "Fichier joint location villa {$nextid}", 196, $nextid, "contrat_location_villa", "pj", $_SESSION['userid'], cryptage(session::get('service'), 0)); } } return true; }
function editalbum($titrfr, $titren, $titrar, $img, $id) { global $db; $values["titrfr"] = MySQL::SQLValue($titrfr); $values["titren"] = MySQL::SQLValue($titren); $values["titrar"] = MySQL::SQLValue($titrar); $values["album"] = MySQL::SQLValue(changnom($img, $id)); $where["id"] = MySQL::SQLValue($id); // Execute the insert $result = $db->UpdateRows("album", $values, $where); // If we have an error if (!$result) { // Show the error and kill the script $db->Kill($result); return false; } else { $a_del = "upload/album/album_" . $id . ".zip"; clearDir($a_del); //unlink("upload/album/album_".$id.".zip"); copyfile($img, $id); return true; } }
function addcollecte($nextid, $id, $prix, $paiement, $pj) { global $db; $values["id_location"] = MySQL::SQLValue($id); $values["prix_mensuel"] = MySQL::SQLValue($prix); $values["mode_paiement"] = MySQL::SQLValue($paiement); if (!$db->InsertRow("collecte", $values)) { $db->Kill($db->Error()); return false; } else { $sql = $db->BuildSQLInsert("collecte", $values); logg('Enregistrement collecte ', 100, $nextid, $_SESSION['userid']); if ($pj != "") { $basedir = "upload/collecte"; if (!file_exists($basedir)) { mkdir($basedir, 0, true); } $newdir = $basedir . "/"; copyfile($pj, $nextid, $newdir, "Attachement_collecte_"); autoarchive($newdir . changnom($pj, $nextid, 'Attachement_collecte_'), "Fichier joint collecte {$nextid}", 100, $nextid, "collecte", "piece_jointe", $_SESSION['userid'], cryptage(session::get('service'), 0)); } return true; } }
function add_depense($id, $titre, $fourn, $date_demande, $nbr_depense, $chapitre, $article, $paragraphe, $montant, $pj) { global $db; $usrid = $_SESSION['userid']; $date = date('Y-m-d-', strtotime($date_demande)); $values["nature_dep"] = MySQL::SQLValue($titre); $values["dat_val"] = MySQL::SQLValue($date); $values["fournisseur"] = MySQL::SQLValue($fourn); $values["nbr_lignes"] = MySQL::SQLValue($nbr_depense); $values["chapitre"] = MySQL::SQLValue($chapitre); $values["article"] = MySQL::SQLValue($article); $values["paragraphe"] = MySQL::SQLValue($paragraphe); $values["montant"] = MySQL::SQLValue($montant); $values["etat"] = MySQL::SQLValue(0); $values["addby"] = MySQL::SQLValue($usrid); if (!$db->InsertRow("depense", $values)) { $db->Kill($db->Error()); return false; } else { //Update Budget //model::load('budget','budget'); //update_paragraphe($paragraphe,$montant); //update_budget($paragraphe,$chapitre,$article); logg('Enregistrement Fiche depense ', 100, $id, $_SESSION['userid']); // Save PJ to archive if ($pj != "") { $basedir = $db->QuerySingleValue0("select CONCAT('upload/depense/',YEAR(dat_val),'/',id,'/') from depense where id = {$id}"); if (!file_exists($basedir)) { mkdir($basedir, 0, true); } $newdir = $basedir . "/"; copyfile($pj, $id, $newdir, "Attachement_depense_"); autoarchive($newdir . changnom($pj, $id, 'Attachement_depense_'), "Fichier joint dépense {$id} ", 100, $id, "depense", "pj", $_SESSION['userid'], cryptage(session::get('service'), 0)); } return true; } }
function copyfile($fil, $id, $newrep, $prifix) { $nfilname = $newrep . changnom($fil, $id, $prifix); $tfilname = "../cache/" . md5(str_replace("../", "", $nfilname)); if (file_exists($nfilname)) { unlink($nfilname); } if (file_exists("cache/" . $fil)) { rename("cache/" . $fil, $nfilname); //Supp file on cache site if (file_exists($tfilname . '_m.jpg')) { unlink($tfilname . '_m.jpg'); } if (file_exists($tfilname . '.jpg')) { unlink($tfilname . '.jpg'); } } //unlink("cache/".$fil); }
function copyfile($fil, $id, $newrep, $prifix) { $nfilname = $newrep . changnom($fil, $id, $prifix); //delet existing file with same name if (file_exists($nfilname)) { unlink($nfilname); } //copy file from cache to newrep and delet from cach if (file_exists("cache/" . $fil)) { rename("cache/" . $fil, $nfilname); //unlink("cache/".$fil); } }