function selectCustomer($name,$val,$strSearch='',$val_hiddenReq='',$mesg,$class='FacetSelect') { global $gTables,$admin_aziend; $anagrafica = new Anagrafica(); if ($val>100000000) { //vengo da una modifica della precedente select case quindi non serve la ricerca $partner = $anagrafica->getPartner($val); echo "\t<input type=\"hidden\" name=\"$name\" value=\"$val\">\n"; echo "\t<input type=\"hidden\" name=\"search[$name]\" value=\"".substr($partner['ragso1'],0,8)."\">\n"; echo "\t<input type=\"submit\" value=\"".$partner['ragso1']." ".$partner["ragso2"]." ".$partner["citspe"]." (".$partner["codice"].")\" name=\"change\" onclick=\"this.form.$name.value='0'; this.form.hidden_req.value='change';\" title=\"$mesg[2]\">\n"; } else { if (strlen($strSearch) >= 2) { //sto ricercando un nuovo partner echo "\t<select tabindex=\"1\" name=\"$name\" class=\"FacetSelect\" onchange=\"this.form.hidden_req.value='$name'; this.form.submit();\">\n"; echo "<option value=\"0\"> ---------- </option>"; $partner = $anagrafica->queryPartners("*", "codice LIKE '".$admin_aziend['mascli']."%' AND codice >".intval($admin_aziend['mascli'].'000000')." AND ragso1 LIKE '".addslashes($strSearch)."%'","codice ASC"); if (count($partner) > 0) { foreach ($partner as $r) { $selected = ''; if ($r['codice'] == $val) { $selected = "selected"; } echo "\t\t <option value=\"".$r['codice']."\" $selected >".$r['ragso1']." ".$r["ragso2"]." ".$r["citspe"]."</option>\n"; } echo "\t </select>\n"; } else { $msg = $mesg[0]; } } else { $msg = $mesg[1]; echo "\t<input type=\"hidden\" name=\"$name\" value=\"$val\">\n"; } echo "\t<input tabindex=\"2\" type=\"text\" id=\"search_$name\" name=\"search[$name]\" value=\"".$strSearch."\" maxlength=\"15\" size=\"9\" class=\"FacetInput\">\n"; if (isset($msg)) { echo "<input type=\"text\" style=\"color: red; font-weight: bold;\" size=\"".strlen($msg)."\" disabled value=\"$msg\">"; } echo "\t<input tabindex=\"3\" type=\"image\" align=\"middle\" name=\"search_str\" src=\"../../library/images/cerbut.gif\">\n"; } }
} } elseif (!isset($_POST['Update']) && isset($_GET['Update'])) { //se e' il primo accesso per UPDATE $anagrafica = new Anagrafica(); $form = $anagrafica->getPartner(intval($admin_aziend['mascli']*1000000+$_GET['codice'])); $form['codice'] = intval(substr($form['codice'],3)); $toDo = 'update'; $form['search']['id_des']=''; $form['ritorno']=$_SERVER['HTTP_REFERER']; $form['hidden_req'] = ''; $form['datnas_Y'] = substr($form['datnas'],0,4); $form['datnas_M'] = substr($form['datnas'],5,2); $form['datnas_D'] = substr($form['datnas'],8,2); } elseif (!isset($_POST['Insert'])) { //se e' il primo accesso per INSERT $anagrafica = new Anagrafica(); $last=$anagrafica->queryPartners('*',"codice BETWEEN ".$admin_aziend['mascli']."000000 AND ".$admin_aziend['mascli']."999999" ,"codice DESC",0,1); $form=array_merge(gaz_dbi_fields('clfoco'),gaz_dbi_fields('anagra')); $form['codice']=substr($last[0]['codice'],3) + 1; $toDo = 'insert'; $form['search']['id_des']=''; $form['country']=$admin_aziend['country']; $form['id_language']=$admin_aziend['id_language']; $form['id_currency']=$admin_aziend['id_currency']; $form['datnas_Y'] =1900; $form['datnas_M'] =1; $form['datnas_D'] =1; $form['counas']=$admin_aziend['country']; $form['codpag']=1; $form['spefat']='N'; $form['stapre']='N'; $form['allegato']=1;
echo "<tr><td class=\"FacetFieldCaptionTD\">".$script_transl[3]."⇔".$script_transl[4]."</td><td class=\"FacetDataTD\">\n"; $messaggio = ""; $ric_mastro = substr($form['clfoco'],0,3); echo "\t<input type=\"hidden\" name=\"clfoco\" value=\"".$form['clfoco']."\">\n"; echo "\t<input type=\"hidden\" name=\"clorfo\" value=\"".$form['clorfo']."\">\n"; $rs_partner= "(codice between ".$admin_aziend['mascli']."000001 and ".$admin_aziend['mascli']."999999 or codice between ".$admin_aziend['masfor']."000001 and ".$admin_aziend['masfor']."999999 )"; if ($form['clorfo'] < 0) { // cliente $rs_partner= "(codice between ".$admin_aziend['mascli']."000001 and ".$admin_aziend['mascli']."999999 )"; } elseif ($form['clorfo'] > 0) {// fornitore $rs_partner= "(codice between ".$admin_aziend['masfor']."000001 and ".$admin_aziend['masfor']."999999 )"; } if ($form['clfoco']==0) { if (strlen($form['search_partner']) >= 2) { $anagrafica = new Anagrafica(); $partner = $anagrafica->queryPartners("*", $rs_partner." and ragso1 like '".addslashes($form['search_partner'])."%'", "codice asc, ragso1 asc"); if (sizeof($partner) > 0) { $clifor = $script_transl[5]; echo "\t<select name=\"clfoco\" class=\"FacetSelect\" onchange=\"this.form.hidden_req.value='new_price'; this.form.submit();\">\n"; echo "<option value=\"000000000\"> ---------- </option>"; while (list($key, $row) = each($partner)) { $selected = ""; if ($row["codice"] == $form['clfoco']) { $selected = "selected"; } if (substr($row["codice"],0,3) == $admin_aziend['masfor']) { $clifor = $script_transl[6]; } echo "\t\t <option value=\"".$row["codice"]."\" $selected >".$row["ragso1"]." ".$row["citspe"]." ($clifor)</option>\n"; } echo "\t </select>\n";
function selSubAccount($name,$val,$strSearch='',$val_hiddenReq='',$mesg,$class='FacetSelect') { global $gTables,$admin_aziend; $mas_query=''; $ctrl_mas=substr($val,0,3); $master=intval($ctrl_mas*1000000); if (isset($this->master_value)){ if ($this->sub_name==$name && $this->master_value >100) { // // se e' gia' stato selezionato un conto legato al mastro $ctrl_mas=substr($this->master_value,0,3); $where="codice LIKE '".intval($ctrl_mas)."%' AND codice > ".$this->master_value; } else { // nessuno $where="codice < 0"; } } else { //altrimenti tutti tranne i mastri $where="codice NOT LIKE '%000000'"; } if ($ctrl_mas == $admin_aziend['mascli'] || $ctrl_mas == $admin_aziend['masfor']) { // cliente o fornitore $anagrafica = new Anagrafica(); if ($val>100000000 && $ctrl_mas==substr($val,0,3)) { //vengo da una modifica della precedente select case quindi non serve la ricerca $partner = $anagrafica->getPartner($val); echo "\t<input type=\"hidden\" name=\"$name\" value=\"$val\">\n"; echo "\t<input type=\"hidden\" name=\"search[$name]\" value=\"".substr($partner['ragso1'],0,8)."\">\n"; echo "\t<input type=\"submit\" value=\"".$partner['ragso1']."\" name=\"change\" onclick=\"this.form.$name.value='0'; this.form.hidden_req.value='change';\" title=\"$mesg[2]\">\n <input type=\"image\" onclick=\"dialogSchedule(this);return false;\" href=\"#\" id=\"paymov".$val.$name."\" src=\"../../library/images/schedule.png\" />\n"; } else { if (strlen($strSearch) >= 2) { //sto ricercando un nuovo partner echo "\t<select name=\"$name\" class=\"FacetSelect\" onchange=\"this.form.hidden_req.value='$name'; this.form.submit();\">\n"; echo "<option value=\"0\"> ---------- </option>"; $partner = $anagrafica->queryPartners("*", $where." AND ragso1 LIKE '".addslashes($strSearch)."%'","codice ASC"); if (count($partner) > 0) { foreach ($partner as $r) { $selected = ''; if ($r['codice'] == $val) { $selected = "selected"; } echo "\t\t <option value=\"".$r['codice']."\" $selected >".intval($r['codice'])."-".$r["ragso1"]." ".$r["citspe"]."</option>\n"; } echo "\t </select>\n"; } else { $msg = $mesg[0]; } } else { $msg = $mesg[1]; echo "\t<input type=\"hidden\" name=\"$name\" value=\"$val\">\n"; } echo "\t<input type=\"text\" id=\"search_$name\" name=\"search[$name]\" value=\"".$strSearch."\" maxlength=\"15\" size=\"9\" class=\"FacetInput\">\n"; if (isset($msg)) { echo "<input type=\"text\" style=\"color: red; font-weight: bold;\" size=\"".strlen($msg)."\" disabled value=\"$msg\">"; } echo "\t<input type=\"image\" align=\"middle\" name=\"search_str\" src=\"../../library/images/cerbut.gif\">\n"; } } else { // altri sottoconti echo "\t<input type=\"hidden\" name=\"search[$name]\" value=\"\">\n"; echo "\t<select name=\"$name\" class=\"FacetSelect\" onchange=\"this.form.hidden_req.value='$name'; this.form.submit();\">\n"; echo "<option value=\"0\"> ---------- </option>"; $result = gaz_dbi_dyn_query("*", $gTables['clfoco'],$where,"codice ASC"); while ($r = gaz_dbi_fetch_array($result)) { $selected=''; if ($val == $r['codice']) { $selected = " selected "; } if(isset($this->master_value)){ $descri= substr($r["codice"],3,6); } else { $descri= $r["codice"]; } echo "<option value=\"".$r['codice']."\"".$selected.">$descri-".$r['descri']."</option>"; } echo "</select>\n"; } }
</tr> <tr> <td class="FacetFieldCaptionTD">Stampa data </td> <td class="FacetDataTD"><input title="Scegliere se stampare o meno la data inserita sotto" type="checkbox" name="stadat" value="1" ></td> </tr> <tr> <td class="FacetFieldCaptionTD">Cliente/Fornitore</td> <?php echo "<td class=\"FacetColumnTD\">"; $messaggio = ""; $ric_mastro = substr($_POST['cod_partner'],0,3); if ($_POST['cod_partner'] == 0) { $tabula =" tabindex=\"1\" "; if (strlen($_POST['cerca_partner']) >= 2) { $anagrafica = new Anagrafica(); $partner = $anagrafica->queryPartners("*", "(codice between '$iniclienti' and '$finclienti' or codice between '$inifornitori' and '$finfornitori') and ragso1 like '{$_POST['cerca_partner']}%'", "ragso1 asc"); if (sizeof($partner) > 0) { $tabula=""; echo "\t<select name=\"cod_partner\" class=\"FacetSelect\" onchange=\"this.form.submit()\">\n"; echo "<option value=\"000000000\"> ---------- </option>"; while (list($key, $row) = each($partner)) { $selected = ""; if ($row["codice"] == $_POST['cod_partner']) { $selected = "selected"; } echo "\t\t <option value=\"".$row["codice"]."\" $selected >".$row["ragso1"]." ".$row["citspe"]."</option>\n"; } echo "\t </select>\n"; } else { $messaggio = "Non è stato trovato nulla!"; }
echo "<td class=\"FacetFieldCaptionTD\">$script_transl[2] : </td><td class=\"FacetDataTD\">\n"; if ($toDo == 'update') { echo "\t<input type=\"hidden\" name=\"id_agente\" value=\"".$form['id_agente']."\" /><div class=\"FacetDataTD\">".$form['id_agente']."<div>\n"; } else { echo "\t<input type=\"text\" name=\"id_agente\" value=\"".$form['id_agente']."\" maxlength=\"3\" size=\"3\" class=\"FacetInput\" />\n"; } echo "</td></tr>\n"; echo "<tr>\n"; echo "<td class=\"FacetFieldCaptionTD\">$script_transl[3] : </td><td class=\"FacetDataTD\">\n"; $messaggio = ""; $ric_mastro = substr($form['id_fornitore'],0,3); if ($form['id_fornitore'] == 0) { $tabula =" tabindex=\"1\" "; if (strlen($form['cerca_fornitore']) >= 2) { $anagrafica = new Anagrafica(); $fornitore = $anagrafica->queryPartners("*", "(codice between '$inifornitori' and '$finfornitori' ) and ragso1 like '".addslashes($form['cerca_fornitore'])."%'", "ragso1 asc"); if (sizeof($fornitore) > 0) { $tabula=""; echo "\t<select name=\"id_fornitore\" class=\"FacetSelect\" onchange=\"this.form.submit()\">\n"; echo "<option value=\"000000000\"> ---------- </option>"; while (list($key, $row) = each($fornitore)) { $selected = ""; if ($row["codice"] == $form['id_fornitore']) { $selected = "selected"; } echo "\t\t <option value=\"".$row["codice"]."\" $selected >".$row["ragso1"]." ".$row["citspe"]."</option>\n"; } echo "\t </select>\n"; } else { $messaggio = "Non è stato trovato nulla!"; echo "\t<input type=\"hidden\" name=\"id_fornitore\" value=\"".$form['id_fornitore']."\">\n";
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(); require("../../library/include/header.php"); $script_transl = HeadMain(); $where = "codice BETWEEN ".$admin_aziend['masban']."000001 AND ".$admin_aziend['masban']."999999"; $anagrafica = new Anagrafica(); $result=$anagrafica->queryPartners('*', $where, $orderby, $limit, $passo); echo '<div align="center" class="FacetFormHeaderFont">'.$script_transl['title'].'</div>'; $recordnav = new recordnav($gTables['clfoco'], $where, $limit, $passo); $recordnav -> output(); echo '<table class="Tlarge">'; $headers = array ( $script_transl['codice']=>'codice', $script_transl['ragso1']=>'ragso1', $script_transl['iban']=>'iban', $script_transl['citspe']=>'citspe', $script_transl['prospe']=>'prospe', $script_transl['telefo']=>'telefo', $script_transl['view']=>'', $script_transl['delete']=>'' ); $linkHeaders = new linkHeaders($headers);