$fcol = $_GET["octaorderby"] ? " order by " . $_GET["octaorderby"] . "_xorder " . ($_GET["octaorder"] ? $_GET["octaorder"] : "asc") : "";
$cols .= ($cols ? "," : "") . $_GET["octaorderby"] . " as " . $_GET["octaorderby"] . "_xorder";
}
$i = 1;
$tables_join = "";
$tables = "tb" . $sttdatato . ",";
while (isset($_GET["rfield" . $i])) {
if ($_GET["rfield" . $i]) {
if (!isset($_GET["rsubfield" . $i])) {
$xt = colTable($_GET["rfield" . $i], $sttdatato);
if ($xt) {
$type[$_GET["rfield" . $i]] = $xt['type'];
$cols .= ($cols ? "," : "") . $xt['query'];
}
} else {
$xt2 = colTable($_GET["rfield" . $i], $_GET["rsubfield" . $i]);
if ($xt2) {
if (!strstr($tables, "tb" . $_GET["rsubfield" . $i])) {
$tables .= "tb" . $_GET["rsubfield" . $i] . ",";
$cols .= ($cols ? "," : "") . $xt2['query'];
$tables_join .= " left outer join tb" . $_GET["rsubfield" . $i] . " on tb" . $_GET["rsubfield" . $i] . "." . $_GET["rsubcampofield" . $i] . "=tb" . $sttdatato . "." . $_GET["rsubidfield" . $i];
}
//$cols.=($cols?",":"")."(select top(1) ".$xt2['query']." from tb".$_GET["rsubfield".$i]." where tb".$_GET["rsubfield".$i].".".$_GET["rsubcampofield".$i]."=tb".$sttdatato.".".$_GET["rsubidfield".$i].") as ".$_GET["rfield".$i];
}
}
}
$i++;
}
//
//
// $sql=mssql_query("SELECT COLUMN_NAME,DATA_TYPE FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME='tb".$sttdatato."'");
$adds["codigo_prv"] = $row["CODIGO_AUX"];
$adds["AUXILIAR_PRV"] = $row["CODIGO_AUX"];
} else {
if ($sql = mssql_query("insert into tbauxiliares (NOMBRE_AUX,RIF_AUX) values ('" . $_POST["nombre_prv"] . "','" . $_POST["rif_prv"] . "')")) {
$sql = mssql_query("select * from tbauxiliares where RIF_AUX like '" . $_POST["rif_prv"] . "'");
$row = mssql_fetch_array($sql);
$adds["codigo_prv"] = $row["CODIGO_AUX"];
$adds["AUXILIAR_PRV"] = $row["CODIGO_AUX"];
} else {
roolback();
die("<b><span style='color:red'>Debe indicar nombre y rif.</span></b>");
}
}
}
}
if (colTable('USUARIO', $datato)) {
$adds["USUARIO"] = $_SESSION['octa-lite-user']['LOGIN'];
}
$con = "";
$conc = "";
$sql = mssql_query("SELECT COLUMN_NAME,DATA_TYPE,(select COUNT(*) FROM SYS.IDENTITY_COLUMNS WHERE NAME=COLUMN_NAME AND OBJECT_NAME(OBJECT_ID) = TABLE_NAME) AUTO FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME='tb" . $datato . "'");
while ($row = mssql_fetch_array($sql)) {
if (isset($adds[$row[0]])) {
///si existe en algun auxiliar
$conc .= ($conc ? "," : "") . $row[0];
if ($row[1] == "smalldatetime" || $row[1] == "datetime") {
$con .= ($con ? "," : "") . "'" . toDate($adds[$row[0]]) . "'";
} elseif ($row[1] == "float" || $row[1] == "numeric") {
$con .= ($con ? "," : "") . "cast('" . str_replace(",", ".", $adds[$row[0]]) . "' as float)";
} else {
$con .= ($con ? "," : "") . "'" . stripslashes(utf8_decode($adds[$row[0]])) . "'";
$serialData[$val] = "'0'";
$datos .= ($datos ? "," : "") . "'0'";
} elseif ($sttdatato == "expedientes3" && $val == "FECHA_EXP") {
$serialData[$val] = "GETDATE()";
$datos .= ($datos ? "," : "") . "NULL";
} elseif ($sttdatato == "expedientes5" && $val == "TODAY") {
$serialData[$val] = "GETDATE()";
$datos .= ($datos ? "," : "") . "NULL";
} elseif ($sttdatato == "expedientes3" && $val == "USUARIO_EXP") {
$serialData[$val] = "'" . $_SESSION["xenx-lite-user"]["LOGIN"] . "'";
$datos .= ($datos ? "," : "") . "'" . $_SESSION["xenx-lite-user"]["LOGIN"] . "'";
} elseif ($sttdatato == "clientes2" && ($val == "PRECIO_CLI" || $val == "COSTO_CLI") || $sttdatato == "proveedores3" && $val == "COSTO_PRV") {
$serialData[$val] = "'" . str_replace(",", ".", $_POST["val" . $ix . "_" . $ix2]) * 1 . "'";
$datos .= ($datos ? "," : "") . "'" . str_replace(",", ".", $_POST["val" . $ix . "_" . $ix2]) * 1 . "'";
} else {
$dataT = colTable($val, $sttdatato);
switch (trim($dataT['type'])) {
case "numeric":
$serialData[$val] = str_replace(",", ".", $_POST["val" . $ix . "_" . $ix2]) * 1;
$datos .= ($datos ? "," : "") . str_replace(",", ".", $_POST["val" . $ix . "_" . $ix2]) * 1;
break;
case "decimal":
$serialData[$val] = str_replace(",", ".", $_POST["val" . $ix . "_" . $ix2]) * 1;
$datos .= ($datos ? "," : "") . str_replace(",", ".", $_POST["val" . $ix . "_" . $ix2]) * 1;
break;
default:
$serialData[$val] = "'" . $_POST["val" . $ix . "_" . $ix2] . "'";
$datos .= ($datos ? "," : "") . "'" . $_POST["val" . $ix . "_" . $ix2] . "'";
}
}
}
$ix2 = $i2 == 0 ? "" : $i2;
}
//putxt("update tb$sttdatato set $datos where $we");
if (mssql_query("update tb{$sttdatato} set {$datos} where {$iwe}")) {
$idu++;
}
$i++;
$ix = $i == 0 ? "" : $i;
}
//////
} elseif ($search) {
switch ($search) {
case "buscar_productos_facturacion":
$colsx = explode(",", $cols);
foreach ($colsx as $col) {
$v = colTable($col, "productos");
if ($v) {
$c .= ($c ? "," : "") . $v['query'];
$ct[] = $v['type'];
} else {
switch ($col) {
case "iva_pro":
$c .= ($c ? "," : "") . "(select TASA_IMP from tbimpuestos where CODIGO_IMP=CODIGOIVA_PRO) as " . $col;
$ct[] = "float";
break;
default:
$c .= ($c ? "," : "") . "'' as " . $col;
$ct[] = "vnarchar";
}
}
}
