PageRenderTime 27ms CodeModel.GetById 16ms RepoModel.GetById 0ms app.codeStats 0ms

/modules/vendit/admin_effett.php

http://gevion.googlecode.com/
PHP | 304 lines | 271 code | 6 blank | 27 comment | 36 complexity | 463328e6f85d0211343dda2e42699410 MD5 | raw file
Possible License(s): LGPL-2.1, GPL-2.0 
    

  1. <?php

    2. 

  2. /* $Id: admin_effett.php,v 1.4 2010/04/06 07:20:49 devincen Exp $

    3. 

  3.  --------------------------------------------------------------------------

    4. 

  4.                             Gazie - Gestione Azienda

    5. 

  5.     Copyright (C) 2004-2010 - Antonio De Vincentiis Montesilvano (PE)

    6. 

  6.                                 (www.devincentiis.it)

    7. 

  7.                         <http://gazie.sourceforge.net>

    8. 

  8.  --------------------------------------------------------------------------

    9. 

  9.     Questo programma e` free software;   e` lecito redistribuirlo  e/o

    10. 

  10.     modificarlo secondo i  termini della Licenza Pubblica Generica GNU

    11. 

  11.     come e` pubblicata dalla Free Software Foundation; o la versione 2

    12. 

  12.     della licenza o (a propria scelta) una versione successiva.

    13. 

  13. 

    14. 

  14.     Questo programma  e` distribuito nella speranza  che sia utile, ma

    15. 

  15.     SENZA   ALCUNA GARANZIA; senza  neppure  la  garanzia implicita di

    16. 

  16.     NEGOZIABILITA` o di  APPLICABILITA` PER UN  PARTICOLARE SCOPO.  Si

    17. 

  17.     veda la Licenza Pubblica Generica GNU per avere maggiori dettagli.

    18. 

  18. 

    19. 

  19.     Ognuno dovrebbe avere   ricevuto una copia  della Licenza Pubblica

    20. 

  20.     Generica GNU insieme a   questo programma; in caso  contrario,  si

    21. 

  21.     scriva   alla   Free  Software Foundation,  Inc.,   59

    22. 

  22.     Temple Place, Suite 330, Boston, MA 02111-1307 USA Stati Uniti.

    23. 

  23.  --------------------------------------------------------------------------

    24. 

  24. */

    25. 

  25. require("../../library/include/datlib.inc.php");

    26. 

  26. $admin_aziend=checkAdmin();

    27. 

  27. $msg = '';

    28. 

  28. if (isset($_POST['Insert']) || isset($_POST['Update'])) {   //se non e' il primo accesso

    29. 

  29.     $_POST['totfat']=preg_replace("/\,/",'.',$_POST['totfat']);

    30. 

  30.     $_POST['impeff']=preg_replace("/\,/",'.',$_POST['impeff']);

    31. 

  31.     $form=gaz_dbi_parse_post('effett');

    32. 

  32.     $form['ritorno'] = $_POST['ritorno'];

    33. 

  33.     $form['hidden_req'] = $_POST['hidden_req'];

    34. 

  34.     $form['clfoco']=substr($_POST['clfoco'],0,15);

    35. 

  35.     $form['date_emi_D']=intval($_POST['date_emi_D']);

    36. 

  36.     $form['date_emi_M']=intval($_POST['date_emi_M']);

    37. 

  37.     $form['date_emi_Y']=intval($_POST['date_emi_Y']);

    38. 

  38.     $form['date_doc_D']=intval($_POST['date_doc_D']);

    39. 

  39.     $form['date_doc_M']=intval($_POST['date_doc_M']);

    40. 

  40.     $form['date_doc_Y']=intval($_POST['date_doc_Y']);

    41. 

  41.     $form['date_exp_D']=intval($_POST['date_exp_D']);

    42. 

  42.     $form['date_exp_M']=intval($_POST['date_exp_M']);

    43. 

  43.     $form['date_exp_Y']=intval($_POST['date_exp_Y']);

    44. 

  44.     foreach($_POST['search'] as $k=>$v){

    45. 

  45.        $form['search'][$k]=$v;

    46. 

  46.     }

    47. 

  47. 

    48. 

  48.     $toDo = 'update';

    49. 

  49.     if (isset($_POST['Insert'])){

    50. 

  50.        $toDo = 'insert';

    51. 

  51.     }

    52. 

  52.     if (isset($_POST['Submit'])) { // conferma tutto

    53. 

  53.        // inizio controllo campi

    54. 

  54.        if (!checkdate( $form['date_emi_M'], $form['date_emi_D'], $form['date_emi_Y']) ||

    55. 

  55.            !checkdate( $form['date_exp_M'], $form['date_exp_D'], $form['date_exp_Y']) ||

    56. 

  56.            !checkdate( $form['date_doc_M'], $form['date_doc_D'], $form['date_doc_Y'])) {

    57. 

  57.            $msg .='0+';

    58. 

  58.        }

    59. 

  59.        $utsemi= mktime(0,0,0,$form['date_emi_M'],$form['date_emi_D'],$form['date_emi_Y']);

    60. 

  60.        $utsdoc= mktime(0,0,0,$form['date_doc_M'],$form['date_doc_D'],$form['date_doc_Y']);

    61. 

  61.        $utsexp= mktime(0,0,0,$form['date_exp_M'],$form['date_exp_D'],$form['date_exp_Y']);

    62. 

  62.        if ($utsdoc > $utsemi) {

    63. 

  63.           $msg .='3+';

    64. 

  64.        }

    65. 

  65.        if ($utsemi > $utsexp) {

    66. 

  66.           $msg .='4+';

    67. 

  67.        }

    68. 

  68.        if ($form['progre']<1 && $toDo=='update') {

    69. 

  69.           $msg .='5+';

    70. 

  70.        }

    71. 

  71.        if (empty($form['clfoco'])) {

    72. 

  72.           $msg .='6+';

    73. 

  73.        }

    74. 

  74. 

    75. 

  75.        if ($form['impeff']<0.01) {

    76. 

  76.           $msg .='7+';

    77. 

  77.        }

    78. 

  78.        if ($form['banapp']<1) {

    79. 

  79.           $msg .='8+';

    80. 

  80.        }

    81. 

  81.        if ($form['pagame']<1) {

    82. 

  82.           $msg .='9+';

    83. 

  83.        }

    84. 

  84.        //  --- fine controlli ----

    85. 

  85. 

    86. 

  86.        if (empty($msg)) { // nessun errore

    87. 

  87.           $tipeff=gaz_dbi_get_row($gTables['pagame'],'codice',$form['pagame']);

    88. 

  88.           $form['tipeff']=$tipeff['tippag'];

    89. 

  89.           $form['datemi']=sprintf("%04d-%02d-%02d",$form['date_emi_Y'],$form['date_emi_M'],$form['date_emi_D']);

    90. 

  90.           $form['datfat']=sprintf("%04d-%02d-%02d",$form['date_doc_Y'],$form['date_doc_M'],$form['date_doc_D']);

    91. 

  91.           $form['scaden']=sprintf("%04d-%02d-%02d",$form['date_exp_Y'],$form['date_exp_M'],$form['date_exp_D']);

    92. 

  92.           $anagrafica = new Anagrafica();

    93. 

  93.           if (preg_match("/^id_([0-9]+)$/",$form['clfoco'],$match)) {

    94. 

  94.              $new_clfoco = $anagrafica->getPartnerData($match[1],1);

    95. 

  95.              $form['clfoco']=$anagrafica->anagra_to_clfoco($new_clfoco,$admin_aziend['mascli']);

    96. 

  96.           }

    97. 

  97.           if ($toDo == 'insert') {

    98. 

  98.               // ricavo il progressivo annuo, ma se e' il primo effetto dell'anno, resetto il contatore

    99. 

  99.               $rs_last_effett = gaz_dbi_dyn_query("progre", $gTables['effett'], "YEAR(datemi) = ".$form['date_emi_Y'] ,"progre DESC",0,1);

    100. 

  100.               $last_progre = gaz_dbi_fetch_array($rs_last_effett);

    101. 

  101.               if ($last_progre) {

    102. 

  102.                  $form['progre'] = $last_progre['progre'] + 1;

    103. 

  103.               } else{

    104. 

  104.                  $form['progre'] = 1;

    105. 

  105.               }

    106. 

  106.               gaz_dbi_table_insert('effett',$form);

    107. 

  107.           } else {

    108. 

  108.               gaz_dbi_table_update('effett',array('id_tes',intval($form['id_tes'])),$form);

    109. 

  109.           }

    110. 

  110.           header("Location: report_effett.php");

    111. 

  111.           exit;

    112. 

  112.        }

    113. 

  113.     } elseif (isset($_POST['Return'])) { // torno indietro

    114. 

  114.           header("Location: ".$form['ritorno']);

    115. 

  115.           exit;

    116. 

  116.     }

    117. 

  117. 

    118. 

  118.     // Se viene inviata la richiesta di conferma cliente

    119. 

  119.     if ($_POST['hidden_req']=='clfoco') {

    120. 

  120.         $anagrafica = new Anagrafica();

    121. 

  121.         if (preg_match("/^id_([0-9]+)$/",$form['clfoco'],$match)) {

    122. 

  122.            $cliente = $anagrafica->getPartnerData($match[1],1);

    123. 

  123.         } else {

    124. 

  124.            $cliente = $anagrafica->getPartner($form['clfoco']);

    125. 

  125.         }

    126. 

  126.         $form['pagame']=$cliente['codpag'];

    127. 

  127.         $form['banapp']=$cliente['banapp'];

    128. 

  128.         $form['hidden_req'] = '';

    129. 

  129.     }

    130. 

  130. 

    131. 

  131. } elseif (!isset($_POST['Update']) && isset($_GET['Update'])) { //se e' il primo accesso per UPDATE

    132. 

  132.     $form=gaz_dbi_get_row($gTables['effett'],'id_tes',intval($_GET['id']));

    133. 

  133.     $form['date_emi_D'] = substr($form['datemi'],8,2);

    134. 

  134.     $form['date_emi_M'] = substr($form['datemi'],5,2);

    135. 

  135.     $form['date_emi_Y'] = substr($form['datemi'],0,4);

    136. 

  136.     $form['date_doc_D'] = substr($form['datfat'],8,2);

    137. 

  137.     $form['date_doc_M'] = substr($form['datfat'],5,2);

    138. 

  138.     $form['date_doc_Y'] = substr($form['datfat'],0,4);

    139. 

  139.     $form['date_exp_D'] = substr($form['scaden'],8,2);

    140. 

  140.     $form['date_exp_M'] = substr($form['scaden'],5,2);

    141. 

  141.     $form['date_exp_Y'] = substr($form['scaden'],0,4);

    142. 

  142.     $toDo = 'update';

    143. 

  143.     $form['search']['clfoco']='';

    144. 

  144.     $form['ritorno']=$_SERVER['HTTP_REFERER'];

    145. 

  145.     $form['hidden_req'] = '';

    146. 

  146. } elseif (!isset($_POST['Insert'])) { //se e' il primo accesso per INSERT

    147. 

  147.     $anagrafica = new Anagrafica();

    148. 

  148.     $last=$anagrafica->queryPartners('*',"codice BETWEEN ".$admin_aziend['mascli']."000000 AND ".$admin_aziend['mascli']."999999" ,"codice DESC",0,1);

    149. 

  149.     $form=gaz_dbi_fields('effett');

    150. 

  150.     $toDo = 'insert';

    151. 

  151.     $form['date_emi_D']=date("d");

    152. 

  152.     $form['date_emi_M']=date("m");

    153. 

  153.     $form['date_emi_Y']=date("Y");

    154. 

  154.     $form['date_doc_D']=date("d");

    155. 

  155.     $form['date_doc_M']=date("m");

    156. 

  156.     $form['date_doc_Y']=date("Y");

    157. 

  157.     $form['date_exp_D']=date("d");

    158. 

  158.     $form['date_exp_M']=date("m");

    159. 

  159.     $form['date_exp_Y']=date("Y");

    160. 

  160.     $form['search']['clfoco']='';

    161. 

  161.     $form['ritorno']=$_SERVER['HTTP_REFERER'];

    162. 

  162.     $form['hidden_req'] = '';

    163. 

  163. }

    164. 

  164. require("../../library/include/header.php");

    165. 

  165. $script_transl = HeadMain('',array('calendarpopup/CalendarPopup'),'select_effett');

    166. 

  166. echo "<script type=\"text/javascript\">

    167. 

  167. var cal = new CalendarPopup();

    168. 

  168. var calName = '';

    169. 

  169. function setMultipleValues(y,m,d) {

    170. 

  170.      document.getElementById(calName+'_Y').value=y;

    171. 

  171.      document.getElementById(calName+'_M').selectedIndex=m*1-1;

    172. 

  172.      document.getElementById(calName+'_D').selectedIndex=d*1-1;

    173. 

  173. }

    174. 

  174. function setDate(name) {

    175. 

  175.   calName = name.toString();

    176. 

  176.   var year = document.getElementById(calName+'_Y').value.toString();

    177. 

  177.   var month = document.getElementById(calName+'_M').value.toString();

    178. 

  178.   var day = document.getElementById(calName+'_D').value.toString();

    179. 

  179.   var mdy = month+'/'+day+'/'+year;

    180. 

  180.   cal.setReturnFunction('setMultipleValues');

    181. 

  181.   cal.showCalendar('anchor', mdy);

    182. 

  182. }

    183. 

  183. </script>

    184. 

  184. ";

    185. 

  185. echo "<form method=\"POST\" name=\"select\">\n";

    186. 

  186. echo "<input type=\"hidden\" name=\"ritorno\" value=\"".$form['ritorno']."\">\n";

    187. 

  187. echo "<input type=\"hidden\" value=\"".$form['hidden_req']."\" name=\"hidden_req\" />\n";

    188. 

  188. echo "<input type=\"hidden\" name=\"".ucfirst($toDo)."\" value=\"\">";

    189. 

  189. $gForm = new venditForm();

    190. 

  190. $select_customer = new selectPartner('clfoco');

    191. 

  191. 

    192. 

  192. if ($toDo == 'insert') {

    193. 

  193.    echo "<div align=\"center\" class=\"FacetFormHeaderFont\">".$script_transl['ins_this'];

    194. 

  194.    echo "<input type=\"hidden\" value=\"".$form['progre']."\" name=\"progre\" />\n";

    195. 

  195.    echo "<input type=\"hidden\" value=\"\" name=\"id_tes\" />\n";

    196. 

  196. } else {

    197. 

  197.    echo "<div align=\"center\" class=\"FacetFormHeaderFont\">".$script_transl['upd_this'];

    198. 

  198.    echo "<input type=\"hidden\" value=\"".$form['id_tes']."\" name=\"id_tes\" />\n";

    199. 

  199. }

    200. 

  200. $select_customer->selectDocPartner('clfoco',$form['clfoco'],$form['search']['clfoco'],'clfoco',$script_transl['mesg'],$admin_aziend['mascli']);

    201. 

  201. echo "</div>\n" ;

    202. 

  202. echo "<table class=\"Tmiddle\">\n";

    203. 

  203. if (!empty($msg)) {

    204. 

  204.     echo '<tr><td colspan="3" class="FacetDataTDred">'.$gForm->outputErrors($msg,$script_transl['errors'])."</td></tr>\n";

    205. 

  205. }

    206. 

  206. if ($toDo == 'update') {

    207. 

  207.    echo "<tr>\n";

    208. 

  208.    echo "\t<td class=\"FacetFieldCaptionTD\"> ID </td>\n";

    209. 

  209.    echo "\t<td colspan=\"2\" class=\"FacetDataTD\"> ".$form['id_tes']." </td>\n";

    210. 

  210.    echo "</tr>\n";

    211. 

  211.    echo "<tr>\n";

    212. 

  212.    echo "\t<td class=\"FacetFieldCaptionTD\">".$script_transl['progre']."* </td>\n";

    213. 

  213.    echo "\t<td colspan=\"2\" class=\"FacetDataTD\">

    214. 

  214.         <input type=\"text\" name=\"progre\" value=\"".$form['progre']."\" align=\"right\" maxlength=\"9\" size=\"9\" /></td>\n";

    215. 

  215.    echo "</tr>\n";

    216. 

  216. }

    217. 

  217. echo "<tr>\n";

    218. 

  218. echo "\t<td class=\"FacetFieldCaptionTD\">".$script_transl['type'].' - '.$script_transl['pagame']." * </td><td colspan=\"2\" class=\"FacetDataTD\">\n";

    219. 

  219. echo "<select name=\"pagame\" class=\"FacetSelect\"  onchange=\"this.form.submit()\">\n";

    220. 

  220.       $rs_pagame = gaz_dbi_dyn_query ('*', $gTables['pagame'], "tippag = 'B' OR tippag = 'T' OR tippag = 'V'",'tippag');

    221. 

  221.       echo "\t\t <option value=\"0\"></option>\n";

    222. 

  222.       while ($r = gaz_dbi_fetch_array($rs_pagame)) {

    223. 

  223.             $selected = "";

    224. 

  224.             if($r["codice"] == $form['pagame'])

    225. 

  225.                 $selected = "selected";

    226. 

  226.             echo "\t\t <option value=\"".$r["codice"]."\" $selected >".$script_transl['type_pay'][$r["tippag"]]." - ".$r["descri"]."</option>\n";

    227. 

  227.             }

    228. 

  228. echo "</select>\n";

    229. 

  229. echo "\t </td>\n";

    230. 

  230. echo "</tr>\n";

    231. 

  231. echo "<tr>\n";

    232. 

  232. echo "<td class=\"FacetFieldCaptionTD\">".$script_transl['date_emi']."</td><td colspan=\"2\" class=\"FacetDataTD\">\n";

    233. 

  233. $gForm->CalendarPopup('date_emi',$form['date_emi_D'],$form['date_emi_M'],$form['date_emi_Y'],'FacetSelect',1);

    234. 

  234. echo "</tr>\n";

    235. 

  235. echo "<tr>\n";

    236. 

  236. echo "\t<td class=\"FacetFieldCaptionTD\">".$script_transl['numfat']." </td>\n";

    237. 

  237. echo "\t<td colspan=\"2\" class=\"FacetDataTD\">

    238. 

  238.       <input type=\"text\" name=\"numfat\" value=\"".$form['numfat']."\" style=\"text-align:right;\" maxlength=\"9\" size=\"9\" /></td>\n";

    239. 

  239. echo "</tr>\n";

    240. 

  240. echo "<tr>\n";

    241. 

  241. echo "<td class=\"FacetFieldCaptionTD\">".$script_transl['vat_section']."</td><td class=\"FacetDataTD\">\n";

    242. 

  242. $gForm->selectNumber('seziva',$form['seziva'],0,1,3);

    243. 

  243. echo "\t </td>\n";

    244. 

  244. echo "</tr>\n";

    245. 

  245. echo "<tr>\n";

    246. 

  246. echo "<td class=\"FacetFieldCaptionTD\">".$script_transl['date_doc']."</td><td colspan=\"2\" class=\"FacetDataTD\">\n";

    247. 

  247. $gForm->CalendarPopup('date_doc',$form['date_doc_D'],$form['date_doc_M'],$form['date_doc_Y'],'FacetSelect',1);

    248. 

  248. echo "</tr>\n";

    249. 

  249. echo "<tr>\n";

    250. 

  250. echo "\t<td class=\"FacetFieldCaptionTD\">".$script_transl['totfat']." </td>\n";

    251. 

  251. echo "\t<td colspan=\"2\" class=\"FacetDataTD\">

    252. 

  252.       <input type=\"text\" name=\"totfat\" value=\"".$form['totfat']."\" style=\"text-align:right;\" maxlength=\"12\" size=\"12\" /></td>\n";

    253. 

  253. echo "</tr>\n";

    254. 

  254. echo "<tr>\n";

    255. 

  255. echo "<td class=\"FacetFieldCaptionTD\">".$script_transl['salacc']."</td><td colspan=\"2\" class=\"FacetDataTD\">\n";

    256. 

  256. $gForm->variousSelect('salacc',$script_transl['salacc_value'],$form['salacc']);

    257. 

  257. echo "\t </td>\n";

    258. 

  258. echo "</tr>\n";

    259. 

  259. echo "<tr>\n";

    260. 

  260. echo "\t<td class=\"FacetFieldCaptionTD\">".$script_transl['impeff']." * </td>\n";

    261. 

  261. echo "\t<td colspan=\"2\" class=\"FacetDataTD\">

    262. 

  262.       <input type=\"text\" name=\"impeff\" value=\"".$form['impeff']."\" style=\"text-align:right;\" maxlength=\"12\" size=\"12\" /></td>\n";

    263. 

  263. echo "</tr>\n";

    264. 

  264. echo "<tr>\n";

    265. 

  265. echo "<td class=\"FacetFieldCaptionTD\">".$script_transl['date_exp']."</td><td colspan=\"2\" class=\"FacetDataTD\">\n";

    266. 

  266. $gForm->CalendarPopup('date_exp',$form['date_exp_D'],$form['date_exp_M'],$form['date_exp_Y'],'FacetSelect',1);

    267. 

  267. echo "</tr>\n";

    268. 

  268. echo "<tr>\n";

    269. 

  269. echo "<td class=\"FacetFieldCaptionTD\">".$script_transl['banapp']." * </td><td colspan=\"2\" class=\"FacetDataTD\" colspan=\"2\">\n";

    270. 

  270. $select_banapp = new selectbanapp("banapp");

    271. 

  271. $select_banapp->addSelected($form["banapp"]);

    272. 

  272. $select_banapp->output();

    273. 

  273. echo "</td>\n";

    274. 

  274. echo "</tr>\n";

    275. 

  275. echo "<tr>\n";

    276. 

  276. echo "<td class=\"FacetFieldCaptionTD\">".$script_transl['banacc']."</td><td colspan=\"2\" class=\"FacetDataTD\">\n";

    277. 

  277. echo "<select name=\"banacc\" class=\"FacetSelect\">";

    278. 

  278. $rs_banacc = gaz_dbi_dyn_query("codice,descri,iban", $gTables['clfoco'],"codice BETWEEN ".$admin_aziend['masban']."000001 AND ".$admin_aziend['masban']."999999 AND iban != ''","descri");

    279. 

  279. echo "<option value=\"0\"> </option>";

    280. 

  280. while ($r = gaz_dbi_fetch_array($rs_banacc)) {

    281. 

  281.        $selected="";

    282. 

  282.        if($form['banacc'] == $r['codice']) {

    283. 

  283.             $selected = " selected ";

    284. 

  284.        }

    285. 

  285.        echo "<option value=\"".$r['codice']."\"".$selected.">".$r['descri']."</option>";

    286. 

  286. }

    287. 

  287. echo "</select></td>\n";

    288. 

  288. echo "</td>\n";

    289. 

  289. echo "</tr>\n";

    290. 

  290. echo "<tr>\n";

    291. 

  291. echo "\t<td class=\"FacetFieldCaptionTD\">".$script_transl['sqn']."</td>";

    292. 

  292. echo "\t </td>\n";

    293. 

  293. echo "\t<td  class=\"FacetDataTD\">\n";

    294. 

  294. echo '<input name="Return" type="submit" value="'.$script_transl['return'].'!">';

    295. 

  295. echo "\t </td>\n";

    296. 

  296. echo "\t<td  class=\"FacetDataTD\" align=\"right\">\n";

    297. 

  297. echo '<input name="Submit" type="submit" value="'.strtoupper($script_transl[$toDo]).'!">';

    298. 

  298. echo "\t </td>\n";

    299. 

  299. echo "</tr>\n";

    300. 

  300. ?>

    301. 

  301. </table>

    302. 

  302. </form>

    303. 

  303. </body>

    304. 

  304. </html>
    305.