PHP mysqlFormat函数代码示例

本文整理汇总了PHP中mysqlFormat函数的典型用法代码示例。如果您正苦于以下问题：PHP mysqlFormat函数的具体用法？PHP mysqlFormat怎么用？PHP mysqlFormat使用的例子？那么恭喜您, 这里精选的函数代码示例或许可以为您提供帮助。

在下文中一共展示了mysqlFormat函数的15个代码示例，这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞，您的评价将有助于系统推荐出更棒的PHP代码示例。

示例1: stockQte

function stockQte($exercice, $nature, $prd, $date, $valid)
{
    //ID_MOUVEMENT 	ID_CONDIT 	ID_EXERCICE 	CODE_MAGASIN 	ID_SOURCE 	MVT_DATE 	MVT_QUANTITE 	MVT_UNITE 	MVT_NATURE 	MVT_VALID
    $where = "";
    isset($exercice) && $exercice != '' ? $where .= "mouvement.ID_EXERCICE = '" . addslashes($exercice) . "' AND " : ($where .= "");
    isset($nature) && $nature != '' ? $where .= "mouvement.MVT_NATURE LIKE '" . addslashes($nature) . "' AND " : ($where .= "");
    isset($prd) && $prd != '' ? $where .= "mouvement.ID_CONDIT = '" . addslashes($prd) . "' AND " : ($where .= "");
    isset($date) && $date != '' ? $where .= "mouvement.ID_CONDIT = '" . addslashes(mysqlFormat($date)) . "' AND " : ($where .= "");
    isset($valid) && $valid != '' ? $where .= "mouvement.MVT_VALID = '" . addslashes($valid) . "' AND " : ($where .= "");
    if ($where != '') {
        $where = 'WHERE ' . substr($where, 0, strlen($where) - 4);
    }
    $sql = "SELECT SUM(MVT_QUANTITE), ID_CONDIT, ID_EXERCICE, MVT_UNITE, MVT_NATURE, MVT_VALID\r\n\tFROM `mouvement` {$where}; ";
    try {
        $cnx = new PDO(DBD, DBUSER, DBPWD, array(PDO::MYSQL_ATTR_INIT_COMMAND => "SET NAMES utf8"));
        //Connexion to database
    } catch (PDOException $error) {
        //Treat error
        //("Erreur de connexion : " . $error->getMessage() );
        header('location:errorPage.php');
    }
    $query = $cnx->prepare($sql);
    //Prepare the SQL
    $query->execute();
    //Execute prepared SQL => $query
    if ($query->rowCount()) {
        $row = $query->fetch(PDO::FETCH_ASSOC);
        return $row;
    } else {
        return array();
    }
}

开发者ID:benleibert，项目名称:channel-software，代码行数:32，代码来源:phpfuncLib+-+Copie.php

示例2: substr

 if ($in != '') {
     $in = substr($in, 0, strlen($in) - 2);
     $in = 'mouvement.CODE_PRODUIT IN (' . $in . ') AND ';
 }
 if ($where != '') {
     $where = substr($where, 0, strlen($where) - 4);
 }
 $whereAll = 'AND ' . $in . $where;
 if ($in != '') {
     $in = ' WHERE ' . substr($in, 0, strlen($in) - 4);
 }
 $_SESSION['DATA_ETAT']['exercice'] = $_POST['exercice'];
 $_SESSION['DATA_ETAT']['ligne'] = array();
 $_SESSION['DATA_ETAT']['WHERE'] = $whereAll;
 isset($_POST['datedebut']) && $_POST['datedebut'] != '' ? $d1 = mysqlFormat(trim($_POST['datedebut'])) : ($d1 = '');
 isset($_POST['datefin']) && $_POST['datefin'] != '' ? $d2 = mysqlFormat(trim($_POST['datefin'])) : ($d2 = '');
 $sql = "SELECT * FROM mouvement INNER JOIN produit ON (mouvement.CODE_PRODUIT LIKE produit.CODE_PRODUIT)\r\n\t\t\tINNER JOIN magasin ON (mouvement.CODE_MAGASIN LIKE magasin.CODE_MAGASIN)\r\n\t\t\tWHERE mouvement.MVT_TYPE LIKE 'S' AND mouvement.MVT_NATURE LIKE 'DECLASSEMENT'  {$whereAll} ORDER BY produit.PRD_LIBELLE ASC; ";
 $query = $cnx->prepare($sql);
 //Prepare the SQL
 $query->execute();
 //Execute prepared SQL => $query
 while ($row = $query->fetch(PDO::FETCH_ASSOC)) {
     //getField($key, $code, $field, $table)
     $codenature = getField('CODE_DECLASS', $row['ID_SOURCE'], 'CODENATDECLASS', 'declass');
     $nature = getField('CODENATDECLASS', $codenature, 'LIBNATDECLASS', 'natdeclass');
     //echo  'Ent'.$entree.' Sort'.$sortie.'<br>';
     array_push($_SESSION['DATA_ETAT']['ligne'], array('codeproduit' => $row['CODE_PRODUIT'], 'reflot' => $row['MVT_REFLOT'], 'produit' => addslashes($row['PRD_LIBELLE']), 'nature' => $nature, 'qte' => $row['MVT_QUANTITE'], 'unite' => $row['ID_UNITE'], 'prix' => $row['PRD_PRIXVENTE']));
 }
 $_SESSION['DATA_ETAT']['nbreLigne'] = $query->rowCount();
 //print_r($_SESSION['DATA_ETAT']);
 header('location:rapdeclassement1.php?selectedTab=rap');

开发者ID:benleibert，项目名称:channel-software，代码行数:31，代码来源:dbetat+-+Copie.php

