</tr> <tr> <td> <form class="jss-NoMargins" method="POST" name="newDataBase"> <table id="table2" class="jss-TableBorder" style="width: 100%;"> <tr> <td class="jss-Bar"> Create new dataBase</td> </tr> <tr> <td>From Template:</td> </tr> <tr> <td style="text-align: right;"> <select class="jss-FieldAuto" name="dbTemplate" size="1"> <?php echo putOptions($dbTemplates, ''); ?> </select></td> </tr> <tr> <td>New Domain name:</td> </tr> <tr> <td style="text-align: right"> <input class="jss-FieldAuto" maxlength="15" name="dbName" size="25"></td> </tr> <tr> <td style="text-align: center; "> <input class="jss-Boton" name="Create" type="submit" value="Create"></td> </tr> </table>
<?php echo putOptions($varsql1, $varItem1); ?> </select></td> <td> <select id="varItem2" class="jss-FieldAuto" name="varItem2" size="1"> <option>-</option> <?php echo putOptions($varsql2, $varItem2); ?> </select></td> <td> <select id="varItem3" class="jss-FieldAuto" name="varItem3" size="1"> <option>-</option> <?php echo putOptions($varsql3, $varItem3); ?> </select></td> <td> <input id="from" class="jss-DatePicker" maxlength="12" name="from" size="12" style="width: 100%" value="<?php echo $from; ?> "></td> <td> <input id="to" class="jss-DatePicker" maxlength="12" name="to" size="12" style="width: 100%" value="<?php echo $to; ?> "></td> <td style="text-align: center"> <input class="jss-Boton" name="buscar" type="submit" value="Search"></td> </tr>
while ($gv = $GLOBALS['rst']->fetch()) { ?> <form action="stocks.php" class="NoMargenes" method="POST" name="<?php echo 'frmPrices' . $nr; ?> "> <tr> <td> <input class="jss-FieldAuto" name="id" size="5" style="text-align: right" value="<?php echo $gv["id"]; ?> "></td> <td><select class="jss-FieldAuto" name="idStore" size="1"> <option>-</option> <?php echo putOptions("select idStore, store from [stores] order by store", $gv["idStore"]); ?> </select></td> <td> <input class="jss-FieldNum" name="amount" size="12" value="<?php echo $gv["amount"]; ?> "></td> <td align="center"> <a href="stocks.php?eliminar=<?php echo $gv['id']; ?> "> <img border="0" src="../../images/Delete16.gif" style="width: 16px; height: 16px"></a></td> <td align="center"> <input class="jss-BotonSave" name="salvar" type="submit" value="<?php
</select> </td> <td style="text-align: left"> <input id="valorBuscar" class="jss-FieldAuto" name="valorBuscar" size="45" value="<?php echo $valorBuscar; ?> "> </td> <td style="text-align: right" class="jss-Bar"><?php echo _RATE; ?> :</td> <td style="text-align: left"> <select class="jss-FieldAuto" name="rate" onchange="javascript: frOpciones.submit()" size="1"> <option>-</option> <?php echo putOptions("select Rate from Rates order by Rate", $rate); ?> </select></td> <td style="text-align: center" rowspan="2"> <input class="jss-Boton" name="insertar" onclick="javascript:document.location.replace('ficha.php?idProduct=0')" type="button" value="<?php echo _NEW; ?> "></td> </tr> <tr> <td id="azBar" colspan="4" ></td> </tr> </table> </form> </td> </tr>
<tr> <td style="height: 1%"> <form class="jss-NoMargins" method="post" name="fData"> <table class="jss-Table" style="width: 100%"> <tr> <td class="jss-Caption"><?php echo _OPEN; ?> :</td> <td class="jss-Caption" id="reference" style="text-align: right"></td> </tr> <tr> <td colspan="2"> <select id="idModel" class="jss-FieldAuto" name="idModel" onchange="javascript: changeDoc(this.value, this.options[this.selectedIndex].text);" size="1"> <?php echo putOptions("select idModel, title from [docsModel] order by title ", ""); ?> </select></td> </tr> <tr> <td class="jss-Bar" colspan="2"><?php echo _TITLE; ?> :</td> </tr> <tr> <td colspan="2"> <input id="title" class="jss-FieldAuto" name="title" size="80" type="text"></td> </tr> <tr> <td class="jss-Bar" colspan="2"><?php
$results = $GLOBALS['db']->exec($strsql); $strsql = "select number from invoiceSeries where serie='" . $_REQUEST['serie'] . "'"; $results = $GLOBALS['db']->query($strsql); if ($results) { $results = $results->fetch(); echo $results['number']; } exit; } // DIRLIST //********************************************** if (isset($_REQUEST['dirList'])) { $dirList = dirList($_REQUEST['dirList']); //print_r($dirList); if (count($dirList) > 0) { echo putOptions($dirList, '-'); } exit; } // TOXLS //********************************************** if (isset($_REQUEST['toXls'])) { jCnn(); $strsql = base64_decode($_REQUEST['toXls']); $results = $GLOBALS['db']->query($strsql); //header $valRet = '<table border=1><tr>'; for ($col = 0; $col < $results->columnCount(); $col++) { $meta = $results->getColumnMeta($col); $valRet = $valRet . '<th>' . $meta['name'] . '</th>'; }
<?php require "../../../cgi_bin/phpFun.php"; require "../languages/language.php"; jCnn(); //------------------------------------------------- // Parametros Agents //------------------------------------------------- $buscaPor = "name"; $strsql = "SELECT idAgent, departament, name, city, phone FROM [agents] "; $table = "agents"; $keyMaster = "idAgent"; //------------------------------------------------- //recoge el puntero //------------------------------------------------- if (isset($_REQUEST["id"])) { if (!isset($_FILES["file"])) { $_SESSION[$keyMaster] = $_REQUEST["id"]; } $goTo = "tableImg.php"; $script = "var tdPos=document.getElementsByName('idPos')[0].parentNode;\n" . "var valPos=document.getElementsByName('idPos')[0].value;\n" . 'var objSelect=\'<select class="jss-FieldAuto" name="idPos" size="1"><option>-</option>' . putOptions('select idPos, posName from [pos] order by posName', '') . "</select>';\n" . "tdPos.innerHTML=objSelect;\n" . "document.getElementsByName('idPos')[0].value=valPos;\n" . "var tdPos=document.getElementsByName('level')[0].parentNode;\n" . "var valPos=document.getElementsByName('level')[0].value;\n" . 'var objSelect=\'<select class="jss-FieldAuto" name="level" size="1"><option>-</option>' . putOptions('select value, level from [levels] order by level', '') . "</select>';\n" . "tdPos.innerHTML=objSelect;\n" . "document.getElementsByName('level')[0].value=valPos;\n"; } else { $goTo = "tableSearch.php"; } require "../tables/" . $goTo;
:</td> <td style="text-align: center; width: 1%;"> </td> </tr> <tr> <td style="text-align: left"> <select id="serie" class="jss-FieldAuto" name="serie" size="1"> <option>-</option> <?php echo putOptions("select serie from [invoiceSeries] order by serie", $serie); ?> </select> </td> <td style="text-align: left"> <select id="idPayType" class="jss-FieldAuto" name="idPayType" size="1"> <option>-</option> <?php echo putOptions("select idPayType, payType from [payTypes] order by payType", $idPayType); ?> </select></td> <td style="text-align: left"> <input id="from" class="jss-DatePicker" maxlength="12" name="from" size="12" style="width: 100%" value="<?php echo $from; ?> "></td> <td> <input id="to" class="jss-DatePicker" maxlength="12" name="to" size="12" style="width: 100%" value="<?php echo $to; ?> "></td> <td colspan="2"> <input id="valorBuscar" class="jss-FieldAuto" name="valorBuscar" size="45" value="<?php echo $valorBuscar;
while ($gv = $results->fetch()) { ?> <form action="prices.php" class="NoMargenes" method="POST" name="<?php echo 'frmPrices' . $nr; ?> "> <tr> <td style="height: 25px"> <input class="jss-FieldAuto" name="idBy" size="5" style="text-align: right" value="<?php echo $gv["idBy"]; ?> "></td> <td style="height: 25px"><select class="jss-FieldAuto" name="idRate" size="1"> <option>-</option> <?php echo putOptions("select idRate, rate from [rates] order by rate", $gv["idRate"]); ?> </select></td> <td style="height: 25px"> <input onblur="javascript: setPrice(this, this.form);" class="jss-FieldNum" name="price" id="price" size="12" value="<?php echo number_format($gv["price"], 3); ?> "></td> <td style="height: 25px" > <input class="jss-FieldNum" style="text-align: center" size="3" name="vatValue" id="vatValue" value="<?php echo $gv["vatValue"]; ?> "></td> <td style="height: 25px"> <input onblur="javascript: setPrice(this, this.form);" class="jss-FieldNum" name="vatPrice" id="vatPrice" size="12" value="<?php echo number_format($gv["vatPrice"], 3);
</select></td> </tr> <tr> <td style="text-align: right">Show Images:</td> <td> <input name="showImages" type="checkbox" value="1" class="jss-Check" ></td> <td style="text-align: right"> Show change:</td> <td> <input name="showChange" type="checkbox" value="1" class="jss-Check" ></td> <td style="text-align: right">Default printer:</td> <td> <select class="jss-FieldAuto" name="idPrint" size="1"> <option>-</option> <?php echo putOptions("select idPrint, name from [printers] order by name", ""); ?> </select></td> </tr> <tr> <td colspan="6" style="text-align: center"> <input class="jss-Boton" name="save" type="submit" value="<?php echo _SAVE; ?> "></td> </tr> </table><input name="idHome" type="hidden" value=""> </form> </td> </tr>
"></td> <td style="text-align: center; width: 20%; height: 1%;"> <input class="jss-Boton" name="delete" onclick="javascript: deleteRecord()" type="button" value="<?php echo _DELETE; ?> "></td> <td style="text-align: center; width: 20%; height: 1%;"> <input class="jss-Boton" name="print" onclick="javascript: fPrint()" type="button" value="<?php echo _PRINT; ?> "></td> <td style="text-align: center; width: 20%; height: 1%;"> <select id="idModel" class="jss-FieldAuto" name="D1" size="1"> <option>-</option> <?php echo putOptions("select idModel, title from [docsModel] where type!='Invoice' order by title", ""); ?> </select></td> </tr> </table> <input name="id" type="hidden" value="<?php echo $_SESSION[$keyMaster]; ?> "> </form> </td> <td style="width: 25%; vertical-align: top;"> <form id="fLogo" class="jss-NoMargins" enctype="multipart/form-data" method="post" name="fLogo" style="width: 100%; height: 100%;"> <table class="jss-TableBorder" style="width: 100%; height: 100%;" id="frameImage"> <tr> <td style="text-align: center;" colspan="2">
?> :</td> <td><select class="jss-FieldAuto" name="idVat" size="1"> <option>-</option> <?php echo putOptions("select idVat, cast(vatValue as text) || '% ' || vat as vat from [vatTypes] order by vat", ''); ?> </select></td> <td style="text-align: right"><?php echo _FAMILY; ?> :</td> <td><select class="jss-FieldAuto" name="idFamily" size="1"> <option>-</option> <?php echo putOptions("select idFamily, Family from [Familys] order by Family", ''); ?> </select></td> </tr> <tr> <td style="text-align: right; height: 50%" colspan="4" > </td> </tr> <tr> <td colspan="4" style="height: 1%"> <table style="width: 100%"> <tr> <td style="text-align: center"> <input class="jss-Boton" name="save" type="submit" value="<?php echo _SAVE; ?> "></td>
<img alt="" onclick="javascript: pickClient();" src="../../images/list16.gif" style="width: 16px; height: 16px"></td> <td colspan="4"> <input id="client" class="jss-FieldAuto" maxlength="100" name="client" onclick="javascript: pickClient();" size="100" value="<?php echo $client; ?> "></td> <td colspan="1"> <select id="idRate" class="jss-FieldAuto" name="idRate" onchange="javascript: currentRate=this.value; putProducts(currentFamily, currentBgColor);" size="1"> <?php echo putOptions("select idRate, Rate from [Rates] order by idRate", $defaults["idRate"]); ?> </select></td> <td> <select id="idPayType" class="jss-FieldAuto" name="idPayType" size="1"> <?php echo putOptions("select idPayType, payType from [payTypes] order by idPayType", ""); ?> </select></td> </tr> </table> </td> </tr> </table> </td> </tr> <tr> <td style="vertical-align: top; width: 50%;"> <table id="tInferior" class="jss-TableBorder" style="width: 100%; height: 100%;"> <tr class="jss-Bar"> <td ><?php echo _FAMILYS;
" style="width: 1%"> <img alt="" src="../../images/excel16.jpg" style="border-width: 0px; width: 16px; height: 16px"></a></td> </tr> <tr> <td style="text-align: left"> <select id="serie" class="jss-FieldAuto" name="serie" size="1"> <option>-</option> <?php echo putOptions("select serie from [invoiceSeries] order by serie", $serie); ?> </select> </td> <td> <select id="payType" class="jss-FieldAuto" name="payType" size="1"> <option>-</option> <?php echo putOptions("select payType from [payTypes] order by payType", $payType); ?> </select></td> <td> <input id="from" class="jss-DatePicker" maxlength="10" name="from" size="12" style="width: 100%" value="<?php echo $from; ?> "></td> <td> <input id="to" class="jss-DatePicker" maxlength="10" name="to" size="12" style="width: 100%" value="<?php echo $to; ?> "></td> <td> <input id="valorBuscar" class="jss-FieldAuto" name="valorBuscar" size="45" value="<?php echo $valorBuscar;
?> </option> <option <?php echo $periodicity == 'YEARLY' ? 'selected' : ''; ?> value="YEARLY"> <?php echo _YEARLY; ?> </option> </select></td> <td style="text-align: left"> <select id="idRate" class="jss-FieldAuto" name="idRate" onclick="javascript: goSearch();" size="1"> <option>-</option> <?php echo putOptions("select idRate, rate from [rates] order by rate", $idRate); ?> </select></td> <td style="text-align: left"> <input id="from" class="jss-DatePicker" maxlength="12" name="from" size="12" style="width: 100%" value="<?php echo $from; ?> " ></td> <td> <input id="to" class="jss-DatePicker" maxlength="12" name="to" size="12" style="width: 100%" value="<?php echo $to; ?> "></td> </tr> </table></form> </td>