/modules/magazz/select_giomag.php
PHP | 207 lines | 175 code | 7 blank | 25 comment | 17 complexity | 8cd1370b3347a742a226fc76aa982866 MD5 | raw file
Possible License(s): LGPL-2.1, GPL-2.0
- <?php
- /* $Id: select_giomag.php,v 1.16 2010/01/17 17:27:04 devincen Exp $
- --------------------------------------------------------------------------
- Gazie - Gestione Azienda
- Copyright (C) 2004-2010 - Antonio De Vincentiis Montesilvano (PE)
- (www.devincentiis.it)
- <http://gazie.sourceforge.net>
- --------------------------------------------------------------------------
- Questo programma e` free software; e` lecito redistribuirlo e/o
- modificarlo secondo i termini della Licenza Pubblica Generica GNU
- come e` pubblicata dalla Free Software Foundation; o la versione 2
- della licenza o (a propria scelta) una versione successiva.
-
- Questo programma e` distribuito nella speranza che sia utile, ma
- SENZA ALCUNA GARANZIA; senza neppure la garanzia implicita di
- NEGOZIABILITA` o di APPLICABILITA` PER UN PARTICOLARE SCOPO. Si
- veda la Licenza Pubblica Generica GNU per avere maggiori dettagli.
-
- Ognuno dovrebbe avere ricevuto una copia della Licenza Pubblica
- Generica GNU insieme a questo programma; in caso contrario, si
- scriva alla Free Software Foundation, Inc., 59
- Temple Place, Suite 330, Boston, MA 02111-1307 USA Stati Uniti.
- --------------------------------------------------------------------------
- */
- require("../../library/include/datlib.inc.php");
- $admin_aziend=checkAdmin();
- $msg='';
-
- function getMovements($date_ini,$date_fin)
- {
- global $gTables,$admin_aziend;
- $m=array();
- $where="datreg BETWEEN $date_ini AND $date_fin";
- $what=$gTables['movmag'].".*, ".
- $gTables['caumag'].".codice, ".$gTables['caumag'].".descri, ".
- $gTables['clfoco'].".codice, ".$gTables['clfoco'].".descri AS ragsoc, ".
- $gTables['artico'].".codice, ".$gTables['artico'].".descri AS desart, ".$gTables['artico'].".unimis, ".$gTables['artico'].".scorta, ".$gTables['artico'].".catmer ";
- $table=$gTables['movmag']." LEFT JOIN ".$gTables['caumag']." ON (".$gTables['movmag'].".caumag = ".$gTables['caumag'].".codice)
- LEFT JOIN ".$gTables['clfoco']." ON (".$gTables['movmag'].".clfoco = ".$gTables['clfoco'].".codice)
- LEFT JOIN ".$gTables['artico']." ON (".$gTables['movmag'].".artico = ".$gTables['artico'].".codice)";
- $rs=gaz_dbi_dyn_query ($what,$table,$where, 'datreg ASC, clfoco ASC');
- while ($r = gaz_dbi_fetch_array($rs)) {
- $m[] = $r;
- }
- return $m;
- }
-
- if (!isset($_POST['hidden_req'])) { //al primo accesso allo script
- $form['hidden_req'] = '';
- $form['ritorno'] = $_SERVER['HTTP_REFERER'];
- $form['this_date_Y']=date("Y");
- $form['this_date_M']=date("m");
- $form['this_date_D']=date("d");
- if (!isset($_GET['di'])) {
- $form['date_ini_D']=1;
- $form['date_ini_M']=1;
- $form['date_ini_Y']=date("Y");
- } else {
- $form['date_ini_D']=intval(substr($_GET['di'],0,2));
- $form['date_ini_M']=intval(substr($_GET['di'],2,2));
- $form['date_ini_Y']=intval(substr($_GET['di'],4,4));
- }
- if (!isset($_GET['df'])) {
- $form['date_fin_D']=date("d");
- $form['date_fin_M']=date("m");
- $form['date_fin_Y']=date("Y");
- } else {
- $form['date_fin_D']= intval(substr($_GET['df'],0,2));
- $form['date_fin_M']= intval(substr($_GET['df'],2,2));
- $form['date_fin_Y']= intval(substr($_GET['df'],4,4));
- }
- } else { // accessi successivi
- $form['hidden_req']=htmlentities($_POST['hidden_req']);
- $form['ritorno']=$_POST['ritorno'];
- $form['date_ini_D']=intval($_POST['date_ini_D']);
- $form['date_ini_M']=intval($_POST['date_ini_M']);
- $form['date_ini_Y']=intval($_POST['date_ini_Y']);
- $form['date_fin_D']=intval($_POST['date_fin_D']);
- $form['date_fin_M']=intval($_POST['date_fin_M']);
- $form['date_fin_Y']=intval($_POST['date_fin_Y']);
- $form['this_date_Y']=intval($_POST['this_date_Y']);
- $form['this_date_M']=intval($_POST['this_date_M']);
- $form['this_date_D']=intval($_POST['this_date_D']);
- if (isset($_POST['return'])) {
- header("Location: ".$form['ritorno']);
- exit;
- }
- }
-
- //controllo i campi
- if (!checkdate( $form['this_date_M'],$form['this_date_D'],$form['this_date_Y']) ||
- !checkdate( $form['date_ini_M'], $form['date_ini_D'], $form['date_ini_Y']) ||
- !checkdate( $form['date_fin_M'], $form['date_fin_D'], $form['date_fin_Y'])) {
- $msg .='0+';
- }
- $utsexe= mktime(0,0,0,$form['this_date_M'],$form['this_date_D'],$form['this_date_Y']);
- $utsini= mktime(0,0,0,$form['date_ini_M'],$form['date_ini_D'],$form['date_ini_Y']);
- $utsfin= mktime(0,0,0,$form['date_fin_M'],$form['date_fin_D'],$form['date_fin_Y']);
- if ($utsini > $utsfin) {
- $msg .='1+';
- }
- if ($utsexe < $utsfin) {
- $msg .='2+';
- }
- // fine controlli
-
- if (isset($_POST['print']) && $msg=='') {
- $_SESSION['print_request']=array('script_name'=>'stampa_giomag',
- 'ri'=>date("dmY",$utsini),
- 'rf'=>date("dmY",$utsfin),
- 'ds'=>date("dmY",$utsexe)
- );
- header("Location: sent_print.php");
- exit;
- }
-
- require("../../library/include/header.php");
- $script_transl=HeadMain(0,array('calendarpopup/CalendarPopup'));
- echo "<script type=\"text/javascript\">
- var cal = new CalendarPopup();
- var calName = '';
- function setMultipleValues(y,m,d) {
- document.getElementById(calName+'_Y').value=y;
- document.getElementById(calName+'_M').selectedIndex=m*1-1;
- document.getElementById(calName+'_D').selectedIndex=d*1-1;
- }
- function setDate(name) {
- calName = name.toString();
- var year = document.getElementById(calName+'_Y').value.toString();
- var month = document.getElementById(calName+'_M').value.toString();
- var day = document.getElementById(calName+'_D').value.toString();
- var mdy = month+'/'+day+'/'+year;
- cal.setReturnFunction('setMultipleValues');
- cal.showCalendar('anchor', mdy);
- }
- </script>
- ";
- echo "<form method=\"POST\" name=\"select\">\n";
- echo "<input type=\"hidden\" value=\"".$form['hidden_req']."\" name=\"hidden_req\" />\n";
- echo "<input type=\"hidden\" value=\"".$form['ritorno']."\" name=\"ritorno\" />\n";
- $gForm = new magazzForm();
- echo "<br /><div align=\"center\" class=\"FacetFormHeaderFont\">".$script_transl['title'];
- echo "</div>\n";
- echo "<table class=\"Tsmall\">\n";
- if (!empty($msg)) {
- echo '<tr><td colspan="2" class="FacetDataTDred">'.$gForm->outputErrors($msg,$script_transl['errors'])."</td></tr>\n";
- }
- echo "<tr>\n";
- echo "<td class=\"FacetFieldCaptionTD\">".$script_transl['date']."</td><td class=\"FacetDataTD\">\n";
- $gForm->CalendarPopup('this_date',$form['this_date_D'],$form['this_date_M'],$form['this_date_Y'],'FacetSelect',1);
- echo "</tr>\n";
- echo "<td class=\"FacetFieldCaptionTD\">".$script_transl['date_ini']."</td><td class=\"FacetDataTD\">\n";
- $gForm->CalendarPopup('date_ini',$form['date_ini_D'],$form['date_ini_M'],$form['date_ini_Y'],'FacetSelect',1);
- echo "</tr>\n";
- echo "<tr>\n";
- echo "<td class=\"FacetFieldCaptionTD\">".$script_transl['date_fin']."</td><td class=\"FacetDataTD\">\n";
- $gForm->CalendarPopup('date_fin',$form['date_fin_D'],$form['date_fin_M'],$form['date_fin_Y'],'FacetSelect',1);
- echo "</tr>\n";
- echo "\t<tr class=\"FacetFieldCaptionTD\">\n";
- echo "<td align=\"left\"><input type=\"submit\" name=\"return\" value=\"".$script_transl['return']."\">\n";
- echo '<td align="right"> <input type="submit" accesskey="i" name="preview" value="';
- echo $script_transl['view'];
- echo '" tabindex="100" >';
- echo "\t </td>\n";
- echo "\t </tr>\n";
- echo "</table>\n";
-
- $date_ini = sprintf("%04d%02d%02d",$form['date_ini_Y'],$form['date_ini_M'],$form['date_ini_D']);
- $date_fin = sprintf("%04d%02d%02d",$form['date_fin_Y'],$form['date_fin_M'],$form['date_fin_D']);
-
- if (isset($_POST['preview']) and $msg=='') {
- $m=getMovements($date_ini,$date_fin);
- echo "<table class=\"Tlarge\">";
- if (sizeof($m) > 0) {
- $ctr_mv='';
- echo "<tr>";
- $linkHeaders=new linkHeaders($script_transl['header']);
- $linkHeaders->output();
- echo "</tr>";
- $sum=0.00;
- while (list($key, $mv) = each($m)) {
- $datedoc = substr($mv['datdoc'],8,2).'-'.substr($mv['datdoc'],5,2).'-'.substr($mv['datdoc'],0,4);
- $datereg = substr($mv['datreg'],8,2).'-'.substr($mv['datreg'],5,2).'-'.substr($mv['datreg'],0,4);
- $movQuanti = $mv['quanti']*$mv['operat'];
- $sum += $movQuanti;
- echo "<tr><td class=\"FacetDataTD\">".$datereg." </td>";
- echo "<td align=\"center\" class=\"FacetDataTD\">".$mv['caumag'].'-'.substr($mv['descri'],0,20)."  </td>";
- echo "<td class=\"FacetDataTD\">".substr($mv['desdoc'].' del '.$datedoc.' - '.$mv['ragsoc'],0,85)." </td>";
- echo "<td align=\"right\" class=\"FacetDataTD\">".number_format($mv['prezzo'],$admin_aziend['decimal_price'],',','.')." </td>";
- echo "<td align=\"right\" class=\"FacetDataTD\">".gaz_format_number(CalcolaImportoRigo($mv['quanti'],$mv['prezzo'],array($mv['scochi'],$mv['scorig'])))." </td>";
- echo "<td align=\"right\" class=\"FacetDataTD\">".$mv['unimis']." </td>\n";
- echo "<td align=\"right\" class=\"FacetDataTD\">".gaz_format_quantity($movQuanti,1,$admin_aziend['decimal_quantity'])." </td>\n";
- echo "</tr>\n";
- $ctr_mv = $mv['artico'];
- }
- echo "\t<tr class=\"FacetFieldCaptionTD\">\n";
- echo '<td colspan="7" align="right"><input type="submit" name="print" value="';
- echo $script_transl['print'];
- echo '">';
- echo "\t </td>\n";
- echo "\t </tr>\n";
- }
- echo "</table></form>";
- }
- ?>
- </body>
- </html>