示例3: while

                 while ($row = $query->fetch(PDO::FETCH_ASSOC)) {
                     $in .= "'" . $row['CODE_MAGASIN'] . "', ";
                 }
                 if ($in != '') {
                     $in = substr($in, 0, strlen($in) - 2);
                     $in = "  mouvement.CODE_MAGASIN IN (" . $in . ") AND ";
                 }
             }
         }
     }
 }
 $where = "";
 $whereAll = "";
 isset($_POST['exercice']) && $_POST['exercice'] != '' ? $where .= "mouvement.ID_EXERCICE = '" . addslashes(trim($_POST['exercice'])) . "' AND " : ($where .= "");
 isset($_POST['datedebut']) && $_POST['datedebut'] != '' ? $where .= "mouvement.MVT_DATE >= '" . addslashes(mysqlFormat(trim($_POST['datedebut']))) . "' AND " : ($where .= "");
 isset($_POST['datefin']) && $_POST['datefin'] != '' ? $where .= "mouvement.MVT_DATE <= '" . addslashes(mysqlFormat(trim($_POST['datefin']))) . "' AND " : ($where .= "");
 try {
     $cnx = new PDO(DBD, DBUSER, DBPWD, array(PDO::MYSQL_ATTR_INIT_COMMAND => "SET NAMES utf8"));
     //Connexion to database
 } catch (PDOException $error) {
     //Treat error
     //("Erreur de connexion : " . $error->getMessage() );
     header('location:errorPage.php');
 }
 $sql = "SELECT * FROM produit ORDER BY PRD_LIBELLE ASC; ";
 $query = $cnx->prepare($sql);
 //Prepare the SQL
 $query->execute();
 //Execute prepared SQL => $query
 if ($in != '') {
     $where = $in . $where;

开发者ID:benleibert，项目名称:channel-software，代码行数:31，代码来源:dbetat.php

示例4: updateLog

         updateLog($_SESSION['GL_USER']['MAGASIN'], $_SESSION['GL_USER']['LOGIN'], $_SESSION['GL_USER']['MLLE'], "Ajout stock entrant (" . $insert_id . ', livraison n° ' . $codelivraison . ')');
         //updateLog($username, $idcust, $action='' )
     }
     //echo  $sql2;
     unset($_SESSION['DATA_LOT']);
     header('location:lots.php?selectedTab=bde&rst=1');
     break;
 case 'update':
     isset($_POST['xid']) && $_POST['xid'] != '' ? $xid = trim($_POST['xid']) : ($xid = '');
     isset($_POST['exercice']) && $_POST['exercice'] != '' ? $exercice = trim($_POST['exercice']) : ($exercice = '');
     isset($_POST['datelivraison']) && $_POST['datelivraison'] != '' ? $datelivraison = trim($_POST['datelivraison']) : ($datelivraison = '');
     isset($_POST['libelle']) && $_POST['libelle'] != '' ? $libelle = trim($_POST['libelle']) : ($libelle = '');
     isset($_POST['commande']) && $_POST['commande'] != '0' ? $commande = trim($_POST['commande']) : ($commande = '');
     isset($_POST['codelivraison']) && $_POST['codelivraison'] != '' ? $codelivraison = trim($_POST['codelivraison']) : ($codelivraison = '');
     isset($_POST['statut']) && $_POST['statut'] != '' ? $statut = trim($_POST['statut']) : ($statut = '');
     $datelivraison = mysqlFormat($datelivraison);
     $magasin = $_SESSION['GL_USER']['MAGASIN'];
     $exercice = $_SESSION['GL_USER']['EXERCICE'];
     if ($commande != '') {
         //Insert
         $sql = "UPDATE `livraison` SET `ID_EXERCICE`='" . addslashes($exercice) . "' ,`CODE_LIVRAISON`='" . addslashes($codelivraison) . "',\r\n\t\t\t`ID_COMMANDE`='" . addslashes($commande) . "' ,`LVR_LIBELLE`='" . addslashes($libelle) . "',\t`LVR_DATE`='" . addslashes($datelivraison) . "' ,`LVR_VALIDE`='" . addslashes($statut) . "'\r\n\t\t\tWHERE ID_LIVRAISON='{$xid}'";
     } else {
         $sql = "UPDATE `livraison` SET `ID_EXERCICE`='" . addslashes($exercice) . "' ,`CODE_LIVRAISON`='" . addslashes($codelivraison) . "',\r\n\t\t\t`ID_COMMANDE`=NULL ,`LVR_DATE`='" . addslashes($datelivraison) . "' ,`LVR_LIBELLE`='" . addslashes($libelle) . "', `LVR_VALIDE`='" . addslashes($statut) . "'\r\n\t\t\tWHERE ID_LIVRAISON='{$xid}'";
     }
     try {
         $cnx = new PDO(DBD, DBUSER, DBPWD, array(PDO::MYSQL_ATTR_INIT_COMMAND => "SET NAMES utf8"));
         //Connexion to database
     } catch (PDOException $error) {
         //Treat error
         //("Erreur de connexion : " . $error->getMessage() );
         header('location:errorPage.php');

开发者ID:benleibert，项目名称:channel-software，代码行数:31，代码来源:dblot.php

示例5: elseif

     } elseif ($code_detlivraison == '' && $oldcodeproduit == '' && $codeproduit != '' && $produit != '' && $qtelvr != '') {
         if ($commande != '') {
             $numautoDetLiv++;
             $codeDetLiv = "{$numautoDetLiv}/{$magasin}";
             $monlot = "LOT/{$numautoDetLiv}/{$i}";
             $sql1 .= "INSERT INTO `detlivraison` (`CODE_DETLIVRAISON`, `CODE_PRODUIT`, `CODE_LIVRAISON`, `CODE_MAGASIN`, `ID_DETLIVRAISON`, `LVR_PRDQTE`,\r\n\t\t\t\t\t`LVR_PRDRECU`,  `LVR_UNITE`, `LVR_IDCOMMANDE`, `LVR_MAGASIN`, `LVR_PA`, `LVR_REFLOT`, `LVR_DATEPEREMP`, `LVR_MONLOT`)\r\n\t\t\t\t\tVALUES ('" . addslashes($codeDetLiv) . "',  '" . addslashes($codeproduit) . "',  '" . addslashes($xid) . "', '" . addslashes($magasin) . "', '" . addslashes($numautoDetLiv) . "',\r\n\t\t\t\t\t'" . addslashes($qte) . "' , '" . addslashes($qtelvr) . "', '" . addslashes($unite) . "', '" . addslashes($commande) . "','" . addslashes($magasin) . "',\r\n\t\t\t\t\t'" . addslashes($prix) . "', '" . addslashes($reflot) . "', '" . addslashes(mysqlFormat($dateperemp)) . "', '" . addslashes($monlot) . "'); ";
         } else {
             $numautoDetLiv++;
             $codeDetLiv = "{$numautoDetLiv}/{$magasin}";
             $monlot = "LOT/{$numautoDetLiv}/{$i}";
             $sql1 .= "INSERT INTO `detlivraison` (`CODE_DETLIVRAISON`, `CODE_PRODUIT`, `CODE_LIVRAISON`, `CODE_MAGASIN`, `ID_DETLIVRAISON`, `LVR_PRDQTE`,\r\n\t\t\t\t\t`LVR_PRDRECU`,  `LVR_UNITE`, `LVR_IDCOMMANDE`, `LVR_MAGASIN`, `LVR_PA`, `LVR_REFLOT`, `LVR_DATEPEREMP`, `LVR_MONLOT`)\r\n\t\t\t\t\tVALUES ('" . addslashes($codeDetLiv) . "',  '" . addslashes($codeproduit) . "',  '" . addslashes($xid) . "', '" . addslashes($magasin) . "', '" . addslashes($numautoDetLiv) . "',\r\n\t\t\t\t\t'" . addslashes($qte) . "' , '" . addslashes($qtelvr) . "', '" . addslashes($unite) . "', '" . addslashes($commande) . "','" . addslashes($magasin) . "',\r\n\t\t\t\t\t'" . addslashes($prix) . "', '" . addslashes($reflot) . "', '" . addslashes(mysqlFormat($dateperemp)) . "', '" . addslashes($monlot) . "'); ";
         }
         $numautoMvt++;
         $numautoDetLiv = myDbLastId('detlivraison', 'ID_DETLIVRAISON', $magasin);
         $codeMvt = "{$numautoMvt}/{$magasin}";
         $sql2 .= "INSERT INTO `mouvement` (`CODE_MOUVEMENT`, `ID_EXERCICE`, `CODE_PRODUIT`, `CODE_MAGASIN`, `ID_MOUVEMENT`, `ID_SOURCE`,\r\n\t\t\t\t`MVT_DATE`, `MVT_TIME`, `MVT_QUANTITE`, `MVT_UNITE`, `MVT_NATURE`, `MVT_VALID`, `MVT_DATEVALID`, `MVT_TYPE`, `MVT_REFLOT`,\r\n\t\t\t\t`MVT_DATEPEREMP`,  `MVT_PA`,  `MVT_MONLOT`)\r\n\t\t\t\tVALUES ('" . addslashes($codeMvt) . "',  '" . addslashes($exercice) . "','" . addslashes($codeproduit) . "',\t'" . addslashes($magasin) . "',\r\n\t\t\t\t'" . addslashes($numautoMvt) . "', '" . addslashes($xid) . "', '" . addslashes($datelivraison) . "' ,'" . addslashes(date('H:i:s')) . "' ,\r\n\t\t\t\t'" . addslashes($qtelvr) . "' ,\t'" . addslashes($unite) . "', 'LIVRAISON', '{$statut}', '" . date('Y-m-d H:i:s') . "','E','" . addslashes($reflot) . "',\r\n\t\t\t\t'" . addslashes(mysqlFormat($dateperemp)) . "', '" . addslashes($prix) . "', '" . addslashes($monlot) . "') ; ";
     }
 }
 if ($sql1 != '') {
     $query = $cnx->prepare($sql1);
     //Prepare the SQL
     $query->execute();
     //Execute prepared SQL =>
     updateLog($_SESSION['GL_USER']['MAGASIN'], $_SESSION['GL_USER']['LOGIN'], $_SESSION['GL_USER']['MLLE'], 'Modification des lignes de livraison(' . $xid . ', Livraison n°' . $reflivraison . ')');
     //updateLog($username, $idcust, $action='' )
     $query = $cnx->prepare($sql2);
     //Prepare the SQL
     $query->execute();
     //Execute prepared SQL => $query
     updateLog($_SESSION['GL_USER']['MAGASIN'], $_SESSION['GL_USER']['LOGIN'], $_SESSION['GL_USER']['MLLE'], "Modification d'un mouvement(" . $xid . ', livraison n°' . $reflivraison . ')');
     //updateLog($username, $idcust, $action='' )

开发者ID:benleibert，项目名称:channel-software，代码行数:31，代码来源:dblivraison.php

示例6: isset

isset($_GET['page']) ? $page = $_GET['page'] : ($page = 1);
isset($_POST['viewLength']) ? $_SESSION['GL_USER']['ELEMENT'] = $_POST['viewLength'] : '';
//
if (isset($_GET['do']) && $_GET['do'] == "search") {
    $where = "  autrelivr.CODE_MAGASIN LIKE '" . $_SESSION['GL_USER']['MAGASIN'] . "' AND ";
    isset($_POST['datelivraison']) && $_POST['datelivraison'] != '' ? $date1 = $_POST['datelivraison'] : ($date1 = '');
    isset($_POST['datelivraison1']) && $_POST['datelivraison1'] != '' ? $date2 = $_POST['datelivraison1'] : ($date2 = '');
    isset($_POST['codelivraison']) && $_POST['codelivraison'] != '' ? $where .= "autrelivr.CODE_AUTRELIVR LIKE '" . addslashes(trim($_POST['codelivraison'])) . "' AND " : ($where .= "");
    isset($_POST['codesourcelivraison']) && $_POST['codesourcelivraison'] != '' ? $where .= "autrelivr.AUL_SOUCRE LIKE '" . addslashes(trim($_POST['codesourcelivraison'])) . "' AND " : ($where .= "");
    //(isset($_POST['datelivraison']) && $_POST['datelivraison']!='' 			? 	$where .="autrelivr.AUL_DATE = '".addslashes(mysqlFormat(trim($_POST['datelivraison'])))."' AND " 	: $where .="");
    if ($date1 != '' && $date2 != '') {
        $where .= "autrelivr.AUL_DATE >= '" . addslashes(mysqlFormat(trim($date1))) . "' AND autrelivr.AUL_DATE <= '" . addslashes(mysqlFormat(trim($date2))) . "' AND ";
    } elseif ($date1 == '' && $date2 != '') {
        $where .= "autrelivr.AUL_DATE >= '" . addslashes(mysqlFormat(trim($date2))) . "' AND autrelivr.AUL_DATE <= '" . addslashes(mysqlFormat(trim($date2))) . "' AND ";
    } elseif ($date1 != '' && $date2 == '') {
        $where .= "autrelivr.AUL_DATE >= '" . addslashes(mysqlFormat(trim($date1))) . "' AND autrelivr.AUL_DATE <= '" . addslashes(mysqlFormat(trim($date1))) . "' AND ";
    }
    isset($_POST['autreinfo']) && $_POST['autreinfo'] != '' ? $where .= "autrelivr.AUL_DETAIL LIKE '" . addslashes(trim($_POST['autreinfo'])) . "%' AND " : ($where .= "");
    isset($_POST['statut']) && $_POST['statut'] == '1' ? $where .= "autrelivr.AUL_VALIDE = '" . addslashes(trim($_POST['statut'])) . "' AND " : ($where .= "");
    if ($where != '') {
        $where = substr($where, 0, strlen($where) - 4);
        $_SESSION['WHERE'] = $where;
    } elseif ($_SESSION['WHERE'] != '') {
        $where = $_SESSION['WHERE'];
    }
    $link = 'otherdelivery.php?selectedTab=cde&do=search';
    $retour = ligneConOtherdelivery($where, '', '', $page, $_SESSION['GL_USER']['ELEMENT']);
    //$where, $order, $sens, $page=1, $nelt
} else {
    $link = 'otherdelivery.php?selectedTab=cde';
    $retour = ligneConOtherdelivery('autrelivr.ID_EXERCICE=' . $_SESSION['GL_USER']['EXERCICE'] . " AND CODE_MAGASIN LIKE '" . $_SESSION['GL_USER']['MAGASIN'] . "'", '', '', $page, $_SESSION['GL_USER']['ELEMENT']);

开发者ID:benleibert，项目名称:channel-software，代码行数:31，代码来源:otherdelivery.php

示例7: isset

isset($_GET['page']) ? $page = $_GET['page'] : ($page = 1);
isset($_POST['viewLength']) ? $_SESSION['GL_USER']['ELEMENT'] = $_POST['viewLength'] : '';
//
if (isset($_GET['do']) && $_GET['do'] == "search") {
    $where = "  livraison.CODE_MAGASIN LIKE '" . $_SESSION['GL_USER']['MAGASIN'] . "' AND ";
    isset($_POST['datelivraison']) && $_POST['datelivraison'] != '' ? $date1 = $_POST['datelivraison'] : ($date1 = '');
    isset($_POST['datelivraison1']) && $_POST['datelivraison1'] != '' ? $date2 = $_POST['datelivraison1'] : ($date2 = '');
    isset($_POST['exercice']) && $_POST['exercice'] != '' ? $where .= "livraison.ID_EXERCICE = '" . addslashes(trim($_POST['exercice'])) . "' AND " : ($where .= "");
    isset($_POST['commande']) && $_POST['commande'] != '0' ? $where .= "livraison.ID_COMMANDE = '" . addslashes(trim($_POST['commande'])) . "' AND " : ($where .= "");
    isset($_POST['codelivraison']) && $_POST['codelivraison'] != '' ? $where .= "livraison.CODE_LIVRAISON = '" . addslashes(trim($_POST['codelivraison'])) . "' AND " : ($where .= "");
    if ($date1 != '' && $date2 != '') {
        $where .= "livraison.LVR_DATE >= '" . addslashes(mysqlFormat(trim($date1))) . "' AND livraison.LVR_DATE <= '" . addslashes(mysqlFormat(trim($date2))) . "' AND ";
    } elseif ($date1 == '' && $date2 != '') {
        $where .= "livraison.LVR_DATE >= '" . addslashes(mysqlFormat(trim($date2))) . "' AND livraison.LVR_DATE <= '" . addslashes(mysqlFormat(trim($date2))) . "' AND ";
    } elseif ($date1 != '' && $date2 == '') {
        $where .= "livraison.LVR_DATE >= '" . addslashes(mysqlFormat(trim($date1))) . "' AND livraison.LVR_DATE <= '" . addslashes(mysqlFormat(trim($date1))) . "' AND ";
    }
    isset($_POST['statut']) && $_POST['statut'] == '1' ? $where .= "livraison.LVR_VALIDE = '" . addslashes(trim($_POST['statut'])) . "' AND " : ($where .= "");
    if ($where != '') {
        $where = substr($where, 0, strlen($where) - 4);
        $_SESSION['WHERE'] = $where;
    } elseif ($_SESSION['WHERE'] != '') {
        $where = $_SESSION['WHERE'];
    }
    $link = 'lot.php?selectedTab=bde&do=search';
    $retour = ligneConLot($where, '', '', $page, $_SESSION['GL_USER']['ELEMENT']);
    //$where, $order, $sens, $page=1, $nelt
} else {
    $link = 'lot.php?selectedTab=bde';
    $retour = ligneConLot('livraison.ID_EXERCICE=' . $_SESSION['GL_USER']['EXERCICE'] . "  AND livraison.CODE_MAGASIN LIKE '" . $_SESSION['GL_USER']['MAGASIN'] . "'", '', '', $page, $_SESSION['GL_USER']['ELEMENT']);
    //$where, $order, $sens, $page=1, $nelt

开发者ID:benleibert，项目名称:channel-software，代码行数:31，代码来源:lots.php

示例8: isset

}
isset($_GET['page']) ? $page = $_GET['page'] : ($page = 1);
isset($_POST['viewLength']) ? $_SESSION['GL_USER']['ELEMENT'] = $_POST['viewLength'] : '';
//
if (isset($_GET['do']) && $_GET['do'] == "search") {
    isset($_POST['datereversement']) && $_POST['datereversement'] != '' ? $date1 = $_POST['datereversement'] : ($date1 = '');
    isset($_POST['datereversement1']) && $_POST['datereversement1'] != '' ? $date2 = $_POST['datereversement1'] : ($date2 = '');
    $where = "  CODE_MAGASIN LIKE '" . $_SESSION['GL_USER']['MAGASIN'] . "' AND ";
    isset($_POST['exercice']) && $_POST['exercice'] != '' ? $where .= "reversement.ID_EXERCICE = '" . addslashes(trim($_POST['exercice'])) . "' AND " : ($where .= "");
    //(isset($_POST['datereversement']) && $_POST['datereversement']!='' 	? 	$where .="reversement.REV_DATE = '".addslashes(mysqlFormat(trim($_POST['datereversement'])))."' AND " 	: $where .="");
    if ($date1 != '' && $date2 != '') {
        $where .= "reversement.REV_DATE >= '" . addslashes(mysqlFormat(trim($date1))) . "' AND reversement.REV_DATE <= '" . addslashes(mysqlFormat(trim($date2))) . "' AND ";
    } elseif ($date1 == '' && $date2 != '') {
        $where .= "reversement.REV_DATE >= '" . addslashes(mysqlFormat(trim($date2))) . "' AND reversement.REV_DATE <= '" . addslashes(mysqlFormat(trim($date2))) . "' AND ";
    } elseif ($date1 != '' && $date2 == '') {
        $where .= "reversement.REV_DATE >= '" . addslashes(mysqlFormat(trim($date1))) . "' AND reversement.REV_DATE <= '" . addslashes(mysqlFormat(trim($date1))) . "' AND ";
    }
    isset($_POST['programmation']) && $_POST['programmation'] != '0' ? $where .= "reversement.ID_PROGR = '" . addslashes(trim($_POST['programmation'])) . "' AND " : ($where .= "");
    isset($_POST['statut']) && $_POST['statut'] == '1' ? $where .= "reversement.REV_VALID = '" . addslashes(trim($_POST['statut'])) . "' AND " : ($where .= "");
    if ($where != '') {
        $where = substr($where, 0, strlen($where) - 4);
        $_SESSION['WHERE'] = $where;
    } elseif ($_SESSION['WHERE'] != '') {
        $where = $_SESSION['WHERE'];
    }
    $link = 'reversement.php?selectedTab=prg&do=search';
    $retour = ligneConReversement($where, '', '', $page, $_SESSION['GL_USER']['ELEMENT']);
    //$where, $order, $sens, $page=1, $nelt
} else {
    $link = 'reversement.php?selectedTab=prg';
    $retour = ligneConReversement('reversement.ID_EXERCICE=' . $_SESSION['GL_USER']['EXERCICE'] . " AND CODE_MAGASIN LIKE '" . $_SESSION['GL_USER']['MAGASIN'] . "' ", '', '', $page, $_SESSION['GL_USER']['ELEMENT']);

开发者ID:benleibert，项目名称:channel-software，代码行数:31，代码来源:reversement.php

示例9: stripslashes

    $text = "Une erreur s'est produite";
    $msg = '<div class="errorMsg">' . stripslashes($text) . '</div>';
}
isset($_GET['page']) ? $page = $_GET['page'] : ($page = 1);
isset($_POST['viewLength']) ? $_SESSION['GL_USER']['ELEMENT'] = $_POST['viewLength'] : '';
//
if (isset($_GET['do']) && $_GET['do'] == "search") {
    $where = " (report.CODE_MAGASIN LIKE '" . addslashes(trim($_SESSION['GL_USER']['MAGASIN'])) . "' OR report.MAG_CODE_MAGASIN LIKE '" . addslashes(trim($_SESSION['GL_USER']['MAGASIN'])) . "') AND ";
    isset($_POST['datereport']) && $_POST['datereport'] != '' ? $date1 = $_POST['datereport'] : ($date1 = '');
    isset($_POST['datereport1']) && $_POST['datereport1'] != '' ? $date2 = $_POST['datereport1'] : ($date2 = '');
    if ($date1 != '' && $date2 != '') {
        $where .= "report.REP_DATE >= '" . addslashes(mysqlFormat(trim($date1))) . "' AND report.REP_DATE <= '" . addslashes(mysqlFormat(trim($date2))) . "' AND ";
    } elseif ($date1 == '' && $date2 != '') {
        $where .= "report.REP_DATE >= '" . addslashes(mysqlFormat(trim($date2))) . "' AND report.REP_DATE <= '" . addslashes(mysqlFormat(trim($date2))) . "' AND ";
    } elseif ($date1 != '' && $date2 == '') {
        $where .= "report.REP_DATE >= '" . addslashes(mysqlFormat(trim($date1))) . "' AND report.REP_DATE <= '" . addslashes(mysqlFormat(trim($date1))) . "' AND ";
    }
    isset($_POST['statut']) && $_POST['statut'] == '1' ? $where .= "report.TRS_VALIDE = '" . addslashes(trim($_POST['statut'])) . "' AND " : ($where .= "");
    if ($where != '') {
        $where = substr($where, 0, strlen($where) - 4);
        $_SESSION['WHERE'] = $where;
    } elseif ($_SESSION['WHERE'] != '') {
        $where = $_SESSION['WHERE'];
    }
    $link = 'report.php?selectedTab=bds&do=search';
    $retour = ligneConreport($where, '', '', $page, $_SESSION['GL_USER']['ELEMENT']);
    //$where, $order, $sens, $page=1, $nelt
} else {
    $link = 'report.php?selectedTab=bds';
    $retour = ligneConreport('report.ID_EXERCICE=' . $_SESSION['GL_USER']['EXERCICE'] . " AND (report.CODE_MAGASIN LIKE '" . addslashes(trim($_SESSION['GL_USER']['MAGASIN'])) . "' OR report.MAG_CODE_MAGASIN LIKE '" . addslashes(trim($_SESSION['GL_USER']['MAGASIN'])) . "') ", '', '', $page, $_SESSION['GL_USER']['ELEMENT']);
    //$where, $order, $sens, $page=1, $nelt

开发者ID:benleibert，项目名称:channel-software，代码行数:31，代码来源:report.php

示例10: unset

     }
     unset($_SESSION['DATA_TRS']);
     //echo $sql1, '<br><br>',$sql2;
     header('location:transfert.php?selectedTab=bds&rst=1');
     break;
 case 'validate2':
     isset($_POST['xid']) && $_POST['xid'] != '' ? $xid = trim($_POST['xid']) : ($xid = '');
     isset($_POST['exercice']) && $_POST['exercice'] != '' ? $exercice = trim($_POST['exercice']) : ($exercice = '');
     isset($_POST['datetransfert']) && $_POST['datetransfert'] != '' ? $datetransfert = trim($_POST['datetransfert']) : ($datetransfert = '');
     isset($_POST['reftransfert']) && $_POST['reftransfert'] != '' ? $reftransfert = trim($_POST['reftransfert']) : ($reftransfert = '');
     isset($_POST['magasin_srce']) && $_POST['magasin_srce'] != '' ? $magasin_srce = trim($_POST['magasin_srce']) : ($magasin_srce = '');
     isset($_POST['nature']) && $_POST['nature'] != '0' ? $nature = trim($_POST['nature']) : ($nature = '');
     isset($_POST['libelleetat']) && $_POST['libelleetat'] != '' ? $libelleetat = trim($_POST['libelleetat']) : ($libelleetat = '');
     isset($_POST['nbreLigne']) && $_POST['nbreLigne'] != '' ? $nbreLigne = trim($_POST['nbreLigne']) : ($nbreLigne = '');
     isset($_POST['statut']) && $_POST['statut'] == '1' ? $statut = trim($_POST['statut']) : ($statut = '0');
     $datetransfert = mysqlFormat($datetransfert);
     $vdate = '0000-00-00';
     $magasin = $_SESSION['GL_USER']['MAGASIN'];
     //Insert
     $sql = "UPDATE `transfert` SET `TRS_VALIDE`= '{$statut}',`TRS_DATEVALID`='" . date('Y-m-d H:i:s') . "'  WHERE CODE_TRANSFERT LIKE '" . addslashes($xid) . "'; ";
     //echo $sql;
     try {
         $cnx = new PDO(DBD, DBUSER, DBPWD, array(PDO::MYSQL_ATTR_INIT_COMMAND => "SET NAMES utf8"));
         //Connexion to database
     } catch (PDOException $error) {
         //Treat error
         //("Erreur de connexion : " . $error->getMessage() );
         header('location:errorPage.php');
     }
     $query = $cnx->prepare($sql);
     //Prepare the SQL

开发者ID:benleibert，项目名称:channel-software，代码行数:31，代码来源:dbtransfert+-+Copie.php

示例11: getDroit

require_once '../lib/phpfuncLib.php';
//All commun functions
require_once 'menus.php';
require_once 'funcresponsable.php';
$droit = getDroit('GRP_PERSONNEL ,GRP_UTILISATEUR, GRP_GROUPE, GRP_LOG,	GRP_CATEGORIE, GRP_PRODUIT,	GRP_CONDITIONNEMENT, GRP_UNITE, GRP_BAREME, GRP_REGION, GRP_PROVINCE, GRP_TYPESERVICE, GRP_SERVICE, GRP_MAGASIN, GRP_RESPONSABLE, GRP_FOURNISSEUR, GRP_TYPEBENEFICIAIRE, GRP_BENEFICIAIRE, GRP_AFFECTATION, GRP_DONNANNUELLE, GRP_EXERCICE, GRP_TYPEDOTATION, GRP_PARAMETRE, GRP_DB', $_SESSION['GL_USER']['GROUPE']);
$droitTOPMENUS = getDroitTOPMENUS($_SESSION['GL_USER']['GROUPE']);
$droitMAJ = getDroitMAJ('GRP_RESPONSABLE', $_SESSION['GL_USER']['GROUPE']);
isset($_GET['page']) ? $page = $_GET['page'] : ($page = 1);
isset($_POST['viewLength']) ? $_SESSION['GL_USER']['ELEMENT'] = $_POST['viewLength'] : '';
//
if (isset($_GET['do']) && $_GET['do'] == "search") {
    $where = "";
    isset($_POST['personnel']) && $_POST['personnel'] != '0' ? $where .= "respmagasin.NUM_MLLE = '" . addslashes(trim($_POST['personnel'])) . "' AND " : ($where .= "");
    isset($_POST['magasin']) && $_POST['magasin'] != '0' ? $where .= "respmagasin.CODE_MAGASIN LIKE '" . addslashes(trim($_POST['magasin'])) . "' AND " : ($where .= "");
    isset($_POST['datedebut']) && $_POST['datedebut'] != '' ? $where .= "respmagasin.RES_DATEDEBUT >= '" . mysqlFormat(trim($_POST['datedebut'])) . "' AND " : ($where .= "");
    isset($_POST['datefin']) && $_POST['datefin'] != '' ? $where .= "respmagasin.RES_DATEFIN <= '" . mysqlFormat(trim($_POST['datefin'])) . "' AND " : ($where .= "");
    if ($where != '') {
        $where = substr($where, 0, strlen($where) - 4);
        $_SESSION['WHERE'] = $where;
    } elseif ($_SESSION['WHERE'] != '') {
        $where = $_SESSION['WHERE'];
    }
    $link = 'magasin.php?selectedTab=par&do=search';
    $retour = ligneConResponsable($where, '', '', $page, $_SESSION['GL_USER']['ELEMENT']);
    //$where, $order, $sens, $page=1, $nelt
} else {
    $link = 'magasin.php?selectedTab=par';
    $retour = ligneConResponsable('', '', '', $page, $_SESSION['GL_USER']['ELEMENT']);
    //$where, $order, $sens, $page=1, $nelt
}
$pageLengh = pageLengh($_SESSION['GL_USER']['ELEMENT']);

开发者ID:benleibert，项目名称:channel-software，代码行数:31，代码来源:responsable.php

示例12: stripslashes

    $msg = '<div class="errorMsg">' . stripslashes($text) . '</div>';
}
isset($_GET['page']) ? $page = $_GET['page'] : ($page = 1);
isset($_POST['viewLength']) ? $_SESSION['GL_USER']['ELEMENT'] = $_POST['viewLength'] : '';
//
if (isset($_GET['do']) && $_GET['do'] == "search") {
    $where = " (transfert.CODE_MAGASIN LIKE '" . addslashes(trim($_SESSION['GL_USER']['MAGASIN'])) . "' ) AND ";
    isset($_POST['codetransfert']) && $_POST['codetransfert'] != '' ? $where .= "transfert.CODE_TRANSFERT LIKE '" . addslashes(trim($_POST['codetransfertement'])) . "' AND " : ($where .= "");
    isset($_POST['datetransfert']) && $_POST['datetransfert'] != '' ? $date1 = $_POST['datetransfert'] : ($date1 = '');
    isset($_POST['datetransfert1']) && $_POST['datetransfert1'] != '' ? $date2 = $_POST['datetransfert1'] : ($date2 = '');
    if ($date1 != '' && $date2 != '') {
        $where .= "transfert.TRS_DATE >= '" . addslashes(mysqlFormat(trim($date1))) . "' AND transfert.TRS_DATE <= '" . addslashes(mysqlFormat(trim($date2))) . "' AND ";
    } elseif ($date1 == '' && $date2 != '') {
        $where .= "transfert.TRS_DATE >= '" . addslashes(mysqlFormat(trim($date2))) . "' AND transfert.TRS_DATE <= '" . addslashes(mysqlFormat(trim($date2))) . "' AND ";
    } elseif ($date1 != '' && $date2 == '') {
        $where .= "transfert.TRS_DATE >= '" . addslashes(mysqlFormat(trim($date1))) . "' AND transfert.TRS_DATE <= '" . addslashes(mysqlFormat(trim($date1))) . "' AND ";
    }
    isset($_POST['statut']) && $_POST['statut'] == '1' ? $where .= "transfert.TRS_VALIDE = '" . addslashes(trim($_POST['statut'])) . "' AND " : ($where .= "");
    if ($where != '') {
        $where = substr($where, 0, strlen($where) - 4);
        $_SESSION['WHERE'] = $where;
    } elseif ($_SESSION['WHERE'] != '') {
        $where = $_SESSION['WHERE'];
    }
    $link = 'transfert.php?selectedTab=bds&do=search';
    $retour = ligneConTransfert($where, '', '', $page, $_SESSION['GL_USER']['ELEMENT']);
    //$where, $order, $sens, $page=1, $nelt
} else {
    $link = 'transfert.php?selectedTab=bds';
    $retour = ligneConTransfert('transfert.ID_EXERCICE=' . $_SESSION['GL_USER']['EXERCICE'] . " AND (transfert.CODE_MAGASIN LIKE '" . addslashes(trim($_SESSION['GL_USER']['MAGASIN'])) . "' ) ", '', '', $page, $_SESSION['GL_USER']['ELEMENT']);
    //$where, $order, $sens, $page=1, $nelt

开发者ID:benleibert，项目名称:channel-software，代码行数:31，代码来源:transfert.php

示例13: updateLog

         //Execute prepared SQL => $query
         updateLog($_SESSION['GL_USER']['MAGASIN'], $_SESSION['GL_USER']['LOGIN'], $_SESSION['GL_USER']['MLLE'], 'Modification d\'un mouvement(' . $xid . ', déclassement n°' . $codereconditionnement . ')');
         //updateLog($username, $idcust, $action='' )
     }
     unset($_SESSION['DATA_RECD']);
     header('location:reconditionnement.php?selectedTab=mvt&rst=1');
     break;
 case 'update':
     isset($_POST['xid']) && $_POST['xid'] != '' ? $xid = trim($_POST['xid']) : ($xid = '');
     isset($_POST['exercice']) && $_POST['exercice'] != '' ? $exercice = trim($_POST['exercice']) : ($exercice = '');
     isset($_POST['datesortie']) && $_POST['datesortie'] != '' ? $datesortie = trim($_POST['datesortie']) : ($datesortie = '');
     isset($_POST['codereconditionnement']) && $_POST['codereconditionnement'] != '' ? $codereconditionnement = trim($_POST['codereconditionnement']) : ($codereconditionnement = '');
     isset($_POST['raison']) && $_POST['raison'] != '' ? $raison = trim($_POST['raison']) : ($raison = '');
     isset($_POST['nbreLigne']) && $_POST['nbreLigne'] != '' ? $nbreLigne = trim($_POST['nbreLigne']) : ($nbreLigne = '');
     isset($_POST['statut']) && $_POST['statut'] == '1' ? $statut = trim($_POST['statut']) : ($statut = '0');
     $datesortie = mysqlFormat($datesortie);
     $magasin = 'MAG0';
     //Insert
     $sql = "UPDATE `recondit` SET `ID_EXERCICE`='" . addslashes($exercice) . "' ,`REC_RAISON`='" . addslashes($raison) . "' ,`REC_DATESORTIE`='" . addslashes($datesortie) . "'  ,`REC_VALIDE`='{$statut}' ,`CODE_RECOND`='" . addslashes($codereconditionnement) . "') ";
     $sql .= "WHERE ID_RECONDIT='{$xid}'";
     try {
         $cnx = new PDO(DBD, DBUSER, DBPWD, array(PDO::MYSQL_ATTR_INIT_COMMAND => "SET NAMES utf8"));
         //Connexion to database
     } catch (PDOException $error) {
         //Treat error
         //("Erreur de connexion : " . $error->getMessage() );
         header('location:errorPage.php');
     }
     $query = $cnx->prepare($sql);
     //Prepare the SQL
     $query->execute();

开发者ID:benleibert，项目名称:channel-software，代码行数:31，代码来源:dbreconditionnement2.php

示例14: elseif

} elseif (isset($_GET['rs']) && $_GET['rs'] == 4) {
    $text = "Les données ont été supprimées";
    $msg = '<div class="okMsg">' . stripslashes($text) . '</div>';
} elseif (isset($_GET['rs']) && $_GET['rs'] == 0) {
    $text = "Une erreur s'est produite";
    $msg = '<div class="errorMsg">' . stripslashes($text) . '</div>';
}
isset($_GET['page']) ? $page = $_GET['page'] : ($page = 1);
isset($_POST['viewLength']) ? $_SESSION['GL_USER']['ELEMENT'] = $_POST['viewLength'] : '';
//
if (isset($_GET['do']) && $_GET['do'] == "search") {
    $where = "  CODE_MAGASIN LIKE '" . $_SESSION['GL_USER']['MAGASIN'] . "' AND ";
    isset($_POST['exercice']) && $_POST['exercice'] != '' ? $where .= "inventaire.ID_EXERCICE = '" . addslashes(trim($_POST['exercice'])) . "' AND " : ($where .= "");
    isset($_POST['inventaire']) && $_POST['inventaire'] != '' ? $where .= "livraison.INV_LIBELLE = '" . addslashes(trim($_POST['inventaire'])) . "%' AND " : ($where .= "");
    isset($_POST['codeinventaire']) && $_POST['codeinventaire'] != '' ? $where .= "inventaire.CODE_INVENTAIRE = '" . addslashes(trim($_POST['codeinventaire'])) . "' AND " : ($where .= "");
    isset($_POST['dateinventaire']) && $_POST['dateinventaire'] != '' ? $where .= "inventaire.INV_DATE = '" . addslashes(mysqlFormat(trim($_POST['dateinventaire']))) . "' AND " : ($where .= "");
    isset($_POST['statut']) && $_POST['statut'] == '1' ? $where .= "inventaire.INV_VALIDE = '" . addslashes(trim($_POST['statut'])) . "' AND " : ($where .= "");
    if ($where != '') {
        $where = substr($where, 0, strlen($where) - 4);
        $_SESSION['WHERE'] = $where;
    } elseif ($_SESSION['WHERE'] != '') {
        $where = $_SESSION['WHERE'];
    }
    $link = 'inventaire.php?selectedTab=cde&do=search';
    $retour = ligneConInventarie($where, '', '', $page, $_SESSION['GL_USER']['ELEMENT']);
    //$where, $order, $sens, $page=1, $nelt
} else {
    $link = 'inventaire.php?selectedTab=cde';
    $retour = ligneConInventarie('inventaire.ID_EXERCICE=' . $_SESSION['GL_USER']['EXERCICE'] . " AND CODE_MAGASIN LIKE '" . $_SESSION['GL_USER']['MAGASIN'] . "'", '', '', $page, $_SESSION['GL_USER']['ELEMENT']);
    //$where, $order, $sens, $page=1, $nelt
}

