本文整理汇总了PHP中frFormat2函数的典型用法代码示例。如果您正苦于以下问题:PHP frFormat2函数的具体用法?PHP frFormat2怎么用?PHP frFormat2使用的例子?那么恭喜您, 这里精选的函数代码示例或许可以为您提供帮助。
在下文中一共展示了frFormat2函数的20个代码示例,这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞,您的评价将有助于我们的系统推荐出更棒的PHP代码示例。
示例1: listeDesCdes
function listeDesCdes($defaut = '', $magasin = '')
{
$userName = getField('LOGIN', $_SESSION['GL_USER']['LOGIN'], 'LOGIN', 'compte');
$ilang = getCodelangue($userName);
isset($defaut) ? $where = " AND CDE_LIBELLE LIKE '{$defaut}%'" : ($where = "");
$sql = "SELECT * FROM commande INNER JOIN fournisseur ON (commande.CODE_FOUR=fournisseur.CODE_FOUR)\r\n\tWHERE commande.CODE_MAGASIN LIKE '" . addslashes($magasin) . "' AND commande.CDE_STATUT=1 {$where} ORDER BY CDE_DATE DESC;";
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() );
die($error->getMessage() . ' ' . __LINE__);
}
$query = $cnx->prepare($sql);
//Prepare the SQL
$query->execute();
//Execute prepared SQL => $query
$list = '';
$i = 0;
while ($row = $query->fetch(PDO::FETCH_ASSOC)) {
$in = '';
$where = '';
$i % 2 == 0 ? $col = "tableOddRow" : ($col = "tableEvenRow");
if (IsDelivery($row['CODE_COMMANDE'])) {
$list .= '<tr class="' . $col . '">
<td align="left" valign="middle" class="text"><a href="#" onClick="pickUp(\'' . $row['CODE_COMMANDE'] . '\',\'' . addslashes($row['CDE_LIBELLE']) . '\',\'' . addslashes($row['CODE_FOUR']) . '\',\'' . addslashes($row['FOUR_NOM']) . '\');">' . $row['CODE_COMMANDE'] . '</a></td>
<td align="center" valign="middle" class="text"><a href="#" onClick="pickUp(\'' . $row['CODE_COMMANDE'] . '\',\'' . addslashes($row['CDE_LIBELLE']) . '\',\'' . addslashes($row['CODE_FOUR']) . '\',\'' . addslashes($row['FOUR_NOM']) . '\');">' . frFormat2($row['CDE_DATE']) . '</a></td>
<td class="text" ><a href="#" onClick="pickUp(\'' . $row['CODE_COMMANDE'] . '\',\'' . addslashes($row['CDE_LIBELLE']) . '\',\'' . addslashes($row['CODE_FOUR']) . '\',\'' . addslashes($row['FOUR_NOM']) . '\');">' . $row['CDE_LIBELLE'] . '</a></td>
</tr>';
$i++;
}
}
if ($ilang == '1' && $ilang != '') {
if ($list == '') {
$list = '
<tr class="tableOddRow">
<td height="22" align="left" valign="middle" class="text" colspan="4">Aucun produit disponible ...</td>
</tr>';
}
}
if ($ilang == '2' && $ilang != '') {
if ($list == '') {
$list = '
<tr class="tableOddRow">
<td height="22" align="left" valign="middle" class="text" colspan="4">No data ...</td>
</tr>';
}
}
if ($ilang == '3' && $ilang != '') {
if ($list == '') {
$list = '
<tr class="tableOddRow">
<td height="22" align="left" valign="middle" class="text" colspan="4">Nenhum dado ...</td>
</tr>';
}
}
return $list;
}
开发者ID:benleibert,项目名称:channel-software,代码行数:59,代码来源:phpfuncLibBBB.php
示例2: array
//Prepare the SQL
$query->execute();
//Execute prepared SQL => $query
$row = $query->fetch(PDO::FETCH_ASSOC);
//Data CDE_STATUT
$_SESSION['DATA_DEC'] = array('xid' => $row['CODE_DECLASS'], 'exercice' => $row['ID_EXERCICE'], 'datedeclassement' => frFormat2($row['DCL_DATE']), 'refdeclassement' => $row['REF_DECLAS'], 'natdeclassement' => $row['CODENATDECLASS'], 'raison' => $row['LIBNATDECLASS'], 'libelle' => $row['DCL_LIBELLE'], 'cabinet' => $row['DCL_CABINET'], 'refrapport' => $row['DCL_REFRAPPORT'], 'datevalid' => frFormat($row['DCL_DATEVALID']), 'statut' => $row['DCL_VALIDE'], 'nbreLigne' => 0);
//LIGNES PERTE
$sql = "SELECT detdeclass.*, produit.CODE_PRODUIT, produit.PRD_LIBELLE FROM `detdeclass`\r\n\t\tINNER JOIN produit ON (produit.CODE_PRODUIT LIKE detdeclass.CODE_PRODUIT) WHERE CODE_DECLASS LIKE '" . addslashes($split[0]) . "'\r\n\t\tORDER BY ID_DETDECLASS ASC;";
$query = $cnx->prepare($sql);
//Prepare the SQL
$query->execute();
//Execute prepared SQL => $query
//Ligne
$_SESSION['DATA_DEC']['ligne'] = array();
while ($row = $query->fetch(PDO::FETCH_ASSOC)) {
array_push($_SESSION['DATA_DEC']['ligne'], array('code_detdeclass' => $row['CODE_DETDECLASS'], 'monlot' => $row['DECL_MONLOT'], 'codeproduit' => $row['CODE_PRODUIT'], 'produit' => stripslashes($row['PRD_LIBELLE']), 'qte' => $row['DECL_QTE'], 'unite' => $row['DECL_UNITE'], 'prix' => $row['DECL_PA'], 'reflot' => $row['DECL_REFLOT'], 'dateperemp' => preg_replace('[-]', '/', frFormat2($row['DECL_DATEPEREMP']))));
}
$_SESSION['DATA_DEC']['nbreLigne'] = $query->rowCount();
header('location:validdeclassement.php?selectedTab=bds&rs=3');
break;
case 'annul':
isset($_POST['xid']) ? $xid = $_POST['xid'] : ($xid = '');
isset($_POST['oldcode']) ? $oldcode = $_POST['oldcode'] : ($oldcode = '');
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,代码来源:dbdeclassement.php
示例3: MAX
// ENTREE
$sortie = $bonsortie['QTE'] + $Declassement['QTE'] + $reportSortie['QTE'] + $transfetSort['QTE'];
//SORTIE
$ecart = $inventmoins['QTE'] + $inventplus['QTE'];
$rest = $entree - $sortie + $ecart;
if ($rest == 0) {
$sql2 = "SELECT MAX(`MVT_DATE`) AS D_DATE from mouvement\r\n\t\t\t\t\tWHERE MVT_TYPE LIKE 'S' AND CODE_PRODUIT LIKE '" . addslashes($row['CODE_PRODUIT']) . "';";
$query2 = $cnx->prepare($sql2);
//Prepare the SQL
$query2->execute();
//Execute prepared SQL => $query
$row2 = $query2->fetch(PDO::FETCH_ASSOC);
isset($row2['D_DATE']) && $row2['D_DATE'] != '' ? $ddebut = $row2['D_DATE'] : ($ddebut = $_SESSION['GL_USER']['EXERCICE'] . '-01-01');
$j = NbJours($ddebut, date('Y-m-d'));
// echo $ddebut, ' ', date('Y-m-d'), ' ',$j;
array_push($_SESSION['DATA_ETAT']['ligne'], array('codeproduit' => $row['CODE_PRODUIT'], 'produit' => stripslashes($row['PRD_LIBELLE']), 'stocks' => $rest, 'unite' => $row['ID_UNITE'], 'date' => frFormat2($row2['D_DATE']), 'jour' => $j, 'semaine' => $j / 7, 'mois' => $j / 30));
$_SESSION['DATA_ETAT']['nbreLigne'] += 1;
}
}
header('location:raprupture1.php?selectedTab=int');
break;
case 'rapportmensuel':
//Par produit
$where = " mouvement.CODE_MAGASIN LIKE '" . $_SESSION['GL_USER']['MAGASIN'] . "' AND ";
$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 .= "");
$wherePeriode = " mouvement.CODE_MAGASIN LIKE '" . $_SESSION['GL_USER']['MAGASIN'] . "' AND ";
isset($_POST['exercice']) && $_POST['exercice'] != '' ? $wherePeriode .= "mouvement.ID_EXERCICE = '" . addslashes(trim($_POST['exercice'])) . "' AND " : ($wherePeriode .= "");
isset($_POST['datedebut']) && $_POST['datedebut'] != '' ? $wherePeriode .= "mouvement.MVT_DATE > '" . addslashes(mysqlFormat(trim($_POST['datedebut']))) . "' AND " : ($wherePeriode .= "");
isset($_POST['datefin']) && $_POST['datefin'] != '' ? $wherePeriode .= "mouvement.MVT_DATE <= '" . addslashes(mysqlFormat(trim($_POST['datefin']))) . "' AND " : ($wherePeriode .= "");
开发者ID:benleibert,项目名称:channel-software,代码行数:31,代码来源:dbetat+-+Copie.php
示例4: array
$query->execute();
//Execute prepared SQL => $query
$row = $query->fetch(PDO::FETCH_ASSOC);
//Data CDE_STATUT
$_SESSION['DATA_BDS'] = array('xid' => $row['CODE_BONSORTIE'], 'exercice' => $row['ID_EXERCICE'], 'datebonsortie' => frFormat2($row['SOR_DATE']), 'refbonsortie' => stripslashes($row['REF_BONSORTIE']), 'idbeneficiaire' => $row['CODE_BENEF'], 'beneficiaire' => stripslashes($row['BENEF_NOM']), 'libelle' => stripslashes($row['SOR_LIBELLE']), 'statut' => $row['SOR_VALIDE'], 'nbreLigne' => 0);
//LIGNES
$sql = "SELECT * FROM `detbonsortie` INNER JOIN produit ON (detbonsortie.CODE_PRODUIT LIKE produit.CODE_PRODUIT)\r\n\t\tWHERE CODE_BONSORTIE LIKE '" . addslashes($split[0]) . "' ORDER BY ID_DETBONSORTIE ASC;";
$query = $cnx->prepare($sql);
//Prepare the SQL
$query->execute();
//Execute prepared SQL => $query
//Ligne
$_SESSION['DATA_BDS']['ligne'] = array();
while ($row = $query->fetch(PDO::FETCH_ASSOC)) {
$dispo = ProduitsQte($row['CODE_PRODUIT'], $valid = 1, $type = 'E') - ProduitsQte($row['CODE_PRODUIT'], $valid = 1, $type = 'S');
array_push($_SESSION['DATA_BDS']['ligne'], array('code_detbonsortie' => $row['CODE_DETBONSORTIE'], 'monlot' => $row['BSPRD_MONLOT'], 'codeproduit' => $row['CODE_PRODUIT'], 'produit' => stripslashes($row['PRD_LIBELLE']), 'qte' => $row['BSPRD_QTE'], 'dispo' => $dispo, 'unite' => $row['BSPRD_UNITE'], 'magasin' => $row['CODE_MAGASIN'], 'prix' => $row['BSPRD_PV'], 'reflot' => $row['BSPRD_REFLOT'], 'dateperemp' => preg_replace('[-]', '/', frFormat2($row['BSPRD_DATEPEREMP']))));
}
$_SESSION['DATA_BDS']['nbreLigne'] = $query->rowCount();
header('location:validbonsortie.php?selectedTab=bds&rst=1');
break;
case 'delete':
isset($_POST['rowSelection']) ? $id = $_POST['rowSelection'] : ($id = array());
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');
}
foreach ($id as $key => $val) {
开发者ID:benleibert,项目名称:channel-software,代码行数:31,代码来源:dbbonsortie.php
示例5: PDO
$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');
}
//COMMANDE
$sql = "SELECT * FROM `livraison` WHERE CODE_MAGASIN LIKE '" . $_SESSION['GL_USER']['MAGASIN'] . "' AND `ID_LIVRAISON` = '" . addslashes($split[0]) . "'";
$query = $cnx->prepare($sql);
//Prepare the SQL
$query->execute();
//Execute prepared SQL => $query
$row = $query->fetch(PDO::FETCH_ASSOC);
//Data
$_SESSION['DATA_LOT'] = array('xid' => $row['ID_LIVRAISON'], 'exercice' => $row['ID_EXERCICE'], 'datelivraison' => frFormat2($row['LVR_DATE']), 'commande' => $row['ID_COMMANDE'], 'codelivraison' => stripslashes($row['CODE_LIVRAISON']), 'statut' => $row['LVR_VALIDE'], 'nbreLigne' => 0);
//LIGNES COMMANDE
$sql = "SELECT * FROM `prd_livraison` INNER JOIN produit\r\n\t\tON (prd_livraison.CODE_PRODUIT LIKE produit.CODE_PRODUIT) WHERE ID_LIVRAISON = '" . addslashes($split[0]) . "'";
$query = $cnx->prepare($sql);
//Prepare the SQL
$query->execute();
//Execute prepared SQL => $query
//Ligne
$_SESSION['DATA_LOT']['ligne'] = array();
while ($row = $query->fetch(PDO::FETCH_ASSOC)) {
array_push($_SESSION['DATA_LOT']['ligne'], array('codeproduit' => $row['CODE_PRODUIT'], 'produit' => stripslashes($row['PRD_LIBELLE']), 'qte' => $row['LVR_PRDQTE'], 'qtelvr' => $row['LVR_PRDRECU'], 'unite' => $row['LVR_UNITE'], 'mag' => $row['magasin']));
}
$_SESSION['DATA_LOT']['nbreLigne'] = $query->rowCount();
header('location:validlivraison.php?selectedTab=bde&rst=1');
break;
case 'delete':
开发者ID:benleibert,项目名称:channel-software,代码行数:31,代码来源:dblot.php
示例6: ON
$_SESSION['DATA_ETAT']['STOCK'] = $StockPrecedent;
$sql = "SELECT * FROM mouvement INNER JOIN produit ON (mouvement.CODE_PRODUIT LIKE produit.CODE_PRODUIT)\r\n\t\t\t {$whereAll} ORDER BY produit.PRD_LIBELLE, mouvement.ID_MOUVEMENT, mouvement.MVT_DATE ASC; ";
$query = $cnx->prepare($sql);
//Prepare the SQL
$query->execute();
//Execute prepared SQL => $query
while ($row = $query->fetch(PDO::FETCH_ASSOC)) {
//echo 'Ent'.$entree.' Sort'.$sortie.'<br>';
if (isset($row['MVT_TYPE']) && $row['MVT_TYPE'] == 'E') {
$StockPrecedent += $row['MVT_QUANTITE'];
array_push($_SESSION['DATA_ETAT']['ligne'], array('codeproduit' => $row['CODE_PRODUIT'], 'reflot' => $row['MVT_REFLOT'], 'produit' => addslashes($row['PRD_LIBELLE']), 'nature' => $row['MVT_NATURE'], 'typemvt' => $row['MVT_TYPE'], 'qteentree' => $row['MVT_QUANTITE'], 'qtesortie' => 0, 'dateentree' => frFormat2($row['MVT_DATE']), 'dateperemp' => $row['MVT_DATEPEREMP'], 'pa' => $row['MVT_PA'], 'pv' => $row['MVT_PV'], 'unite' => $row['ID_UNITE'], 'stock' => $StockPrecedent, 'etat' => $row['MVT_VALID']));
$tEntree += $row['MVT_QUANTITE'];
}
if (isset($row['MVT_TYPE']) && $row['MVT_TYPE'] == 'S') {
$StockPrecedent -= $row['MVT_QUANTITE'];
array_push($_SESSION['DATA_ETAT']['ligne'], array('codeproduit' => $row['CODE_PRODUIT'], 'reflot' => $row['MVT_REFLOT'], 'produit' => addslashes($row['PRD_LIBELLE']), 'nature' => $row['MVT_NATURE'], 'typemvt' => $row['MVT_TYPE'], 'qteentree' => 0, 'qtesortie' => $row['MVT_QUANTITE'], 'dateentree' => frFormat2($row['MVT_DATE']), 'dateperemp' => $row['MVT_DATEPEREMP'], 'pa' => $row['MVT_PA'], 'pv' => $row['MVT_PV'], 'unite' => $row['ID_UNITE'], 'stock' => $StockPrecedent, 'etat' => $row['MVT_VALID']));
$tSortie += $row['MVT_QUANTITE'];
}
$_SESSION['DATA_ETAT']['PRODUIT'] = addslashes($row['PRD_LIBELLE']);
}
$_SESSION['DATA_ETAT']['nbreLigne'] = $query->rowCount();
$_SESSION['DATA_ETAT']['QTE_T_ENTREE'] = $tEntree;
$_SESSION['DATA_ETAT']['QTE_T_SORTIE'] = $tSortie;
//print_r($_SESSION['DATA_ETAT']);
header('location:rapficheproduit1.php?selectedTab=rap');
break;
case 'fillSousCatProduitFiche':
$list = '<select name="produit[]" name="produit[]" class="formStyle" size="10" multiple="multiple">';
if (isset($_POST["souscategorie"])) {
isset($_POST["souscategorie"]) && $_POST["souscategorie"] == 'TOUS' ? $where = '' : ($where = " WHERE produit.CODE_SOUSCATEGORIE ='" . $_POST["souscategorie"] . "'");
//SQL
开发者ID:benleibert,项目名称:channel-software,代码行数:31,代码来源:dbetat.php
示例7: PDO
$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');
}
//COMMANDE
$sql = "SELECT * FROM `commande` WHERE CODE_MAGASIN LIKE '" . $_SESSION['GL_USER']['MAGASIN'] . "' AND `CODE_COMMANDE` LIKE '" . addslashes($split[0]) . "'";
$query = $cnx->prepare($sql);
//Prepare the SQL
$query->execute();
//Execute prepared SQL => $query
$row = $query->fetch(PDO::FETCH_ASSOC);
//Data CDE_STATUT
$_SESSION['DATA_CDE'] = array('xid' => $row['CODE_COMMANDE'], 'exercice' => $row['ID_EXERCICE'], 'datecommande' => frFormat2($row['CDE_DATE']), 'refcommande' => $row['REF_COMMANDE'], 'libellecde' => $row['CDE_LIBELLE'], 'fournisseur' => $row['CODE_FOUR'], 'statut' => $row['CDE_STATUT'], 'nbreLigne' => 0);
//LIGNES COMMANDE
$sql = "SELECT * FROM `prd_cde` INNER JOIN produit ON (prd_cde.CODE_PRODUIT LIKE produit.CODE_PRODUIT)\r\n\t\tWHERE CODE_COMMANDE LIKE '" . addslashes($split[0]) . "'";
$query = $cnx->prepare($sql);
//Prepare the SQL
$query->execute();
//Execute prepared SQL => $query
//Ligne
$_SESSION['DATA_CDE']['ligne'] = array();
while ($row = $query->fetch(PDO::FETCH_ASSOC)) {
array_push($_SESSION['DATA_CDE']['ligne'], array('codeproduit' => $row['CODE_PRODUIT'], 'produit' => stripslashes($row['PRD_LIBELLE']), 'qte' => $row['CDEPRD_QTE'], 'unite' => $row['CDEPRD_UNITE'], 'prix' => $row['CDEPRD_PA']));
}
$_SESSION['DATA_CDE']['nbreLigne'] = $query->rowCount();
header('location:validcommande.php?selectedTab=bde&rs=3');
break;
case 'delete':
开发者ID:benleibert,项目名称:channel-software,代码行数:31,代码来源:dbcommande.php
示例8: isset
$ligne = 6;
for ($i = 1; $i <= $_SESSION['DATA_ETAT']['nbreLigne']; $i++) {
isset($data[$i - 1]['codeproduit']) ? $codeproduit = $data[$i - 1]['codeproduit'] : ($codeproduit = '');
isset($data[$i - 1]['reflot']) ? $reflot = $data[$i - 1]['reflot'] : ($reflot = '');
isset($data[$i - 1]['produit']) ? $produit = $data[$i - 1]['produit'] : ($produit = '');
isset($data[$i - 1]['dateentree']) ? $dateentree = $data[$i - 1]['dateentree'] : ($dateentree = '');
isset($data[$i - 1]['dateperemp']) ? $dateperemp = $data[$i - 1]['dateperemp'] : ($dateperemp = '');
isset($data[$i - 1]['qte']) ? $qte = $data[$i - 1]['qte'] : ($qte = '');
isset($data[$i - 1]['unite']) ? $unite = $data[$i - 1]['unite'] : ($unite = '');
isset($data[$i - 1]['prix']) && $data[$i - 1]['prix'] > 0 ? $prix = $data[$i - 1]['prix'] : ($prix = 0);
//($prix>0 ? $Aprix = number_format($prix,0,',', ' ') : $Aprix='');
$total = $prix * $qte;
//($total>0 ? $Atotal = number_format($total,0,',', ' ') : $Atotal='');
//($qte>0 ? $Aqte = number_format($qte,0,',', ' ') : $Aqte='');
$dateperemp = frFormat2($dateperemp);
$dateentree = frFormat2($dateentree);
$objPHPExcel->setActiveSheetIndex(0)->setCellValue('A' . $ligne, stripslashes($reflot))->setCellValue('B' . $ligne, stripslashes($codeproduit))->setCellValue('C' . $ligne, stripslashes($produit))->setCellValue('D' . $ligne, stripslashes($dateentree))->setCellValue('E' . $ligne, stripslashes($dateperemp))->setCellValue('F' . $ligne, stripslashes($qte))->setCellValue('G' . $ligne, stripslashes($unite));
$ligne++;
}
$fichier = '../download/Exp_RapportProduitPerime_' . date('YmdHis') . '.xlsx';
$objWriter = new PHPExcel_Writer_Excel2007($objPHPExcel);
$objWriter->save($fichier);
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" lang="fr" xml:lang="fr">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<META HTTP-EQUIV="refresh" CONTENT="" >
<title><?php
echo TITLE;
?>
开发者ID:benleibert,项目名称:channel-software,代码行数:31,代码来源:genererexcelrapprdperime.php
示例9: PDO
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 reversement.*, programmation.CODE_MAGASIN FROM `reversement` INNER JOIN programmation ON (programmation.ID_PROGR=reversement.ID_PROGR) WHERE programmation.CODE_MAGASIN LIKE '" . $_SESSION['GL_USER']['MAGASIN'] . "' AND `ID_REVERSEMENT` = '" . addslashes($id) . "'";
$query = $cnx->prepare($sql);
//Prepare the SQL
$query->execute();
//Execute prepared SQL => $query
$row = $query->fetch(PDO::FETCH_ASSOC);
$mnt = totalReversement($row['ID_PROGR'], $row['ID_EXERCICE']);
$_SESSION['DATA_REV'] = array('xid' => $row['ID_REVERSEMENT'], 'exercice' => $row['ID_EXERCICE'], 'datereversement' => frFormat2($row['REV_DATE']), 'programmation' => $row['ID_PROGR'], 'mnttotal' => $row['REV_MNTTOTAL'], 'mntverse' => $row['REV_MNTVERSE'], 'quittance' => $row['REV_QUITTANCE'], 'mntregle' => $mnt, 'mntrestant' => $row['REV_MNTTOTAL'] - $mnt, 'statut' => $row['REV_VALID'], 'nbreLigne' => 0, 'ligne' => array());
$sql = "SELECT * FROM prg_bareme INNER JOIN bareme ON (bareme.ID_BAREME=prg_bareme.ID_BAREME) WHERE ID_PROGR= " . addslashes($row['ID_PROGR']);
$query = $cnx->prepare($sql);
//Prepare the SQL
$query->execute();
//Execute prepared SQL => $query
//Ligne
$_SESSION['DATA_REV']['ligne'] = array();
while ($row = $query->fetch(PDO::FETCH_ASSOC)) {
array_push($_SESSION['DATA_REV']['ligne'], array('codeproduit' => $row['ID_BAREME'], 'produit' => $row['BAR_LIBELLE'], 'unite' => $row['ID_UNITE'], 'prix' => $row['BAR_PRIX'], 'mixte' => $row['PRG_MIXTE'], 'ration1' => $row['PRG_RATION1'], 'ration2' => $row['PRG_RATION2'], 'qte1' => $row['PRG_QTE1'], 'qte2' => $row['PRG_QTE2'], 'nbreplat1' => $row['NBRE_PLAT1'], 'nbreplat2' => $row['NBRE_PLAT2'], 'reversement' => $row['PRG_REVERSEMENT'], 'mixte' => $row['BAR_MIXTE']));
}
$_SESSION['DATA_REV']['nbreLigne'] = $query->rowCount();
header('location:validreversement.php?selectedTab=prg&rst=1');
break;
case 'delete':
isset($_POST['rowSelection']) ? $id = $_POST['rowSelection'] : ($id = array());
开发者ID:benleibert,项目名称:channel-software,代码行数:31,代码来源:dbreversement.php
示例10: PDO
$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');
}
//DECLASSEMENT
$sql = "SELECT * FROM `recondit` WHERE CODE_MAGASIN LIKE '" . $_SESSION['GL_USER']['MAGASIN'] . "' AND `ID_RECONDIT` = '" . addslashes($split[0]) . "'";
$query = $cnx->prepare($sql);
//Prepare the SQL
$query->execute();
//Execute prepared SQL => $query
$row = $query->fetch(PDO::FETCH_ASSOC);
//Data CDE_STATUT
$_SESSION['DATA_RECD'] = array('xid' => $row['ID_RECONDIT'], 'exercice' => $row['ID_EXERCICE'], 'datesortie' => frFormat2($row['REC_DATESORTIE']), 'dateentree' => frFormat2($row['REC_DATERETOUR']), 'codereconditionnement' => $row['CODE_RECOND'], 'raison' => $row['REC_RAISON'], 'statut' => $row['REC_VALIDE'], 'controleur' => $row['REC_CONTROLEUR'], 'libelle' => $row['REC_LIBELLE'], 'nbreLigne' => 0, 'ligne' => array());
//LIGNES RECONDITIONNEMENT
$sql = "SELECT * FROM `prd_recond` INNER JOIN produit ON (prd_recond.CODE_PRODUIT LIKE produit.CODE_PRODUIT)\r\n\t\tWHERE ID_RECONDIT = '" . addslashes($split[0]) . "'";
$query = $cnx->prepare($sql);
//Prepare the SQL
$query->execute();
//Execute prepared SQL => $query
//Ligne
$_SESSION['DATA_RECD']['ligne'] = array();
while ($row = $query->fetch(PDO::FETCH_ASSOC)) {
array_push($_SESSION['DATA_RECD']['ligne'], array('codeproduit' => $row['CODE_PRODUIT'], 'cause' => $row['PRDREC_CAUSE'], 'produit' => stripslashes($row['PRD_LIBELLE']), 'qte' => $row['PRDREC_QTES'], 'qtelivr' => $row['PRDREC_QTEE'], 'typeemballage' => $row['PRDREC_TYPEEMB'], 'colissage' => $row['PRDREC_COLISSAGE'], 'unite' => $row['PRDREC_UNITES']));
}
$_SESSION['DATA_RECD']['nbreLigne'] = $query->rowCount();
header('location:validreconditionnement.php?selectedTab=bds&rst=1');
break;
case 'annul':
开发者ID:benleibert,项目名称:channel-software,代码行数:31,代码来源:dbreconditionnement.php
示例11: header
header("location:accessinterdit.php?selectedTab=home");
}
require_once '../lib/phpfuncLib.php';
//All commun functions
require_once 'menus.php';
require_once 'funclocalite.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_LOCALITE', $_SESSION['GL_USER']['GROUPE']);
isset($_SESSION['DATA_REP']['ID_RESPO']) ? $idresp = $_SESSION['DATA_REP']['ID_RESPO'] : ($idresp = '');
isset($_SESSION['DATA_REP']['NUM_MLLE']) ? $personnel = $_SESSION['DATA_REP']['NUM_MLLE'] : ($personnel = '');
isset($_SESSION['DATA_REP']['CODE_MAGASIN']) ? $magasin = $_SESSION['DATA_REP']['CODE_MAGASIN'] : ($magasin = '');
isset($_SESSION['DATA_REP']['RES_DATEDEBUT']) ? $datedebut = $_SESSION['DATA_REP']['RES_DATEDEBUT'] : ($datedebut = '');
isset($_SESSION['DATA_REP']['RES_DATEFIN']) ? $datefin = $_SESSION['DATA_REP']['RES_DATEFIN'] : ($datefin = '');
$datedebut = frFormat2($datedebut);
$datefin = frFormat2($datefin);
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" lang="fr" xml:lang="fr">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<META HTTP-EQUIV="refresh" CONTENT="" >
<title><?php
echo TITLE;
?>
</title>
<LINK REL="SHORTCUT ICON" HREF="../images/favicon0.ico">
<link href="../css/neutralcss.css" rel="stylesheet" type="text/css">
<link href="../lib/JQuerySpinBtn.css" rel="stylesheet" type="text/css">
<link href="../lib/jquery.alerts.css" rel="stylesheet" type="text/css">
<!-- Begin of JS code -->
开发者ID:benleibert,项目名称:channel-software,代码行数:31,代码来源:editresponsable.php
示例12: catch
//Connexion to database
} catch (PDOException $error) {
//Treat error
//("Erreur de connexion : " . $error->getMessage() );
header('location:errorPage.php');
}
//DECLASSEMENT
$sql = "SELECT * FROM `recondit` WHERE `ID_RECONDIT` = '" . addslashes($split[0]) . "'";
$query = $cnx->prepare($sql);
//Prepare the SQL
$query->execute();
//Execute prepared SQL => $query
$row = $query->fetch(PDO::FETCH_ASSOC);
//Data CDE_STATUT
//Data CDE_STATUT
$_SESSION['DATA_RECD'] = array('xid' => $row['ID_RECONDIT'], 'exercice' => $row['ID_EXERCICE'], 'datesortie' => frFormat2($row['REC_DATESORTIE']), 'codereconditionnement' => $row['CODE_RECOND'], 'raison' => $row['REC_RAISON'], 'statut' => $row['REC_VALIDE'], 'nbreLigne' => $nbreLigne, 'ligne' => array());
//LIGNES RECONDITIONNEMENT SORTIE
$sql = "SELECT * FROM `recond_sorte` WHERE ID_RECONDIT = '" . addslashes($split[0]) . "'";
$query = $cnx->prepare($sql);
//Prepare the SQL
$query->execute();
//Execute prepared SQL => $query
//Ligne
$_SESSION['DATA_RECD']['ligne'] = array();
while ($row = $query->fetch(PDO::FETCH_ASSOC)) {
array_push($_SESSION['DATA_RECD']['ligne'], array('codeproduit' => $row['ID_CONDIT'], 'produit' => getConditionnement($row['ID_CONDIT']), 'qte' => $row['CNDREC_QTES'], 'unite' => $row['CNDREC_UNITES']));
}
$_SESSION['DATA_RECD']['nbreLigne'] = $query->rowCount();
header('location:validreconditionnements.php?selectedTab=mvt&rst=1');
break;
case 'delete':
开发者ID:benleibert,项目名称:channel-software,代码行数:31,代码来源:dbreconditionnement2.php
示例13: ligneEtatrapmvtdestinaire
function ligneEtatrapmvtdestinaire($nbre = 1, $data = array())
{
$ret = '';
for ($i = 1; $i <= $nbre; $i++) {
isset($data[$i - 1]['reflot']) ? $reflot = $data[$i - 1]['reflot'] : ($reflot = '');
isset($data[$i - 1]['codeproduit']) ? $codeproduit = $data[$i - 1]['codeproduit'] : ($codeproduit = '');
isset($data[$i - 1]['produit']) ? $produit = $data[$i - 1]['produit'] : ($produit = '');
isset($data[$i - 1]['dateperemp']) ? $dateperemp = $data[$i - 1]['dateperemp'] : ($dateperemp = '');
isset($data[$i - 1]['datesortie']) ? $datesortie = $data[$i - 1]['datesortie'] : ($datesortie = '');
isset($data[$i - 1]['qte']) && $data[$i - 1]['qte'] != 0 ? $qte = number_format($data[$i - 1]['qte'], 0, '', ' ') : ($qte = '');
$d = preg_replace('/-/', '/', $dateperemp);
$d = substr($d, 0, 7);
$col = '';
$ret .= '
<tr align="left" valign="middle" class="' . $col . '">
<td class="botBorderTdall" align="center" nowrap>' . $i . ' - </td>
<td class="botBorderTdall" align="left">' . stripslashes($reflot) . ' </td>
<td class="botBorderTdall" align="left" >' . stripslashes($codeproduit) . ' </td>
<td class="botBorderTdall" align="left" >' . stripslashes($produit) . ' </td>
<td class="botBorderTdall" align="center" >' . frFormat2($datesortie) . ' </td>
<td class="botBorderTdall" align="right" >' . stripslashes($qte) . ' </td>
<td class="botBorderTdall" align="center">' . stripslashes($d) . ' </td>
</tr>';
}
return $ret;
}
开发者ID:benleibert,项目名称:channel-software,代码行数:26,代码来源:funcetat+-+Copie.php
示例14: array
//Prepare the SQL
$query->execute();
//Execute prepared SQL => $query
$row = $query->fetch(PDO::FETCH_ASSOC);
//Data
$_SESSION['DATA_LVR'] = array('xid' => $row['CODE_LIVRAISON'], 'exercice' => $row['ID_EXERCICE'], 'datelivraison' => frFormat2($row['LVR_DATE']), 'reflivraison' => stripslashes($row['REF_LIVRAISON']), 'commande' => stripslashes($row['CODE_COMMANDE']), 'libcommande' => getField('CODE_COMMANDE', $row['CODE_COMMANDE'], 'CDE_LIBELLE', 'commande'), 'fournisseur' => getField('CODE_FOUR', $row['CODE_FOUR'], 'FOUR_NOM', 'fournisseur'), 'idfournisseur' => $row['CODE_FOUR'], 'libelle' => stripslashes($row['LVR_LIBELLE']), 'statut' => $row['LVR_VALIDE'], 'nbreLigne' => 0);
//LIGNES COMMANDE
$sql = "SELECT * FROM `detlivraison` INNER JOIN produit\r\n\t\tON (detlivraison.CODE_PRODUIT LIKE produit.CODE_PRODUIT) WHERE CODE_LIVRAISON = '" . addslashes($split[0]) . "' ORDER BY detlivraison.ID_DETLIVRAISON ASC";
$query = $cnx->prepare($sql);
//Prepare the SQL
$query->execute();
//Execute prepared SQL => $query
//Ligne
$_SESSION['DATA_LVR']['ligne'] = array();
while ($row = $query->fetch(PDO::FETCH_ASSOC)) {
array_push($_SESSION['DATA_LVR']['ligne'], array('code_detlivraison' => $row['CODE_DETLIVRAISON'], 'code_detlivraison' => $row['ID_DETLIVRAISON'], 'monlot' => $row['LVR_MONLOT'], 'codeproduit' => $row['CODE_PRODUIT'], 'produit' => stripslashes($row['PRD_LIBELLE']), 'qte' => $row['LVR_PRDQTE'], 'qtelvr' => $row['LVR_PRDRECU'], 'unite' => $row['LVR_UNITE'], 'mag' => $row['LVR_MAGASIN'], 'prix' => $row['LVR_PA'], 'reflot' => $row['LVR_REFLOT'], 'dateperemp' => preg_replace('[-]', '/', frFormat2($row['LVR_DATEPEREMP']))));
}
$_SESSION['DATA_LVR']['nbreLigne'] = $query->rowCount();
if ($_SESSION['DATA_LVR']['commande'] != '') {
header('location:validlivraison1.php?selectedTab=bde&rs=3');
} else {
header('location:validlivraison2.php?selectedTab=bde&rs=3');
}
break;
case 'delete':
isset($_POST['rowSelection']) ? $id = $_POST['rowSelection'] : ($id = array());
try {
$cnx = new PDO(DBD, DBUSER, DBPWD, array(PDO::MYSQL_ATTR_INIT_COMMAND => "SET NAMES utf8"));
//Connexion to database
} catch (PDOException $error) {
//Treat error
开发者ID:benleibert,项目名称:channel-software,代码行数:31,代码来源:dblivraison.php
示例15: ligneConlot
function ligneConlot($wh = '', $ord = '', $sens = 'ASC', $page = 1, $nelt)
{
$returnHTML = '';
$returnTble = array();
//HTML, nbreTotal,
//Where clause
$where = '';
isset($wh) and $wh != '' ? $where = " WHERE {$wh} " : ($where = "");
//Oerder condition
$order = '';
isset($ord) and $ord != '' ? $order = " ORDER BY {$ord} {$sens}" : ($order = " ORDER BY livraison.LVR_DATE DESC");
//Nombre d'éléments
$returnTble['NE'] = nombreDetLivraison($where);
if ($returnTble['NE'] > 0) {
//Calcule des limites
$i = ($page - 1) * $nelt;
$sql = "SELECT * FROM prd_livraison\r\n\t\tINNER JOIN livraison ON (prd_livraison.ID_LIVRAISON=livraison.ID_LIVRAISON)\r\n\t\tINNER JOIN produit ON (prd_livraison.CODE_PRODUIT LIKE produit.CODE_PRODUIT)\r\n\t\t{$where} {$order} LIMIT {$i}, {$nelt};";
//Exécution
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
$i = 0;
$j = 6;
while ($row = $query->fetch(PDO::FETCH_ASSOC)) {
$i % 2 == 0 ? $col = "tableOddRow" : ($col = "tableEvenRow");
if ($row['LVRLOT_VALIDE'] == '0') {
$imgCl = '<img src="../images/encours.gif" title="En cours" width="16" height="16">';
} elseif ($row['LVRLOT_VALIDE'] == '2') {
$imgCl = '<img src="../images/cancel.png" title="Annulée" width="16" height="16">';
} else {
$imgCl = '<img src="../images/valider.gif" title="Validée" width="16" height="16">';
}
$i++;
$returnHTML .= '
<tr align="left" valign="middle" class="' . $col . '">
<td class="text" align="center">' . $i . '</td>
<td><input type="checkbox" name="rowSelection[]" value="' . $row['ID_LIVRAISON'] . '@' . $row['LVRLOT_VALIDE'] . '@' . $j . '" onClick="IsValider(' . $row['LVRLOT_VALIDE'] . ',' . $j . ');"></td>
<td class="text" align="center">' . $imgCl . '</td>
<td class="text">' . stripslashes($row['CODE_LIVRAISON']) . ' </td>
<td class="text" >' . stripslashes($row['CODE_PRODUIT']) . ' </td>
<td class="text" >' . stripslashes($row['PRD_LIBELLE']) . ' </td>
<td class="text" > </td>
<td class="text" > </td>
<td class="text" align="center">' . stripslashes($row['LVR_PRDRECU'] . ' ' . $row['LVR_UNITE']) . ' </td>
<td class="text" align="center" nowrap="nowrap"><a href="dlot.php?do=detail&xid=' . $row['ID_LIVRAISON'] . '&codeprd=' . $row['CODE_PRODUIT'] . '" class="morelink">' . stripslashes('Détails lot') . '</a></td>
</tr>';
$sql3 = "SELECT * FROM lot\r\n\t\t\tINNER JOIN livraison ON (livraison.ID_LIVRAISON=lot.ID_LIVRAISON)\r\n\t\t\tINNER JOIN produit ON (lot.CODE_PRODUIT LIKE produit.CODE_PRODUIT) WHERE lot.ID_LIVRAISON=" . $row['ID_LIVRAISON'];
$query = $cnx->prepare($sql3);
//Prepare the SQL
$query->execute();
//Execute prepared SQL => $query
$k = 1;
while ($row3 = $query->fetch(PDO::FETCH_ASSOC)) {
$k % 2 == 0 ? $col = "tableOddRow" : ($col = "tableEvenRow");
$returnHTML .= '
<tr align="left" valign="middle" class="' . $col . '">
<td class="text" align="center">' . $k . '</td>
<td class="text" align="center" colspan="3"> </td>
<td class="text" >' . stripslashes($row3['CODE_PRODUIT']) . ' </td>
<td class="text" >' . stripslashes($row3['PRD_LIBELLE']) . ' </td>
<td class="text" align="center" >' . stripslashes($row3['REF_LOT']) . ' </td>
<td class="text" align="center" >' . stripslashes(frFormat2($row3['DATE_PEREMPTION'])) . ' </td>
<td class="text" align="center">' . stripslashes($row3['LOT_PRDQTE'] . ' ' . $row3['LOT_UNITE']) . ' </td>
<td class="text" > </td>
</tr>';
$k++;
}
$j++;
}
} else {
$returnHTML .= '<tr><td colspan="4" class="text">Aucune donnée</td></tr>';
}
$returnTble['L'] = $returnHTML;
return $returnTble;
}
开发者ID:benleibert,项目名称:channel-software,代码行数:84,代码来源:funclot.php
示例16: topMenus
//Top Menu
$selectedTab = $_GET['selectedTab'];
$menu = topMenus($selectedTab, $_SESSION['GL_USER']['DROIT']);
//Left Menu
$leftMenu = parametersMenus($selectedTab, $_SESSION['GL_USER']['DROIT']);
//DOIT MAJ
$droitMAJ = $_SESSION['GL_USER']['DROIT']['par_bud'];
isset($_SESSION['DATA_EX']['ID_EXERCICE']) ? $codeexercice = $_SESSION['DATA_EX']['ID_EXERCICE'] : ($codeexercice = '');
isset($_SESSION['DATA_EX']['EX_LIBELLE']) ? $exercice = $_SESSION['DATA_EX']['EX_LIBELLE'] : ($exercice = '');
isset($_SESSION['DATA_EX']['EX_DATEDEBUT']) ? $datedebut = $_SESSION['DATA_EX']['EX_DATEDEBUT'] : ($datedebut = '');
isset($_SESSION['DATA_EX']['EX_DATEFIN']) ? $datefin = $_SESSION['DATA_EX']['EX_DATEFIN'] : ($datefin = '');
isset($_SESSION['DATA_EX']['EX_CLOTURE']) ? $cloture = $_SESSION['DATA_EX']['EX_CLOTURE'] : ($cloture = '');
isset($_SESSION['DATA_EX']['EX_DATECLOTURE']) ? $datecloture = $_SESSION['DATA_EX']['EX_DATECLOTURE'] : ($datecloture = '');
$datefin != '0000-00-00' ? $datedebut = frFormat2($datedebut) : ($datedebut = '');
$datefin != '0000-00-00' ? $datefin = frFormat2($datefin) : ($datefin = '');
$datefin != '0000-00-00' ? $datecloture = frFormat2($datecloture) : ($datecloture = '');
$cloture == 1 ? $checked = 'checked="checked"' : ($checked = '');
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" lang="fr" xml:lang="fr">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<META HTTP-EQUIV="refresh" CONTENT="" >
<title><?php
echo TITLE;
?>
</title>
<LINK REL="SHORTCUT ICON" HREF="../images/favicon0.ico">
<link href="../css/neutralcss.css" rel="stylesheet" type="text/css">
<link href="../lib/JQuerySpinBtn.css" rel="stylesheet" type="text/css">
<link href="../lib/jquery.alerts.css" rel="stylesheet" type="text/css">
开发者ID:benleibert,项目名称:channel-software,代码行数:31,代码来源:editexercice.php
-
Session fixation vulnerability in access control management in Synology Photo St
阅读:945|2022-07-08
-
bluegill/katana:
阅读:911|2022-08-18
-
NelsonUpenn/PMLS-MATLAB-Guide: MLguide1-0.pdf: Nelson Dodson's Student'
阅读:324|2022-08-17
-
这几年,学校不仅关注学生的文化课知识,对于学生的艺术培养,也是非常重视的。毕竟,
阅读:351|2022-11-06
-
juleswhite/mobilecloud-15: Programming Cloud Services for Android Handheld Syste
阅读:461|2022-08-30
-
yosupo06/library-checker-problems: The problem data (Test case generator, judge
阅读:531|2022-08-15
-
athos/Bigmouth: Clojure framework to build delivery-only Mastodon-compatible web
阅读:869|2022-08-17
-
现在汽车行业生意红火,当然,汽车的相关投资项目,市场前景都是很不错的,那么,开洗
阅读:231|2022-11-06
-
Ingredients Stock Management System v1.0 was discovered to contain a SQL injecti
阅读:506|2022-09-18
-
在使用微信小程序开发者工具进行开发需要使用数据库内的内容而发送网络请求却没有配置
阅读:820|2022-07-18
|
请发表评论