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);
