Sorry for bump back this old topic, but I'm facing same problem. I think my script code is wrong
Code: |
$oc = "";
switch ($_SESSION['rol']) {
//operario
case 'OPERADOR':
$estado = array(1,3,7,8);
$filtro = "id IN (1,3,7,8)";
break;
//supervisor
case 'SUPERVISOR':
$estado = array(1 => 'CREADO',
2 => 'APROBADO',
3 => 'RECHAZADO',
4 => 'CANCELADO',
5 => 'EN ESPERA',
7 => 'RECIBIDO PARCIAL',
8 => 'TERMINADO');
$filtro = "id IN (1,2,3,4,5,7,8)";
break;
//compras
case 'ADMINISTRATIVO':
$estado = array(1 => 'CREADO',
3 => 'RECHAZADO',
4 => 'CANCELADO',
5 => 'EN ESPERA',
6 => 'AUTORIZADO (OC)',
7 => 'RECIBIDO PARCIAL',
8 => 'TERMINADO');
$filtro = "id IN (1,3,4,5,6,7,8)";
$oc = "VA";
break;
//admin
case 'ADMINISTRADOR':
$estado = array(1 => 'CREADO',
2 => 'APROBADO',
3 => 'RECHAZADO',
4 => 'CANCELADO',
5 => 'EN ESPERA',
6 => 'AUTORIZADO (OC)',
7 => 'RECIBIDO PARCIAL',
8 => 'TERMINADO');
$filtro = "id IN (1,2,3,4,5,6,7,8)";
$oc = "VA";
break;
default:
$estado = array(1 => 'CREADO',
3 => 'RECHAZADO',
7 => 'RECIBIDO PARCIAL',
8 => 'TERMINADO');
break;
}
$unidades = array(
'1' => 'Unidades',
'2' => 'Kilogramos',
'3' => 'gramos',
'4' => 'Litros',
'5' => 'miliLitros',
'6' => 'centimetros',
'7' => 'metros');
$opts['hn'] = 'localhost';
$opts['un'] = 'something';
$opts['pw'] = 'anotherthing';
$opts['db'] = 'entregas';
$opts['tb'] = 'rc_pedido';
$opts['key'] = 'id';
$opts['key_type'] = 'int';
$opts['sort_field'] = array('-id');
$opts['inc'] = 15;
$opts['options'] = 'ACVF';
$opts['multiple'] = '4';
$opts['navigation'] = 'DG';
$opts['buttons']['V']['up'] = array('cancel');
$opts['buttons']['V']['down'] = $opts['buttons']['V']['up'];
$opts['buttons']['L']['up'] = array('<<','<','add','change','>','>>','goto','goto_combo');
$opts['buttons']['L']['down'] = $opts['buttons']['L']['up'];
$opts['display'] = array(
'form' => true,
'query' => false,
'sort' => false,
'time' => false,
'tabs' => false,
'num_pages' => false,
'num_records' => false
);
$opts['js']['prefix'] = 'PME_js_';
$opts['dhtml']['prefix'] = 'PME_dhtml_';
$opts['cgi']['prefix']['operation'] = 'PME_op_';
$opts['cgi']['prefix']['sys'] = 'PME_sys_';
$opts['cgi']['prefix']['data'] = 'PME_data_';
$opts['language'] = 'ES-AR-utf8';
$opts['fdd']['id'] = array(
'name|L' => 'Numero:',
'name' => 'Requerimiento de Compra',
'select' => 'T',
'options' => 'VPCDRL',
'input' => 'R',
'maxlen' => '6' ,
'size' => '6',
// 'default' => '0',
'sort' => true,
'width' => '25px'
);
$opts['fdd']['status_oc'] = array(
'name' => 'Estado',
'select' => 'T',
// 'options' => 'AL',
'maxlen' => 11,
'sort' => true,
'required' => true,
'default' => 1,
'nowrap' => true,
);
$opts['fdd']['status_oc']['values']['table'] = 'rc_estado';
$opts['fdd']['status_oc']['values']['column'] = 'id';
$opts['fdd']['status_oc']['values']['description'] = 'estado';
$opts['fdd']['status_oc']['values']['filters'] = $filtro;
$opts['fdd']['OC'] = array(
'name' => 'OC SAP',
'select' => 'N',
'sort' => true,
'required' => true,
'options' => $oc,
);
$opts['fdd']['articulo'] = array(
'name' => 'Articulo',
'select' => 'T',
'maxlen' => '60',
'sort' => true,
'required' => true,
);
$opts['fdd']['articulo']['textarea']['rows'] = '2';
$opts['fdd']['articulo']['textarea']['cols'] = '40';
$opts['fdd']['cantidad'] = array(
'name' => 'Cantidad',
'select' => 'N',
'maxlen' => '11',
'size' => '6',
'sort' => true,
'required' => true,
'number_format' => array(2,",","."),
);
$opts['fdd']['cantidad']['js']['regexp'] = '/^[0-9]*$/';
$opts['fdd']['cantidad']['js']['hint'] = 'Debe ingresar un numero en Cantidad';
$opts['fdd']['unidad_med'] = array(
'name|L' => 'U.M.',
'name' => 'Unidad de Medida',
'select' => 'D',
'maxlen' => '11',
'sort' => true,
'values2' => $unidades,
);
$opts['fdd']['fecha_crea'] = array(
'name' => 'Creado:',
'select' => 'T',
'datemask' => 'Y-m-d',
'key_type' => 'date',
'maxlen' => '15',
'size' => '6',
'sort' => true,
'default' => date('Y-m-d H:i:s')
);
$opts['fdd']['sector_ori'] = array(
'name' => 'Solicita:',
'select' => 'N',
'maxlen' => '15',
'size' => '6',
'sort' => true,
'options' => 'VA',
);
$opts['fdd']['sector_ori']['values']['table'] = 'rc_sectores';
$opts['fdd']['sector_ori']['values']['column'] = 'codigo';
$opts['fdd']['sector_ori']['values']['description'] = 'sector';
$opts['fdd']['sector_dest'] = array(
'name' => 'Destino:',
'select' => 'N',
'maxlen' => '15',
'size' => '6',
'sort' => true,
);
$opts['fdd']['sector_dest']['values']['table'] = 'rc_sectores';
$opts['fdd']['sector_dest']['values']['column'] = 'codigo';
$opts['fdd']['sector_dest']['values']['description'] = 'sector';
$opts['fdd']['legajo_crea'] = array(
'name' => 'Creado Por:',
'select' => 'T',
'maxlen' => '11',
'size' => '10',
'sort' => true,
// 'default' => $_SESSION['legajo'],
'options' => 'V'
);
$opts['fdd']['legajo_crea']['values']['db']= 'entregas'; // optional
$opts['fdd']['legajo_crea']['values']['table'] = 'dbo_leg';
$opts['fdd']['legajo_crea']['values']['column'] = 'leg_numero';
$opts['fdd']['legajo_crea']['values']['description']['columns'][0] = 'leg_apellido';
$opts['fdd']['legajo_crea']['values']['description']['divs'][0] = ' ';
$opts['fdd']['legajo_crea']['values']['description']['columns'][1] = 'leg_nombre';
$opts['fdd']['legajo_crea']['values']['orderby'] = 'leg_apellido'; // optional ORDER BY clause
$opts['fdd']['legajo_crea']['values']['filters'] = 'leg_numero ="'.$_SESSION['legajo'].'"';
$opts['fdd']['fecha_mod'] = array(
'name' => 'Modificado:',
'select' => 'T',
'maxlen' => '10',
'sort' => true,
'datemask' => 'dMY',
'key_type' => 'date',
'options' => 'V'
);
$opts['fdd']['legajo_mod'] = array(
'name' => 'Modificado Por:',
'select' => 'T',
'maxlen' => '11',
'default|A' => $_SESSION['legajo'],
'sort' => true,
'options' => 'AV'
);
$opts['fdd']['legajo_mod']['values']['db']= 'entregas'; // optional
$opts['fdd']['legajo_mod']['values']['table'] = 'dbo_leg';
$opts['fdd']['legajo_mod']['values']['column'] = 'leg_numero';
$opts['fdd']['legajo_mod']['values']['description']['columns'][0] = 'leg_apellido';
$opts['fdd']['legajo_mod']['values']['description']['divs'][0] = ' ';
$opts['fdd']['legajo_mod']['values']['description']['columns'][1] = 'leg_nombre';
$opts['fdd']['legajo_mod']['values']['orderby'] = 'leg_apellido'; // optional ORDER BY clause
$opts['fdd']['legajo_mod']['values']['filters'] = 'leg_numero ="'.$_SESSION['legajo'].'"';
$opts['fdd']['observaciones'] = array(
'name' => 'Observaciones',
'select' => 'T',
'maxlen' => '100',
'sort' => true,
'options' => 'AV'
);
$opts['fdd']['observaciones']['textarea']['rows'] = 4;
$opts['fdd']['observaciones']['textarea']['cols'] = 40;
// Now important call to phpMyEdit
require_once '../extensions/phpMyEdit-mce-cal.class.php';
new phpMyEdit($opts);
|
Any sugestions?
|