</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>
