<?php
$ADODB_COUNTRECS = true;
$isql = "select depe_codi,depe_nomb from DEPENDENCIA ORDER BY DEPE_NOMB";
$rs = $db->query($isql);
$ADODB_COUNTRECS = false;
$numerot = $rs->RecordCount();
?>
<span class='etitulos'><b>
<select name='enviara' id='enviara' class='select' language='javascript' onchange=changedepesel()>
<option value=7>Borrar Documento informado</option>
<option value=8>Informar (Enviar copia de documentos)</option>
</select><br>
<select name='depsel8[]' id='depsel8' class='select' multiple size="5">
<?php
include "{$ruta_raiz}/include/query/queryCuerpoinf.php";
$a = new combo($db);
$concatSQL = $db->conn->Concat($concatenar, "' '", "depe_nomb");
$s = "SELECT DEPE_CODI, {$concatSQL} as NOMBRE from dependencia order by depe_nomb asc ";
$r = "DEPE_CODI";
$t = "NOMBRE";
$v = $dependencia;
$sim = 0;
$a->conectar($s, $r, $t, $v, $sim, $sim);
?>
</select>
<BR>
<input type=button value="REALIZAR" name=Enviar valign="middle" class="botones" onClick="enviar();">
<input type=hidden name=codTx>
</td>
</tr>
<tr>
<tr>
<td class='etextomenu' >
<p>(Ultimo numero de documento Generado: <b><font color="#008040"><?php
echo $numeroActualSecuencia;
?>
</font></b>)</p>
</td>
</tr>
<td class='timpar'>
<p><font size="1">
<?php
$q2 = "select * from sgd_argd_argdoc where sgd_pnufe_codi={$tipoPaquete} ";
$rs2 = $db->query($q2);
$a = new combo($db);
$argumentosActuales = "";
//print($q2);
while ($rs2 && !$rs2->EOF) {
$codigoargumento = $rs2->fields['SGD_ARGD_CODI'];
$tabla = $rs2->fields['SGD_ARGD_TABLA'];
$campoLlave = $rs2->fields['SGD_ARGD_TCODI'];
$campoDescripcin = $rs2->fields['SGD_ARGD_TDES'];
$labelLista = $rs2->fields['SGD_ARGD_LLIST'];
$argumentosActuales = $argumentosActuales . "[" . $codigoargumento . "]";
?>
<BR>
<select <?php
echo "NAME=argumento[{$codigoargumento}]";
?>
class="ecajasfecha" >
session_start();
$ruta_raiz = "..";
include $ruta_raiz . '/config.php';
// incluir configuracion.
define('ADODB_ASSOC_CASE', 1);
include_once "{$ruta_raiz}/include/db/ConnectionHandler.php";
$db = new ConnectionHandler("{$ruta_raiz}");
if ($db) {
//$db->conn->debug=true;
!$expNum ? $expNum = $_GET['expNUM'] ? $_GET['expNUM'] : $_POST['expNUM'] : 0;
if ($expNum && substr(base64_decode($expNum), -1) === '%') {
$expNum = substr(base64_decode($expNum), 0, strlen(base64_decode($expNum)) - 1);
include "{$ruta_raiz}/include/tx/Expediente.php";
include "{$ruta_raiz}/include/combos.php";
include "{$ruta_raiz}/include/tx/Historico.php";
$cmb = new combo();
$expediente = new Expediente($db);
$objHist = new Historico($db);
if (isset($_POST['btn_accion'])) {
//$db->conn->debug=true;
switch ($_POST['btn_accion']) {
case 'Crear':
$idCarpeta = $db->conn->GenID('SEC_IDCARPETA');
$cscCarpeta = $expediente->getSecCarpeta($expNum) + 1;
$_POST['txtNFolios'] ? $nfolios = $_POST['txtNFolios'] : ($nfolios = 'null');
$sql = "insert into sgd_carpeta_expediente(sgd_carpeta_id, sgd_carpeta_csc, sgd_carpeta_descripcion, sgd_carpeta_numero, sgd_exp_numero , sgd_carpeta_nfolios)";
$sql .= "values ({$idCarpeta},{$cscCarpeta},'" . $_POST['txtDescip'] . "'," . $_POST['txtNCarpeta'] . ", '{$expNum}', {$nfolios})";
$db->conn->Execute($sql) ? $error = 1 : ($error = 2);
if ($error == 1) {
$radicados[] = "NULL";
$objHist->insertarHistoricoExp($expNum, $radicados, $_SESSION['dependencia'], $_SESSION['codusuario'], "Se agrega Carpeta No." . $_POST['txtNCarpeta'], 61, '0');
$selectDep = "<select name='selDepPriv[]' id='selDepPriv' size='3' class='select' multiple onChange=\"verUsuarios('{$numExpediente}','3','cDependencias');\" >";
while (!$rs->EOF) {
if ($selDepPriv) {
in_array($rs->fields['DEPE_CODI'], $selDepPriv) ? $estDep = 'selected' : ($estDep = '');
}
$selectDep .= "<option value=" . $rs->fields['DEPE_CODI'] . " {$estDep} >" . $rs->fields['NOMBRE'] . "</option>";
$rs->MoveNext();
}
$selectDep .= "</select>";
}
if (!$fechaExp) {
$fechaExp = date("Y-m-d");
}
$objDep->Dependencia_codigo($dependencia);
$descDep = $objDep->depe_nomb;
$objCombo = new combo();
?>
<html>
<head>
<title>Crear Expediente</title>
<link href="../estilos/orfeo.css" rel="stylesheet" type="text/css">
<link rel="stylesheet" type="text/css" href="../js/spiffyCal/spiffyCal_v2_1.css">
<script language="JavaScript" src="../js/spiffyCal/spiffyCal_v2_1.js"></script>
<script language="javascript" src="../js/funciones.js"></script>
<script language="javascript" src="<?php
echo $ruta_raiz;
?>
/js/ajax.js"></script>
<script>
var dateAvailable1 = new ctlSpiffyCalendarBox("dateAvailable1", "TipoDocu", "fechaExp","btnDate1","<?php
echo $fechaExp;
