function traite_exemplaires()
{
    global $msg, $dbh;
    global $nb_expl_ignores;
    global $prix, $notice_id, $info_996, $info_995, $info_001, $info_345_d;
    global $bulletin_id;
    global $id_expl_fournisseur_opsys, $id_expl_inventaire_opsys;
    // Afin de ne pas remettre en cause le script programmé en 995 :
    $info_995 = $info_996;
    // lu en 010$d de la notice
    $price = $prix[0];
    // prix dvd et video
    if ($info_345_d[0]) {
        $price = $info_345_d[0];
    }
    // la zone 995 est répétable
    for ($nb_expl = 0; $nb_expl < sizeof($info_995); $nb_expl++) {
        /* RAZ expl */
        $expl = array();
        /* préparation du tableau à passer à la méthode */
        $expl['notice'] = $notice_id;
        $expl['cb'] = $info_995[$nb_expl]['f'];
        $expl['cote'] = $info_995[$nb_expl]['k'];
        $expl['note'] = $info_995[$nb_expl]['u'] . $info_995[$nb_expl]['5'];
        $expl['prix'] = $price;
        $expl['cote_mandatory'] = 0;
        $expl['date_depot'] = substr($info_995[$nb_expl]['m'], 0, 4) . "-" . substr($info_995[$nb_expl]['m'], 4, 2) . "-" . substr($info_995[$nb_expl]['m'], 6, 2);
        $expl['date_retour'] = substr($info_995[$nb_expl]['n'], 0, 4) . "-" . substr($info_995[$nb_expl]['n'], 4, 2) . "-" . substr($info_995[$nb_expl]['n'], 6, 2);
        // propriétaire
        $owner = array();
        $owner['lender_libelle'] = $info_995[$nb_expl]['a'];
        if (!$owner['lender_libelle']) {
            $owner['lender_libelle'] = $info_995[$nb_expl]['b'];
        }
        if (!$owner['lender_libelle']) {
            $owner['lender_libelle'] = 'defaut';
        }
        $expl['expl_owner'] = lender::import($owner);
        $book_lender_id = $expl['expl_owner'];
        // docs_location
        $data_doc = array();
        $data_doc['location_libelle'] = $info_995[$nb_expl]['v'];
        $data_doc['locdoc_codage_import'] = $info_995[$nb_expl]['w'];
        if (!$data_doc['locdoc_codage_import']) {
            $data_doc['locdoc_codage_import'] = $data_doc['location_libelle'];
        }
        //$data_doc['locdoc_owner'] = $book_lender_id ;
        $data_doc['locdoc_owner'] = 0;
        $expl['location'] = docs_location::import($data_doc);
        // docs_section
        $data_doc = array();
        $data_doc['section_libelle'] = $info_995[$nb_expl]['x'];
        $data_doc['sdoc_codage_import'] = $info_995[$nb_expl]['y'];
        if (!$data_doc['sdoc_codage_import']) {
            $data_doc['sdoc_codage_import'] = $data_doc['section_libelle'];
        }
        //$data_doc['sdoc_owner'] = $book_lender_id ;
        $data_doc['sdoc_owner'] = 0;
        $expl['section'] = docs_section::import($data_doc);
        // typedoc
        $data_doc = array();
        $data_doc['tdoc_libelle'] = $info_995[$nb_expl]['e'];
        if (!$data_doc['tdoc_libelle']) {
            $data_doc['tdoc_libelle'] = $info_995[$nb_expl]['r'];
        }
        $data_doc['tdoc_codage_import'] = $info_995[$nb_expl]['r'];
        if (!$data_doc['tdoc_codage_import']) {
            $data_doc['tdoc_codage_import'] = $info_995[$nb_expl]['e'];
        }
        $data_doc['duree_pret'] = 28;
        /* valeur par défaut */
        $data_doc['tdoc_owner'] = $book_lender_id;
        $expl['typdoc'] = docs_type::import($data_doc);
        // statut doc
        $data_doc = array();
        $data_doc['statut_libelle'] = $info_995[$nb_expl]['1'];
        $data_doc['statusdoc_codage_import'] = $info_995[$nb_expl]['2'];
        if (!$data_doc['statusdoc_codage_import']) {
            $data_doc['statusdoc_codage_import'] = $info_995[$nb_expl]['1'];
        }
        $data_doc['pret_flag'] = $info_995[$nb_expl]['3'];
        $data_doc['statusdoc_owner'] = $book_lender_id;
        $expl['statut'] = docs_statut::import($data_doc);
        // codestat
        //$expl['codestat'] = 10 ;
        $data_codestat['codestat_libelle'] = strtolower($info_995[$nb_expl]['x']);
        $expl['codestat'] = docs_codestat::import($data_codestat);
        // quoi_faire
        // $que_faire vient du formulaire de chargement, à utiliser en attente de l'info dans la zone 996
        global $que_faire;
        if ($que_faire == "") {
            if ($info_995[$nb_expl]['0']) {
                $expl['quoi_faire'] = $info_995[$nb_expl]['0'];
            } else {
                $expl['quoi_faire'] = 2;
            }
        } else {
            $expl['quoi_faire'] = $que_faire;
        }
        // 0 : supprimer, 1 ou vide : Mettre à jour ou ajouter, 2 : ajouter si possible, sinon rien.
        //print "<pre>";print_r($info_995);print_r($expl);print "</pre>";
        $expl_id = exemplaire::import($expl);
        if ($expl_id == 0) {
            $nb_expl_ignores++;
        }
        list($num_opsys, $type_opsys) = explode(" ", $info_001[0]);
        if ($type_opsys == 'UMO:13') {
            $requete = "update exemplaires set expl_notice='0', expl_bulletin='{$bulletin_id}' where expl_id='{$expl_id}' ";
            //print "$requete <br />";
            pmb_mysql_query($requete);
        }
        if (!$id_expl_fournisseur_opsys) {
            $rqt = "select idchamp from expl_custom where name='fournisseur'";
            $res = pmb_mysql_query($rqt, $dbh);
            if ($res && ($r = pmb_mysql_fetch_object($res))) {
                $id_expl_fournisseur_opsys = $r->idchamp;
            }
        }
        if (!$id_expl_inventaire_opsys) {
            $rqt = "select idchamp from expl_custom where name='inventaire'";
            $res = pmb_mysql_query($rqt, $dbh);
            if ($res && ($r = pmb_mysql_fetch_object($res))) {
                $id_expl_inventaire_opsys = $r->idchamp;
            }
        }
        //inventaire en champ perso
        if ($field = $info_995[$nb_expl]['6']) {
            $requete = "insert into expl_custom_values (expl_custom_champ,expl_custom_origine,expl_custom_small_text) values({$id_expl_inventaire_opsys},{$expl_id},'" . addslashes($field) . "')";
            pmb_mysql_query($requete);
        }
        //Fournisseur en champ perso
        if ($field = $info_995[$nb_expl]['7']) {
            $requete = "insert into expl_custom_values (expl_custom_champ,expl_custom_origine,expl_custom_small_text) values({$id_expl_fournisseur_opsys},{$expl_id},'" . addslashes($field) . "')";
            pmb_mysql_query($requete);
        }
        //Date de création
        if ($field = $info_995[$nb_expl]['8']) {
            $requete = "update exemplaires set create_date='{$field} 12:00:00' where expl_id='{$expl_id}' ";
            //print $requete;
            pmb_mysql_query($requete);
        }
    }
    // fin for
}
예제 #2
0
function traite_exemplaires()
{
    global $msg, $dbh;
    global $nb_expl_ignores;
    global $bulletin_ex;
    global $prix, $notice_id, $info_995, $typdoc_995, $tdoc_codage, $book_lender_id, $section_995, $sdoc_codage, $book_statut_id, $locdoc_codage, $codstatdoc_995, $statisdoc_codage, $cote_mandatory, $book_location_id;
    // lu en 010$d de la notice
    //$price = $prix[0];
    // la zone 995 est répétable
    for ($nb_expl = 0; $nb_expl < sizeof($info_995); $nb_expl++) {
        /* RAZ expl */
        $expl = array();
        if ($bulletin_ex == -1) {
            return;
        } elseif ($bulletin_ex) {
            $expl['bulletin'] = $bulletin_ex;
            $expl['notice'] = 0;
        } else {
            $expl['notice'] = $notice_id;
            $expl['bulletin'] = 0;
        }
        /* préparation du tableau à passer à la méthode */
        $cbarre = $info_995[$nb_expl]['f'];
        if (!$cbarre) {
            $cbarre = "ind";
        }
        $pb = 1;
        $num_login = 1;
        $expl['cb'] = $cbarre;
        while ($pb == 1) {
            $q = "SELECT expl_cb FROM exemplaires WHERE expl_cb='" . $expl['cb'] . "' LIMIT 1 ";
            $r = pmb_mysql_query($q, $dbh);
            //echo "requete : ".$q."<br>";
            $nb = pmb_mysql_num_rows($r);
            if ($nb) {
                $expl['cb'] = $cbarre . "-" . $num_login;
                $num_login++;
            } else {
                $pb = 0;
            }
        }
        // $expl['typdoc']     = $info_995[$nb_expl]['r']; à chercher dans docs_typdoc
        $data_doc = array();
        //$data_doc['tdoc_libelle'] = $info_995[$nb_expl]['r']." -Type doc importé (".$book_lender_id.")";
        $data_doc['tdoc_libelle'] = $info_995[$nb_expl]['r'];
        $data_doc['tdoc_codage_import'] = $info_995[$nb_expl]['r'];
        if (!$data_doc['tdoc_libelle']) {
            $data_doc['tdoc_libelle'] = "Indéterminé";
            $data_doc['tdoc_codage_import'] = "Indéterminé";
        }
        $data_doc['duree_pret'] = 0;
        /* valeur par défaut */
        $data_doc['tdoc_owner'] = 0;
        $expl['typdoc'] = docs_type::import($data_doc);
        $expl['cote'] = $info_995[$nb_expl]['k'];
        if ($expl['cote'] == "") {
            $expl['cote'] = "Indetermine";
        }
        // $expl['section']    = $info_995[$nb_expl]['q']; à chercher dans docs_section
        /*$data_doc=array();
        		$info_995[$nb_expl]['q']=trim($info_995[$nb_expl]['q']);
        		if (!$info_995[$nb_expl]['q']) 
        			$info_995[$nb_expl]['q'] = "u";
        		*/
        $data_doc = array();
        $data_doc['section_libelle'] = $info_995[$nb_expl]['q'];
        $data_doc['sdoc_codage_import'] = $info_995[$nb_expl]['q'];
        if (!$data_doc['section_libelle']) {
            $data_doc['section_libelle'] = "Indéterminé";
            $data_doc['sdoc_codage_import'] = "Indéterminé";
        }
        $data_doc['sdoc_owner'] = 0;
        $expl['section'] = docs_section::import($data_doc);
        if (!$info_995[$nb_expl]['o']) {
            $expl['statut'] = $book_statut_id;
        } else {
            $info_995[$nb_expl]['o'] = "Indéterminé";
            $data_doc = array();
            $data_doc['statusdoc_codage_import'] = $info_995[$nb_expl]['o'];
            $data_doc['statut_libelle'] = $info_995[$nb_expl]['o'];
            $data_doc['statusdoc_owner'] = 0;
            $expl['statut'] = docs_statut::import($data_doc);
        }
        //$expl['statut'] = $book_statut_id;
        if ($info_995[$nb_expl]['a'] != "") {
            $data_doc = array();
            $data_doc['locdoc_codage_import'] = $info_995[$nb_expl]['a'];
            $data_doc['location_libelle'] = $info_995[$nb_expl]['a'];
            $data_doc['locdoc_owner'] = 0;
            $expl['location'] = docs_location::import($data_doc);
        } else {
            $expl['location'] = $book_location_id;
        }
        // $expl['codestat']   = $info_995[$nb_expl]['q']; 'q' utilisé, éventuellement à fixer par combo_box
        $data_doc = array();
        $data_doc['codestat_libelle'] = $info_995[$nb_expl]['q'];
        $data_doc['statisdoc_codage_import'] = $info_995[$nb_expl]['q'];
        if (!$data_doc['codestat_libelle']) {
            $data_doc['codestat_libelle'] = "Indéterminé";
            $data_doc['statisdoc_codage_import'] = "Indéterminé";
        }
        $data_doc['statisdoc_owner'] = 0;
        $expl['codestat'] = docs_codestat::import($data_doc);
        // $expl['creation']   = $info_995[$nb_expl]['']; à préciser
        // $expl['modif']      = $info_995[$nb_expl]['']; à préciser
        $expl['comment'] = $info_995[$nb_expl]['u'];
        $expl['note'] = "";
        $expl['prix'] = $prix[0];
        $expl['expl_owner'] = $book_lender_id;
        $expl['cote_mandatory'] = $cote_mandatory;
        $data['date_depot'] = "";
        // Attention il faut en post migration mette cette info dans la date de création de l'exemplaire
        // quoi_faire
        $expl['quoi_faire'] = 2;
        $expl_id = exemplaire::import($expl);
        if ($expl_id == 0) {
            $nb_expl_ignores++;
        } else {
        }
    }
    // fin for
}
예제 #3
0
function traite_exemplaires()
{
    global $msg, $dbh;
    global $prix, $notice_id, $info_995, $typdoc_995, $tdoc_codage, $book_lender_id, $section_995, $sdoc_codage, $book_statut_id, $locdoc_codage, $codstatdoc_995, $statisdoc_codage, $cote_mandatory, $book_location_id, $nb_expl_ignores;
    // la zone 995 est répétable
    for ($nb_expl = 0; $nb_expl < sizeof($info_995); $nb_expl++) {
        /* RAZ expl */
        $expl = array();
        /* préparation du tableau à passer à la méthode */
        $expl['cb'] = $info_995[$nb_expl]['a'];
        if (!$expl['cb']) {
            $expl['cb'] = "NOTI-" . $notice_id;
        }
        $expl['notice'] = $notice_id;
        $expl['cote'] = $info_995[$nb_expl]['f'];
        $expl['note'] = $info_995[$nb_expl]['u'];
        $expl['prix'] = $info_995[$nb_expl]['B'];
        $expl['date_depot'] = today();
        $expl['date_retour'] = today();
        // type de support
        $data_doc = array();
        $data_doc['tdoc_libelle'] = "Type doc - " . $info_995[$nb_expl]['c'];
        $data_doc['duree_pret'] = 0;
        /* valeur par défaut */
        $data_doc['tdoc_codage_import'] = $info_995[$nb_expl]['c'];
        $data_doc['tdoc_owner'] = 0;
        $expl['typdoc'] = docs_type::import($data_doc);
        // $expl['section']    = $info_995[$nb_expl]['x']; à chercher dans docs_section
        $data_doc = array();
        $data_doc['section_libelle'] = $info_995[$nb_expl]['x'];
        $data_doc['sdoc_codage_import'] = $info_995[$nb_expl]['x'];
        $data_doc['sdoc_owner'] = 0;
        $expl['section'] = docs_section::import($data_doc);
        if (!$expl['section']) {
            $expl['section'] = 31;
        }
        // $expl['statut']
        $data_doc = array();
        $data_doc['statut_libelle'] = "Statut - " . $info_995[$nb_expl]['y'];
        $data_doc['pret_flag'] = 1;
        $data_doc['statusdoc_codage_import'] = $info_995[$nb_expl]['y'];
        $data_doc['statusdoc_owner'] = 0;
        $expl['statut'] = docs_statut::import($data_doc);
        // $expl['location']
        $data_doc = array();
        $data_doc['location_libelle'] = "Localisation - " . $info_995[$nb_expl]['w'];
        $data_doc['locdoc_codage_import'] = $info_995[$nb_expl]['w'];
        $data_doc['locdoc_owner'] = 0;
        $expl['location'] = docs_location::import($data_doc);
        // $expl['codestat']   = $info_995[$nb_expl]['O']; (O majuscule, pas zéro)
        $data_doc = array();
        $data_doc['codestat_libelle'] = "Code stat - " . $info_995[$nb_expl]['O'];
        $data_doc['statisdoc_codage_import'] = $info_995[$nb_expl]['O'];
        $data_doc['statisdoc_owner'] = 0;
        $expl['codestat'] = docs_codestat::import($data_doc);
        if (!$expl['codestat']) {
            $expl['codestat'] = 38;
        }
        // $expl['expl_owner']
        $data_doc = array();
        $data_doc['lender_libelle'] = $info_995[$nb_expl]['R'];
        $expl['expl_owner'] = lender::import($data_doc);
        if (!$expl['expl_owner']) {
            $expl['expl_owner'] = 3;
        }
        $expl['cote_mandatory'] = $cote_mandatory;
        $expl_id = exemplaire::import($expl);
        if ($expl_id == 0) {
            $nb_expl_ignores++;
        }
        // Numéro du jeu
        if ($info_995[$nb_expl]['v'] && $expl_id) {
            $requete = "insert into expl_custom_values (expl_custom_champ,expl_custom_origine,expl_custom_small_text) values(1,{$expl_id},'" . addslashes($info_995[$nb_expl]['v']) . "')";
            mysql_query($requete);
        }
        //debug : affichage zone 995
        /*
        echo "995\$a =".$info_995[$nb_expl]['a']."<br />";
        echo "995\$b =".$info_995[$nb_expl]['b']."<br />";
        echo "995\$c =".$info_995[$nb_expl]['c']."<br />";
        echo "995\$d =".$info_995[$nb_expl]['d']."<br />";
        echo "995\$f =".$info_995[$nb_expl]['f']."<br />";
        echo "995\$k =".$info_995[$nb_expl]['k']."<br />";
        echo "995\$m =".$info_995[$nb_expl]['m']."<br />";
        echo "995\$n =".$info_995[$nb_expl]['n']."<br />";
        echo "995\$o =".$info_995[$nb_expl]['o']."<br />";
        echo "995\$q =".$info_995[$nb_expl]['q']."<br />";
        echo "995\$r =".$info_995[$nb_expl]['r']."<br />";
        echo "995\$u =".$info_995[$nb_expl]['u']."<br /><br />";
        */
    }
    // fin for
}
function traite_exemplaires()
{
    global $nb_expl_ignores, $bulletin_ex;
    global $prix, $notice_id, $info_996, $info_999, $typdoc_995, $tdoc_codage, $book_lender_id, $section_995, $sdoc_codage, $book_statut_id, $codstatdoc_995, $statisdoc_codage, $cote_mandatory, $book_location_id;
    global $suffix;
    // lu en 010$d de la notice
    $price = $prix[0];
    // la zone 995 est répétable
    for ($nb_expl = 0; $nb_expl < sizeof($info_996); $nb_expl++) {
        /* RAZ expl */
        $expl = array();
        $data = array();
        /*if(!$info_996[$nb_expl]['a'])$info_996[$nb_expl]['a'] ="Indéterminé";
        		$data['lender_libelle']=$info_996[$nb_expl]['a'];
        		$book_lender_id=lender::import($data);*/
        //Propriétaire
        if (trim($info_996[$nb_expl]['a'])) {
            $requete = "SELECT idlender FROM lenders WHERE lender_libelle LIKE '" . addslashes($info_996[$nb_expl]['a']) . "'";
            $res = mysql_query($requete);
            if (mysql_num_rows($res) && ($id = mysql_result($res, 0, 0))) {
                $local_book_lender_id = $id;
            } else {
                $local_book_lender_id = $book_lender_id;
            }
        } else {
            $local_book_lender_id = $book_lender_id;
        }
        /* préparation du tableau à passer à la méthode */
        $cbarre = $info_996[$nb_expl]['f'];
        if (!$cbarre) {
            $cbarre = "ind";
        }
        $pb = 1;
        $num_login = 1;
        $expl['cb'] = $cbarre;
        while ($pb == 1) {
            $q = "SELECT expl_cb FROM exemplaires WHERE expl_cb='" . addslashes($expl['cb']) . "' LIMIT 1 ";
            $r = mysql_query($q);
            $nb = mysql_num_rows($r);
            if ($nb) {
                $expl['cb'] = $cbarre . "-" . $num_login;
                $num_login++;
            } else {
                $pb = 0;
            }
        }
        if ($info_996[$nb_expl]['f'] != $expl['cb']) {
            $mon_msg = "ERREUR : l'exemplaire avec le code barres : " . $info_996[$nb_expl]['f'] . " existe déjà donc il ne sera pas créé";
            mysql_query("insert into error_log (error_origin, error_text) values ('import_" . addslashes(SESSid) . ".inc', '" . addslashes($mon_msg) . "') ");
            continue;
        }
        if ($bulletin_ex) {
            $expl['bulletin'] = $bulletin_ex;
            $expl['notice'] = 0;
        } else {
            $expl['notice'] = $notice_id;
            $expl['bulletin'] = 0;
        }
        $data_doc = array();
        $data_doc['tdoc_libelle'] = $info_996[$nb_expl]['e'];
        if (!$data_doc['tdoc_libelle']) {
            $data_doc['tdoc_libelle'] = "Indéterminé";
        }
        $requete = "SELECT idtyp_doc FROM docs_type WHERE tdoc_libelle LIKE '" . addslashes($data_doc['tdoc_libelle']) . "'";
        $res = mysql_query($requete);
        if (mysql_num_rows($res) && ($id = mysql_result($res, 0, 0))) {
            $expl['typdoc'] = $id;
        } else {
            $data_doc['duree_pret'] = 0;
            /* valeur par défaut */
            $data_doc['tdoc_codage_import'] = $data_doc['tdoc_libelle'];
            if ($tdoc_codage) {
                $data_doc['tdoc_owner'] = $local_book_lender_id;
            } else {
                $data_doc['tdoc_owner'] = 0;
            }
            $expl['typdoc'] = docs_type::import($data_doc);
        }
        $expl['cote'] = $info_996[$nb_expl]['k'];
        if (!$info_996[$nb_expl]['x']) {
            $info_996[$nb_expl]['x'] = "Indéterminé";
        }
        $requete = "SELECT idsection FROM docs_section WHERE section_libelle LIKE '" . addslashes($info_996[$nb_expl]['x']) . "'";
        $res = mysql_query($requete);
        if (mysql_num_rows($res) && ($id = mysql_result($res, 0, 0))) {
            $expl['section'] = $id;
        } else {
            $data_doc = array();
            $data_doc['section_libelle'] = $info_996[$nb_expl]['x'];
            $data_doc['sdoc_codage_import'] = $info_996[$nb_expl]['x'];
            if ($sdoc_codage) {
                $data_doc['sdoc_owner'] = $local_book_lender_id;
            } else {
                $data_doc['sdoc_owner'] = 0;
            }
            $expl['section'] = docs_section::import($data_doc);
        }
        if (!$info_996[$nb_expl]['1']) {
            $info_996[$nb_expl]['1'] = "Indéterminé";
        }
        $requete = "SELECT  idstatut FROM docs_statut WHERE statut_libelle LIKE '" . addslashes($info_996[$nb_expl]['1']) . "'";
        $res = mysql_query($requete);
        if (mysql_num_rows($res) && ($id = mysql_result($res, 0, 0))) {
            $expl['statut'] = $id;
        } else {
            $data_doc = array();
            $data_doc['statut_libelle'] = $info_996[$nb_expl]['1'];
            $data_doc['pret_flag'] = 1;
            $data_doc['statusdoc_codage_import'] = $info_996[$nb_expl]['1'];
            if ($sdoc_codage) {
                $data_doc['statusdoc_owner'] = $local_book_lender_id;
            } else {
                $data_doc['statusdoc_owner'] = 0;
            }
            $expl['statut'] = docs_statut::import($data_doc);
        }
        $requete = "SELECT idlocation FROM docs_location WHERE location_libelle LIKE '" . addslashes($info_996[$nb_expl]['v']) . "'";
        $res = mysql_query($requete);
        if (mysql_num_rows($res) && ($id = mysql_result($res, 0, 0))) {
            $expl['location'] = $id;
        } else {
            $expl['location'] = $book_location_id;
        }
        if (!$info_996[$nb_expl]['c']) {
            $info_996[$nb_expl]['c'] = "Indéterminé";
        }
        $requete = "SELECT idcode FROM docs_codestat WHERE codestat_libelle  LIKE '" . addslashes($info_996[$nb_expl]['c']) . "'";
        $res = mysql_query($requete);
        if (mysql_num_rows($res) && ($id = mysql_result($res, 0, 0))) {
            $expl['codestat'] = $id;
        } else {
            $data_doc = array();
            $data_doc['codestat_libelle'] = $info_996[$nb_expl]['c'];
            $data_doc['statisdoc_codage_import'] = $info_996[$nb_expl]['c'];
            if ($statisdoc_codage) {
                $data_doc['statisdoc_owner'] = $local_book_lender_id;
            } else {
                $data_doc['statisdoc_owner'] = 0;
            }
            $expl['codestat'] = docs_codestat::import($data_doc);
        }
        if ($info_996[$nb_expl]['4']) {
            $expl['creation'] = $info_996[$nb_expl]['4'];
        }
        $expl['note'] = $info_996[$nb_expl]['u'];
        $expl['comment'] = $info_996[$nb_expl]['z'];
        $expl['prix'] = $price;
        $expl['expl_owner'] = $local_book_lender_id;
        $expl['cote_mandatory'] = $cote_mandatory;
        $expl['date_depot'] = substr($info_996[$nb_expl]['m'], 0, 4) . "-" . substr($info_996[$nb_expl]['m'], 4, 2) . "-" . substr($info_996[$nb_expl]['m'], 6, 2);
        $expl['date_retour'] = substr($info_996[$nb_expl]['n'], 0, 4) . "-" . substr($info_996[$nb_expl]['n'], 4, 2) . "-" . substr($info_996[$nb_expl]['n'], 6, 2);
        // quoi_faire
        $expl['quoi_faire'] = 2;
        $expl_id = exemplaire::import($expl);
        if ($expl_id == 0) {
            $nb_expl_ignores++;
        } else {
            //Champ perso d'exemplaire
            //echo "Passe ici<br>";
            foreach ($info_999 as $key => $value) {
                if ($value["f"] == $info_996[$nb_expl]['f']) {
                    //Je suis bien sur un cp de cet exemplaire
                    if (!renseigne_cp($value["n"], $value["a"], $expl_id, "expl")) {
                        $mon_msg = "La valeur  : " . $value["a"] . " n'a pas été reprise dans le champ personalisé : " . $value["n"] . " car le champ n'existe pas";
                        mysql_query("insert into error_log (error_origin, error_text) values ('import_" . addslashes(SESSid) . ".inc', '" . addslashes($mon_msg) . "') ");
                    } else {
                        unset($info_999[$key]);
                    }
                }
            }
        }
    }
    // fin for
}
예제 #5
0
function traite_exemplaires()
{
    global $msg, $dbh;
    global $nb_expl_ignores;
    global $prix, $notice_id, $info_996, $info_995;
    // Afin de ne pas remettre en cause le script programmé en 995 :
    $info_995 = $info_996;
    // lu en 010$d de la notice
    $price = $prix[0];
    // la zone 995 est répétable
    for ($nb_expl = 0; $nb_expl < sizeof($info_995); $nb_expl++) {
        /* RAZ expl */
        $expl = array();
        /* préparation du tableau à passer à la méthode */
        $expl['notice'] = $notice_id;
        $expl['cb'] = $info_995[$nb_expl]['f'];
        $expl['cote'] = $info_995[$nb_expl]['k'];
        $expl['note'] = $info_995[$nb_expl]['u'];
        $expl['prix'] = $price;
        $expl['cote_mandatory'] = 0;
        $expl['date_depot'] = substr($info_995[$nb_expl]['m'], 0, 4) . "-" . substr($info_995[$nb_expl]['m'], 4, 2) . "-" . substr($info_995[$nb_expl]['m'], 6, 2);
        $expl['date_retour'] = substr($info_995[$nb_expl]['n'], 0, 4) . "-" . substr($info_995[$nb_expl]['n'], 4, 2) . "-" . substr($info_995[$nb_expl]['n'], 6, 2);
        // propriétaire
        $owner = array();
        $owner['lender_libelle'] = $info_995[$nb_expl]['a'];
        if (!$owner['lender_libelle']) {
            $owner['lender_libelle'] = $info_995[$nb_expl]['b'];
        }
        $expl['expl_owner'] = lender::import($owner);
        $book_lender_id = $expl['expl_owner'];
        // docs_location
        $data_doc = array();
        $data_doc['location_libelle'] = $info_995[$nb_expl]['v'];
        $data_doc['locdoc_codage_import'] = $info_995[$nb_expl]['w'];
        if (!$data_doc['locdoc_codage_import']) {
            $data_doc['locdoc_codage_import'] = $data_doc['location_libelle'];
        }
        //$data_doc['locdoc_owner'] = $book_lender_id ;
        $data_doc['locdoc_owner'] = 0;
        $expl['location'] = docs_location::import($data_doc);
        // docs_section
        $data_doc = array();
        $data_doc['section_libelle'] = $info_995[$nb_expl]['x'];
        $data_doc['sdoc_codage_import'] = $info_995[$nb_expl]['y'];
        if (!$data_doc['sdoc_codage_import']) {
            $data_doc['sdoc_codage_import'] = $data_doc['section_libelle'];
        }
        //$data_doc['sdoc_owner'] = $book_lender_id ;
        $data_doc['sdoc_owner'] = 0;
        $expl['section'] = docs_section::import($data_doc);
        // typedoc
        $data_doc = array();
        $data_doc['tdoc_libelle'] = $info_995[$nb_expl]['e'];
        $data_doc['tdoc_codage_import'] = $info_995[$nb_expl]['r'];
        if (!$data_doc['tdoc_codage_import']) {
            $data_doc['tdoc_codage_import'] = $info_995[$nb_expl]['e'];
        }
        $data_doc['duree_pret'] = 28;
        /* valeur par défaut */
        $data_doc['tdoc_owner'] = $book_lender_id;
        $expl['typdoc'] = docs_type::import($data_doc);
        // statut doc
        $data_doc = array();
        $data_doc['statut_libelle'] = $info_995[$nb_expl]['1'];
        $data_doc['statusdoc_codage_import'] = $info_995[$nb_expl]['2'];
        if (!$data_doc['statusdoc_codage_import']) {
            $data_doc['statusdoc_codage_import'] = $info_995[$nb_expl]['1'];
        }
        $data_doc['pret_flag'] = $info_995[$nb_expl]['3'];
        $data_doc['statusdoc_owner'] = $book_lender_id;
        $expl['statut'] = docs_statut::import($data_doc);
        // codestat
        $expl['codestat'] = 1;
        // quoi_faire
        // $que_faire vient du formulaire de chargement, à utiliser en attente de l'info dans la zone 996
        global $que_faire;
        if ($que_faire == "") {
            if ($info_995[$nb_expl]['0']) {
                $expl['quoi_faire'] = $info_995[$nb_expl]['0'];
            } else {
                $expl['quoi_faire'] = 2;
            }
        } else {
            $expl['quoi_faire'] = $que_faire;
        }
        // 0 : supprimer, 1 ou vide : Mettre à jour ou ajouter, 2 : ajouter si possible, sinon rien.
        $expl_id = exemplaire::import($expl);
        if ($expl_id == 0) {
            $nb_expl_ignores++;
        }
        //debug : affichage zone 995
        /*
        echo "995\$a =".$info_995[$nb_expl]['a']."<br />";
        echo "995\$b =".$info_995[$nb_expl]['b']."<br />";
        echo "995\$c =".$info_995[$nb_expl]['c']."<br />";
        echo "995\$d =".$info_995[$nb_expl]['d']."<br />";
        echo "995\$f =".$info_995[$nb_expl]['f']."<br />";
        echo "995\$k =".$info_995[$nb_expl]['k']."<br />";
        echo "995\$m =".$info_995[$nb_expl]['m']."<br />";
        echo "995\$n =".$info_995[$nb_expl]['n']."<br />";
        echo "995\$o =".$info_995[$nb_expl]['o']."<br />";
        echo "995\$q =".$info_995[$nb_expl]['q']."<br />";
        echo "995\$r =".$info_995[$nb_expl]['r']."<br />";
        echo "995\$u =".$info_995[$nb_expl]['u']."<br /><br />";
        */
    }
    // fin for
}
예제 #6
0
function traite_exemplaires()
{
    global $nb_expl_ignores, $bulletin_ex;
    global $prix, $notice_id, $info_996_9, $info_999, $typdoc_995, $tdoc_codage, $book_lender_id, $section_995, $sdoc_codage, $book_statut_id, $codstatdoc_995, $statisdoc_codage, $cote_mandatory, $book_location_id;
    global $suffix;
    // lu en 010$d de la notice
    $price = $prix[0];
    $exemplaires = array();
    for ($i = 0; $i < count($info_996_9); $i++) {
        foreach ($info_996_9[$i] as $value) {
            if (preg_match("/^(.*?):(.*)\$/", $value, $matches)) {
                $exemplaires[$i][$matches[1]] = $matches[2];
            }
        }
    }
    // la zone 995 est répétable
    for ($nb_expl = 0; $nb_expl < sizeof($exemplaires); $nb_expl++) {
        /* RAZ expl */
        $expl = array();
        $data = array();
        /*if(!$info_996[$nb_expl]['a'])$info_996[$nb_expl]['a'] ="Indéterminé";
        		$data['lender_libelle']=$info_996[$nb_expl]['a'];
        		$book_lender_id=lender::import($data);*/
        //Propriétaire
        if ($tmp = trim($exemplaires[$nb_expl]["lender_libelle"])) {
            $requete = "SELECT idlender FROM lenders WHERE lender_libelle LIKE '" . addslashes($tmp) . "'";
            $res = mysql_query($requete);
            if (mysql_num_rows($res) && ($id = mysql_result($res, 0, 0))) {
                $local_book_lender_id = $id;
            } else {
                $local_book_lender_id = $book_lender_id;
            }
        } else {
            $local_book_lender_id = $book_lender_id;
        }
        /* préparation du tableau à passer à la méthode */
        $cbarre = $exemplaires[$nb_expl]["expl_cb"];
        if (!$cbarre) {
            $mon_msg = "ERREUR : J'ai un exemplaire sans code barres il ne sera donc pas créé";
            affiche_mes_erreurs($mon_msg);
            continue;
        }
        $pb = 1;
        $num_login = 1;
        $expl['cb'] = $cbarre;
        while ($pb == 1) {
            $q = "SELECT expl_cb FROM exemplaires WHERE expl_cb='" . addslashes($expl['cb']) . "' LIMIT 1 ";
            $r = mysql_query($q);
            $nb = mysql_num_rows($r);
            if ($nb) {
                $expl['cb'] = $cbarre . "-" . $num_login;
                $num_login++;
            } else {
                $pb = 0;
            }
        }
        if ($cbarre != $expl['cb']) {
            $mon_msg = "ERREUR : l'exemplaire avec le code barres : " . $cbarre . " existe déjà donc il ne sera pas créé";
            affiche_mes_erreurs($mon_msg);
            continue;
        }
        if ($bulletin_ex) {
            $expl['bulletin'] = $bulletin_ex;
            $expl['notice'] = 0;
        } else {
            $expl['notice'] = $notice_id;
            $expl['bulletin'] = 0;
        }
        //Support exemplaire
        $data_doc = array();
        $data_doc['tdoc_libelle'] = $exemplaires[$nb_expl]["tdoc_libelle"];
        //if (!$data_doc['tdoc_libelle']) $data_doc['tdoc_libelle'] = "Indéterminé" ;
        $requete = "SELECT idtyp_doc FROM docs_type WHERE tdoc_libelle LIKE '" . addslashes($data_doc['tdoc_libelle']) . "'";
        $res = mysql_query($requete);
        if ($data_doc['tdoc_libelle'] && mysql_num_rows($res) && ($id = mysql_result($res, 0, 0))) {
            $expl['typdoc'] = $id;
        } else {
            $data_doc['duree_pret'] = 0;
            /* valeur par défaut */
            $data_doc['tdoc_codage_import'] = $exemplaires[$nb_expl]["tdoc_codage_import"];
            if ($tdoc_codage) {
                $data_doc['tdoc_owner'] = $local_book_lender_id;
            } else {
                $data_doc['tdoc_owner'] = 0;
            }
            $expl['typdoc'] = docs_type::import($data_doc);
        }
        $expl['cote'] = $exemplaires[$nb_expl]["expl_cote"];
        //Section
        $data_doc = array();
        $data_doc['section_libelle'] = $exemplaires[$nb_expl]["section_libelle"];
        $requete = "SELECT idsection FROM docs_section WHERE section_libelle LIKE '" . addslashes($data_doc['section_libelle']) . "'";
        $res = mysql_query($requete);
        if ($data_doc['section_libelle'] && mysql_num_rows($res) && ($id = mysql_result($res, 0, 0))) {
            $expl['section'] = $id;
        } else {
            $data_doc['sdoc_codage_import'] = $exemplaires[$nb_expl]["sdoc_codage_import"];
            if ($sdoc_codage) {
                $data_doc['sdoc_owner'] = $local_book_lender_id;
            } else {
                $data_doc['sdoc_owner'] = 0;
            }
            $expl['section'] = docs_section::import($data_doc);
        }
        //Statut
        $data_doc = array();
        $data_doc['statut_libelle'] = $exemplaires[$nb_expl]["statut_libelle"];
        $requete = "SELECT  idstatut FROM docs_statut WHERE statut_libelle LIKE '" . addslashes($data_doc['statut_libelle']) . "'";
        $res = mysql_query($requete);
        if ($data_doc['statut_libelle'] && mysql_num_rows($res) && ($id = mysql_result($res, 0, 0))) {
            $expl['statut'] = $id;
        } elseif ($exemplaires[$nb_expl]["statusdoc_codage_import"]) {
            $data_doc['pret_flag'] = 1;
            $data_doc['statusdoc_codage_import'] = $exemplaires[$nb_expl]["statusdoc_codage_import"];
            if ($sdoc_codage) {
                $data_doc['statusdoc_owner'] = $local_book_lender_id;
            } else {
                $data_doc['statusdoc_owner'] = 0;
            }
            $expl['statut'] = docs_statut::import($data_doc);
        } else {
            $expl['statut'] = $book_statut_id;
        }
        //Localisation
        $requete = "SELECT idlocation FROM docs_location WHERE location_libelle LIKE '" . addslashes($exemplaires[$nb_expl]["location_libelle"]) . "'";
        $res = mysql_query($requete);
        if (mysql_num_rows($res) && ($id = mysql_result($res, 0, 0))) {
            $expl['location'] = $id;
        } else {
            $expl['location'] = $book_location_id;
        }
        //Code stat
        $data_doc = array();
        $data_doc['codestat_libelle'] = $exemplaires[$nb_expl]["codestat_libelle"];
        $requete = "SELECT idcode FROM docs_codestat WHERE codestat_libelle  LIKE '" . addslashes($data_doc['codestat_libelle']) . "'";
        $res = mysql_query($requete);
        if ($data_doc['codestat_libelle'] && mysql_num_rows($res) && ($id = mysql_result($res, 0, 0))) {
            $expl['codestat'] = $id;
        } else {
            $data_doc['statisdoc_codage_import'] = $exemplaires[$nb_expl]["statisdoc_codage_import"];
            if ($statisdoc_codage) {
                $data_doc['statisdoc_owner'] = $local_book_lender_id;
            } else {
                $data_doc['statisdoc_owner'] = 0;
            }
            $expl['codestat'] = docs_codestat::import($data_doc);
        }
        $expl['creation'] = $exemplaires[$nb_expl]["create_date"];
        $expl['note'] = $exemplaires[$nb_expl]["expl_note"];
        $expl['comment'] = $exemplaires[$nb_expl]["expl_comment"];
        $expl['prix'] = $exemplaires[$nb_expl]["expl_prix"];
        $expl['expl_owner'] = $local_book_lender_id;
        $expl['cote_mandatory'] = $cote_mandatory;
        $expl['date_depot'] = $exemplaires[$nb_expl]["date_depot"];
        $expl['date_retour'] = $exemplaires[$nb_expl]["date_retour"];
        // quoi_faire
        $expl['quoi_faire'] = 2;
        $expl_id = exemplaire::import($expl);
        if ($expl_id == 0) {
            $nb_expl_ignores++;
        } else {
            //Champ perso d'exemplaire
            //echo "Passe ici<br>";
            foreach ($info_999 as $key => $value) {
                if ($value["f"] == $cbarre) {
                    //Je suis bien sur un cp de cet exemplaire
                    if (!renseigne_cp($value, $expl_id, "expl")) {
                        $mon_msg = "La valeur  : " . $value["a"] . " n'a pas été reprise dans le champ personnalisé : " . $value["n"] . " car le champ n'existe pas";
                        affiche_mes_erreurs($mon_msg);
                    } else {
                        unset($info_999[$key]);
                    }
                }
            }
        }
    }
    // fin for
}