开发者ID:benleibert，项目名称:channel-software，代码行数:31，代码来源:inventaire.php

示例15: updateLog

     //Prepare the SQL
     $query->execute();
     //Execute prepared SQL => $query
     updateLog($_SESSION['GL_USER']['MAGASIN'], $_SESSION['GL_USER']['LOGIN'], $_SESSION['GL_USER']['MLLE'], 'Ajout d\'un responsable (' . $personnel . ', ' . $personnel . ')');
     //updateLog($username, $idcust, $action='' )
     header('location:responsable.php?selectedTab=par&rs=1');
     break;
     //SERVICE
 //SERVICE
 case 'update':
     isset($_POST['magasin']) && $_POST['magasin'] != '0' ? $magasin = trim($_POST['magasin']) : ($magasin = '');
     isset($_POST['personnel']) && $_POST['personnel'] != '0' ? $personnel = trim($_POST['personnel']) : ($personnel = '');
     isset($_POST['datedebut']) && $_POST['datedebut'] != '' ? $datedebut = trim($_POST['datedebut']) : ($datedebut = '');
     isset($_POST['datefin']) && $_POST['datefin'] != '' ? $datefin = trim($_POST['datefin']) : ($datefin = '');
     $datedebut = mysqlFormat($datedebut);
     $datefin = mysqlFormat($datefin);
     isset($_POST['id']) && $_POST['id'] != '' ? $id = trim($_POST['id']) : ($id = '');
     //SQL
     $sql = "UPDATE `respmagasin` SET `NUM_MLLE`='" . addslashes($personnel) . "' ,`CODE_MAGASIN`='" . addslashes($magasin) . "' ,`RES_DATEDEBUT`='" . addslashes($datedebut) . "' ,\r\n\t\t`RES_DATEFIN`='" . addslashes($datefin) . "'  WHERE ID_RESPO={$id}";
     try {
         $cnx = new PDO(DBD, DBUSER, DBPWD, array(PDO::MYSQL_ATTR_INIT_COMMAND => "SET NAMES utf8"));
         //Connexion to database
     } catch (PDOException $error) {
         //Treat error
         //("Erreur de connexion : " . $error->getMessage() );
         header('location:errorPage.php');
     }
     $query = $cnx->prepare($sql);
     //Prepare the SQL
     $query->execute();
     //Execute prepared SQL => $query

开发者ID:benleibert，项目名称:channel-software，代码行数:31，代码来源:dbresponsable.php

注：本文中的mysqlFormat函数示例由纯净天空整理自Github/MSDocs等开源代码及文档管理平台，相关代码片段筛选自各路编程大神贡献的开源项目，源码版权归原作者所有，传播和使用请参考对应项目的License；未经允许，请勿转载。