public function viewEvents($id)
{
$data = DB::Select(' select * from c_req_cars where req_car_id=' . $id . ' ');
foreach ($data as $k) {
$t = '<h3>เรื่อง ' . $k->detail . '</h3>';
$t .= '<ul class="uk-list uk-list-striped">';
$t .= '<li>วันที่บันทึก(ว-ด-ป) : ' . date("d-m", strtotime($k->regis_date)) . '-' . (date("Y", strtotime($k->regis_date)) + 543) . ' เวลาบันทึก : ' . date("H:i:s", strtotime($k->regis_date)) . '</li>';
$t .= '<li>ชื่อผู้ขอ : ' . $k->req_name . '</li>';
$t .= '<li>ตำแหน่ง : ' . $k->position . '</li>';
$t .= '<li>ฝ่าย : ' . $k->department . '</li>';
$t .= '<li class="uk-text-danger" >ไปที่ : ' . $k->location . '</li>';
$t .= '<li class="uk-text-danger" >รายละเอียด : ' . $k->detail . '</li>';
$t .= '<li class="uk-text-danger" >ไปวันที่(ว-ด-ป) : ' . date("d-m", strtotime($k->godate)) . '-' . (date("Y", strtotime($k->godate)) + 543) . '</li>';
$t .= '<li class="uk-text-danger" >ไปเวลา : ' . $k->gotime_start . '</li>';
$t .= '<li class="uk-text-danger" >เลขทะเบียนรถ : ' . $k->car_number . '</li>';
$t .= '<li>ผู้ขับ : ' . $k->driver . '</li>';
if (count($this->chk_subwork($k->req_car_id)) > 0) {
foreach ($this->chk_subwork($k->req_car_id) as $c) {
$t .= '<li class="uk-text-primary" ><mark>ไปกับฝ่าย : ' . $c->department . '</mark></li>';
}
}
$t .= '</ul>';
}
return $t;
}
function ConsultarPermisosCRM($idDoc)
{
// -------------------------------------------
// O P C I O N E S D E C R M S E G U N E L R O L
// D E L U S U A R I O Y L A C O M P A N I A
// -------------------------------------------
$permiso = DB::Select('
SELECT
nombreRol,
adicionarDocumentoCRMRol,
modificarDocumentoCRMRol,
anularDocumentoCRMRol,
consultarDocumentoCRMRol,
aprobarDocumentoCRMRol
From
documentocrm
Inner Join documentocrmcompania
On documentocrmcompania.DocumentoCRM_idDocumentoCRM =
documentocrm.idDocumentoCRM
Inner Join documentocrmrol
On documentocrmrol.DocumentoCRM_idDocumentoCRM = documentocrm.idDocumentoCRM
Inner Join rol
On documentocrmrol.Rol_idRol = rol.idRol
Inner Join users
On users.Rol_idRol = rol.idRol
Where
users.id = ' . \Session::get("idUsuario") . ' And
documentocrmcompania.Compania_idCompania = ' . \Session::get("idCompania") . ' AND idDocumentoCRM = "' . $idDoc . '"');
return $permiso;
}
public function getAddLivrabilEtapa($id_etapa)
{
$stadii = self::getStadiiLivrabil();
$livrabile = DB::Select("SELECT \n tl.id, \n tl.denumire \n FROM etape_predare_livrabile epl\n INNER JOIN obiectiv obj ON obj.id = epl.id_obiectiv AND obj.logical_delete = 0\n INNER JOIN template_contract_tipizat_master tctm ON tctm.id = obj.id_template AND tctm.logical_delete = 0\n INNER JOIN template_contract_tipizat_detail tctd ON tctd.id_template_contract_tipizat_master = tctm.id AND tctd.logical_delete = 0\n INNER JOIN tip_livrabile tl ON tl.id = tctd.id_tip_livrabil AND tl.logical_delete = 0\n WHERE epl.id_etapa = :id_etapa", array('id_etapa' => $id_etapa));
//Debugbar::info("ETP=" . $id_etapa);
return View::make('livrabile_etapa.add')->with('stadii', $stadii)->with('livrabile', self::object_to_array($livrabile))->with('id_etapa', $id_etapa);
}
public function GetIDS($Keywords, $Property)
{
if (!$Keywords) {
return false;
}
if (is_array($Keywords)) {
foreach ($Keywords as $string) {
$sql_ext .= ($sql_ext ? ' or ' : '') . 'Keywords=\'' . $string . '\'';
}
} else {
$sql_ext = 'Keywords=\'' . $Keywords . '\'';
}
$sql = 'SELECT ' . $Property . ' FROM tbl_keywords WHERE ' . $sql_ext;
$DB = new DB();
$RS = $DB->Select($sql);
if ($RS) {
$tmpIDS = '';
foreach ($RS as $list) {
if ($list[$Property]) {
$tmpIDS .= ($tmpIDS ? ',' : '') . $list[$Property];
}
}
$tmpIDS = preg_replace('/(,{2,})/', ',', $tmpIDS);
if (substr($tmpIDS, 0, 1) == ',') {
$tmpIDS = substr($tmpIDS, 1);
}
if (substr($tmpIDS, -1) == ',') {
$tmpIDS = substr($tmpIDS, 0, -1);
}
$IDS = explode(',', $tmpIDS);
return implode(',', array_unique($IDS));
}
return false;
}
function ConsultarPermisos($vista)
{
$permiso = DB::Select('
SELECT
nombreOpcion,
nombreRol,
adicionarRolOpcion,
modificarRolOpcion,
eliminarRolOpcion,
consultarRolOpcion,
rutaOpcion
FROM
rol AS r
LEFT JOIN
rolopcion AS ro ON ro.Rol_idRol = r.idRol
LEFT JOIN
users AS u ON u.Rol_idRol = r.idRol
LEFT JOIN
opcion AS o ON ro.Opcion_idOpcion = o.idOpcion
LEFT JOIN
paquete AS p ON o.Paquete_idPaquete = p.idPaquete
WHERE
Compania_idCompania = ' . \Session::get("idCompania") . ' AND id = ' . \Session::get("idUsuario") . ' AND rutaOpcion = "' . $vista . '"');
return $permiso;
}
public function Lists($UserID, $Page = 1, $PageSize = 10)
{
$DB = new DB();
$Page = max(1, $Page);
$Offset = ($Page - 1) * $PageSize;
$Sql = 'SELECT PictureID, Path, Title, Keywords,UserID, IsPublic FROM tbl_pictures where UserID=' . $UserID . ' OR IsPublic=1 ORDER BY PictureID DESC';
return $DB->Select($Sql, $Offset, $PageSize);
}
public function getDetaliiFactura($id_factura)
{
$total_defasurator = DB::select("SELECT\n SUM(pret_fara_tva) AS valoare\n FROM livrabile_etapa\n WHERE logical_delete = 0\n AND id_factura = :id_factura", array('id_factura' => $id_factura));
$detalii = DB::Select("SELECT\n df.id_det_fact,\n df.nr_ordine,\n df.denumire AS denumire_produs,\n df.cantitate,\n um.denumire AS um,\n df.pret_unitar \n FROM detalii_factura df\n LEFT OUTER JOIN um ON um.id = df.id_um AND um.logical_delete = 0 \n WHERE df.logical_delete = 0\n AND df.id_factura = :id_factura", array('id_factura' => $id_factura));
$factura = self::getFacturaClient($id_factura);
$ums = self::object_to_array(self::getUM());
return View::make('facturi_client.list_detalii')->with('factura', $factura)->with('detalii', $detalii)->with('total_defasurator', $total_defasurator[0])->with('ums', $ums);
}
public function getAddObiectiv($id_contract = null)
{
$stadii_obiectiv = self::getStadiiObiectiv();
$ids = self::getIDsDepartamente(Confide::getDepartamenteUser());
$contracte = DB::Select("SELECT \n id, denumire \n FROM contract\n WHERE logical_delete = 0\n AND id_departament IN (" . $ids . ")");
$templates = DB::select("SELECT\n id, denumire\n FROM template_contract_tipizat_master\n WHERE logical_delete = 0\n ORDER BY id");
$id_tara = null;
$id_regiune = null;
$id_judet = null;
$contract = null;
if ($id_contract) {
$contract = DB::Select("SELECT\n id, id_tara, id_regiune, id_judet\n FROM contract \n WHERE id = :id_contract", array('id_contract' => $id_contract));
if (count($contract) == 1) {
$id_tara = $contract[0]->id_tara;
$id_regiune = $contract[0]->id_regiune;
$id_judet = $contract[0]->id_judet;
}
}
return View::make('obiective.add')->with('contracte', self::object_to_array($contracte))->with('templates', self::object_to_array($templates))->with('stadii_obiectiv', $stadii_obiectiv)->with('id_contract', $id_contract)->with('id_tara', $id_tara)->with('id_regiune', $id_regiune)->with('id_judet', $id_judet)->with('departamente', self::object_to_array(Confide::getDepartamenteUser()));
}
public function LinksManager($Page = 1, $PageSize = 20, $UserID = 0)
{
$DB = new DB();
if ($UserID) {
$SqlWhere = ' WHERE CreatedUserID=' . $UserID;
}
$Sql = 'SELECT COUNT(ID) AS RecordCount From tbl_links ' . $SqlWhere;
$rs = $DB->GetOne($Sql);
if (!$rs || !$rs['RecordCount']) {
return false;
}
$Data['RecordCount'] = $rs['RecordCount'];
$Data['PageCount'] = ceil($Data['RecordCount'] / $PageSize);
$Page = min(max(1, $Page), $Data['PageCount']);
$Offset = ($Page - 1) * $PageSize;
$Data['Page'] = $Page;
$Data['PageSize'] = $PageSize;
$Data['Data'] = $DB->Select('SELECT * FROM tbl_links ' . $SqlWhere . ' ORDER BY ID DESC', $Offset, $PageSize);
return $Data;
}
public function UpdateCache()
{
$DB = new DB();
$sql = 'SELECT * from tbl_variables';
$rs = $DB->Select($sql);
if ($rs) {
foreach ($rs as $list) {
if ($list['VariableType']) {
$list['Value'] = $this->StringToArray($list['VariableValue']);
} else {
$list['Value'] = $list['VariableValue'];
}
$Data[$list['VariableName']] = $list;
}
$source .= '$Data=' . var_export($Data, true) . ";\n";
$source = '<?php ' . "\n" . $source . "?>";
$result = false;
$filepath = DocumentRoot . '/Data/Config/Variables.cfg.php';
$f = @fopen($filepath, 'ab+');
if ($f) {
@flock($f, LOCK_EX);
fseek($f, 0);
ftruncate($f, 0);
$tmp = @fwrite($f, $source);
if (!($tmp === FALSE)) {
$result = true;
}
@fclose($f);
} else {
return false;
}
@chmod($filepath, 0777);
return $result;
}
return false;
}
public function getEditEtapa($id_etapa)
{
$etapa = DB::Select("SELECT \n epl.id_etapa,\n epl.termen_predare,\n epl.id_um_timp,\n epl.instiintare_contractor,\n epl.nr_etapa, \n epl.id_obiectiv,\n date_format(epl.data_start, '%d-%m-%Y') AS data_start \n FROM etape_predare_livrabile epl \n WHERE epl.logical_delete = 0\n AND epl.id_etapa = :id_etapa", array('id_etapa' => $id_etapa));
$ums_timp = self::getUMTimp();
return View::make('etape_termene.edit')->with('ums_timp', $ums_timp)->with('etapa', $etapa[0]);
}
public function support_ocsc_excel()
{
if (Session::get('level') != '') {
$y = DB::Select(' select year(order_date) as year1 from s_salary_ocsc_detail group by year(order_date) order by year(order_date) desc ');
return View::make('report.report7', array('data' => $y));
} else {
return View::make('login.index');
}
}
function Topics($offset = 0, $limit = 20, $AreaID = -1)
{
$DB = new DB();
if ($AreaID >= 0) {
if ($AreaID) {
$NextAreaID = GetNextAreaID($AreaID);
}
$sql_ext = 'AreaID=0';
if ($NextAreaID) {
$sql_ext .= ' OR (AreaID>=' . $AreaID . ' AND AreaID<' . $NextAreaID . ')';
}
if ($sql_ext) {
$sql_ext = 'WHERE ' . $sql_ext;
}
}
$sql = 'select * from tbl_topics ' . $sql_ext . ' ORDER BY TopicID DESC';
return $DB->Select($sql, $offset, $limit);
}
$this->Where($conditionData, " AND ");
return $this;
}
public function _Or($conditionData)
{
if (!($this->lastShackle == "Where")) {
return setError(3);
}
$this->Where($conditionData, " OR ");
return $this;
}
private function setError($msg)
{
$this->Error = $this->errorMsg[$msg];
return false;
}
private function isAssoc($arr)
{
return array_keys($arr) !== range(0, count($arr) - 1);
}
}
$DB = new DB();
//$a = $DB->Select("client")->SetData(array("id","name"))->Exec();
$data = array("name" => "Test", "lastname" => "Testing", "status" => 1);
$a = $DB->Select("client")->SetData(array("id", "CONCAT(name,' ',lastname) as nombre", "status"))->Exec();
//$a = $DB->Delete("client")->Where(["name","=","test"])->Exec();
if (!$a) {
echo "<p style='color:red'> {$DB->Error} </p>";
} else {
var_dump($a);
}
public function GetAll($MysqlWhere = '')
{
$DB = new DB();
return $DB->Select('select * from ' . $this->TableName . ' ' . $MysqlWhere . ' order by ' . $this->KeyID . ' DESC');
}
public function GetProjectLists($MysqlWhere = '', $From = 0, $Pagesize = 10)
{
$DB = new DB();
return $DB->Select('select * from ' . $this->TableName . ' ' . $MysqlWhere . ' order by ' . $this->KeyID . ' DESC limit ' . $From . ',' . $Pagesize);
}
/**
* function name : view_manager
* edit view_manager unitcode money
* get
*/
public function view_manager($y, $m, $u)
{
//----- sso ----//
if ($m == 1) {
$y_s = $y - 1;
$m_s = 12;
} else {
$y_s = $y;
$m_s = $m - 1;
}
//----- ot ----//
if ($m == 12) {
$y_t = $y + 1;
$m_t = 1;
} else {
$y_t = $y;
$m_t = $m + 1;
}
$sql = ' select s1.unitname, a.y, a.m, s1.cid, a.type, concat(n1.pname,"",n1.fname," ",n1.lname) as fullname, a.salary, a.r_c ';
$sql .= ' , a.ot, a.no_v, a.ch8, a.sp_other, a.son, a.u_travel, a.u_other ';
$sql .= ' from s_unit_costs_emp s1 ';
$sql .= ' left join ';
$sql .= ' ( ';
$sql .= ' ( select cid,year(order_date) as y, month(order_date) as m, 1 as type, sum(salary+salary_other) as salary, 0 as r_c, (select c.ot from s_salary_detail c where year(c.order_date)=' . $y_t . ' and month(c.order_date)=' . $m_t . ' and c.cid=s_salary_detail.cid) as ot, sum(no_v) as no_v, sum(ch8) as ch8, ((select b.salary_sso from s_salary_detail b where year(b.order_date)=' . $y_s . ' and month(b.order_date)=' . $m_s . ' and b.cid=s_salary_detail.cid)+pts) as sp_other, 0 as son, sum(u_travel) as u_travel, sum(u_other) as u_other from s_salary_detail where year(order_date)=' . $y . ' and month(order_date)=' . $m . ' group by cid ) ';
$sql .= ' union ';
$sql .= ' ( select cid,year(order_date) as y, month(order_date) as m, 2 as type, sum(salary+r_other+special_m) as salary, sum(r_c) as r_c, (select c.ot from s_salary_ocsc_detail c where year(c.order_date)=' . $y_t . ' and month(c.order_date)=' . $m_t . ' and c.cid=s_salary_ocsc_detail.cid) as ot, sum(no_v) as no_v, sum(ch8) as ch8, sum(save_h+p_other+pts) as sp_other, sum(r_pt+son) as son, sum(u_travel) as u_travel, sum(u_other) as u_other from s_salary_ocsc_detail where year(order_date)=' . $y . ' and month(order_date)=' . $m . ' group by cid ) ';
$sql .= ' ) as a ';
$sql .= ' on a.cid = s1.cid ';
$sql .= ' left join n_datageneral n1 on n1.cid=s1.cid ';
$sql .= ' where s1.unitname="' . $u . '" ';
//return $sql;
$data = DB::Select($sql);
return View::make('unitcosts.view_unitcosts_manager', array('data' => $data));
}
<?php
$idAccidente = $_GET['idAccidente'];
$consulta = DB::Select('SELECT nombreCompletoTercero, idAccidente from accidente a left join tercero t on a.Tercero_idEmpleado = t.idTercero where idAccidente = ' . $idAccidente);
$row = array();
foreach ($consulta as $key => $value) {
foreach ($value as $datoscampo => $campo) {
$row[$key][] = $campo;
}
}
$output['aaData'] = $row;
echo json_encode($output);
?>
/**
* function name : header_dep_create
* create header department
* get
*/
public function header_dep_create()
{
//get Department details
$dep_Name = Input::get('dep_Name');
$header_Name = Input::get('header_Name');
if ($dep_Name != '' && $header_Name != '') {
$cid = DB::table('n_datageneral')->where(DB::raw('CONCAT(pname,"",fname, " ", lname)'), '=', $header_Name)->first();
$header = DB::insert('insert into n_department_header (departmentName, cid, header_name) values (?, ?, ?)', array($dep_Name, $cid->cid, $header_Name));
$department = DB::table('n_department')->get(array(DB::raw('departmentName as value')));
foreach ($department as $k2 => $v2) {
$return_department[] = $v2;
}
$dataUser = DB::table('n_datageneral')->get(array(DB::raw('CONCAT(pname,"",fname, " ", lname) as value')));
foreach ($dataUser as $k2 => $v2) {
$return_dataUser[] = $v2;
}
$header_data = DB::Select('select * from n_department_header order by departmentName');
//view page create
return View::make('header_dep.home_header', array('departmentall' => $return_department, 'dataUser' => $return_dataUser, 'header_data' => $header_data));
} else {
return Redirect::to('admin/header_dep');
}
}
public function continuous_home4()
{
if (Session::get('level') != '') {
$y = DB::Select(' select year(order_date) as year1 from s_salary_detail group by year(order_date) order by year(order_date) desc ');
return View::make('tax.continuous_home4', array('data' => $y));
} else {
return View::make('login.index');
}
}
<?php
$idActa = $_GET['idActa'];
$consulta = DB::Select('SELECT nombreCompletoTercero, idActaCapacitacion, idActaCapacitacionAsistente from actacapacitacion ac left join actacapacitacionasistente aca on aca.ActaCapacitacion_idActaCapacitacion = ac.idActaCapacitacion left join tercero t on aca.Tercero_idAsistente = t.idTercero where idActaCapacitacion = ' . $idActa);
$row = array();
foreach ($consulta as $key => $value) {
foreach ($value as $datoscampo => $campo) {
$row[$key][] = $campo;
}
}
$output['aaData'] = $row;
echo json_encode($output);
?>
public static function getCampaignAppAction($campaignID, $edit = false)
{
$actions_content = '';
$c_id = Helpers::getUniqueCampaignID($campaignID);
$rs = DB::Select("SELECT campaignstatus,approvalstatus FROM tbl_campaigns WHERE id = ?", array($campaignID));
/*
* Edit and Rejected Options for Entre
*/
if (!Helpers::isCampaignComplete($campaignID) && strtoupper(Session::get('account_type')) == 'ENTREPRENEUR' && !$edit) {
$actions_content .= '<li>' . Helpers::getCampaignAction($campaignID) . '</li>';
} elseif (Helpers::isCampaignComplete($campaignID) && strtoupper($rs[0]->approvalstatus) == 'PENDING' && strtoupper($rs[0]->campaignstatus) != 'PUBLISHED' && Session::get('account_type') == 'ENTREPRENEUR') {
$actions_content .= (!$edit ? '<li>' . Helpers::getCampaignAction($campaignID) . '</li>' : '') . '<a href="javascript:submitAction(\'' . URL() . '/campaign/Publish/' . $c_id . '\')" class="Cpcomment">Publish</a>
</li>';
} elseif (Helpers::isCampaignComplete($campaignID) && strtoupper($rs[0]->approvalstatus) == 'PENDING' && strtoupper($rs[0]->campaignstatus) == 'PUBLISHED' && Session::get('account_type') == 'ADMIN') {
$actions_content .= '<li><a href="javascript:submitAction(\'' . URL() . '/campaign/Approve/' . $c_id . '\')" class="Cpcomment">Approve</a></li>
<li><a href="javascript:submitAction(\'' . URL() . '/campaign/Reject/' . $c_id . '\')" class="Cpcomment">Mark for review</a></li>
<li><a href="javascript:submitAction(\'' . URL() . '/campaign/Deactivate/' . $c_id . '\')" class="Cpcomment">Reject</a></li>';
} else {
$actions_content = '';
}
if ($actions_content != '') {
$actions = '<div class="btn-group">
<button type="button" class="btn btn-warning btn-flat btn-sm">Campaign Action</button>
<button type="button" class="btn btn-warning btn-flat dropdown-toggle btn-sm" data-toggle="dropdown">
<span class="caret"></span>
<span class="sr-only">Toggle Dropdown</span>
</button>
<ul class="dropdown-menu" role="menu">';
$actions .= $actions_content . '</ul></div>';
} else {
$actions = '<div style="height:29px"></div>';
}
return $actions;
}
public static function getMsgCount($message_hash)
{
$rs = DB::Select("select count(message_hash) as messages from mradi_messages where `mradi_messages`.`target_user_id` = ? and message_hash = ? and status = 0", array(Session::get('account_id'), $message_hash));
return $rs[0]->messages;
}
<?php
$idElemento = $_GET['idElemento'];
$consulta = DB::Select('SELECT nombreCompletoTercero, idEntregaElementoProteccion from entregaelementoproteccion ep left join tercero t on ep.Tercero_idTercero = t.idTercero where idEntregaElementoProteccion = ' . $idElemento);
$row = array();
foreach ($consulta as $key => $value) {
foreach ($value as $datoscampo => $campo) {
$row[$key][] = $campo;
}
}
$output['aaData'] = $row;
echo json_encode($output);
?>
<?php
$idGrupo = $_GET['idGrupo'];
$consulta = DB::Select('SELECT nombreCompletoTercero, idConformacionGrupoApoyo, idConformacionGrupoApoyoJurado from conformaciongrupoapoyojurado cgaj left join tercero t on t.idTercero = cgaj.Tercero_idJurado left join conformaciongrupoapoyo cga on cgaj.ConformacionGrupoApoyo_idConformacionGrupoApoyo = cga.idConformacionGrupoApoyo where ConformacionGrupoApoyo_idConformacionGrupoApoyo = ' . $idGrupo);
$row = array();
foreach ($consulta as $key => $value) {
foreach ($value as $datoscampo => $campo) {
$row[$key][] = $campo;
}
}
$output['aaData'] = $row;
echo json_encode($output);
<?php
$idInspeccionDetalle = $_POST['idInspeccionDetalle'];
$imageInsp = DB::Select('SELECT fotoInspeccionDetalle from inspecciondetalle where idInspeccionDetalle = ' . $idInspeccionDetalle);
$img = get_object_vars($imageInsp[0]);
echo json_encode($img);
public function SelectLists($MysqlWhere = '')
{
$DB = new DB();
return $DB->Select('select * from ' . $this->TableName . ' ' . $MysqlWhere);
}
<div class="form-group">
<div class="input-group">
<div class="dropzone dropzone-previews" id="dropzoneTerceroArchivo"></div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
<center>
<div style="border: 1px solid; width:80%; height:300px;">
<?php
if ($idTerceroA != '') {
$eliminar = '';
$archivoSave = DB::Select('SELECT * from terceroarchivo where Tercero_idTercero = ' . $idTerceroA);
for ($i = 0; $i < count($archivoSave); $i++) {
$archivoS = get_object_vars($archivoSave[$i]);
echo '<div id="' . $archivoS['idTerceroArchivo'] . '" style="width:50%; height:50%; border:1px solid; float:left;"> <center>
<a target="_blank" href="http://' . $_SERVER["HTTP_HOST"] . '/imagenes' . $archivoS['rutaTerceroArchivo'] . '"><img src="http://' . $_SERVER["HTTP_HOST"] . '/imagenes' . $archivoS['rutaTerceroArchivo'] . '" width="25%"></a></center>';
$eliminar .= $archivoS['idTerceroArchivo'] . ',';
echo ' <a style="cursor:pointer;" onclick="eliminarDiv(document.getElementById(' . $archivoS['idTerceroArchivo'] . ').id);">Borrar archivo</a>
<input type="hidden" id="idTerceroArchivo[]" name="idTerceroArchivo[]" value="' . $archivoS['idTerceroArchivo'] . '" >
<input type="hidden" id="tituloTerceroArchivo[]" name="tituloTerceroArchivo[]" value="' . $archivoS['tituloTerceroArchivo'] . '" >
<input type="hidden" id="fechaTerceroArchivo[]" name="fechaTerceroArchivo[]" value="' . $archivoS['fechaTerceroArchivo'] . '" >
<input type="hidden" id="rutaTerceroArchivo[]" name="rutaTerceroArchivo[]" value="' . $archivoS['rutaTerceroArchivo'] . '" ></div>';
function UpdateAreaGroupID($ParentAreaID, $GroupID)
{
$DB = new DB();
$sql = 'UPDATE `tbl_location` SET GroupID=' . $GroupID . ' WHERE AreaID=' . $ParentAreaID;
if ($DB->Update($sql)) {
$sql = 'Select AreaID FROM `tbl_location` WHERE ParentAreaID=' . $ParentAreaID;
$rs = $DB->Select($sql);
if ($rs) {
foreach ($rs as $list) {
UpdateAreaGroupID($list['AreaID'], $GroupID);
}
}
}
}
border-radius: 4px;
}
</style>
<?php
$visible = '';
if (isset($datos[0])) {
$dato = get_object_vars($datos[0]);
if ($dato['adicionarRolOpcion'] == 1) {
$visible = 'inline-block;';
} else {
$visible = 'none;';
}
} else {
$visible = 'none;';
}
$lineaNegocio = DB::Select('SELECT idLineaNegocio, nombreLineaNegocio from lineanegocio');
?>
<div class="container">
<div class="row">
<div class="container">
<br>
<div class="btn-group" style="margin-left: 94%;margin-bottom:4px" title="Columns">
<button type="button" class="btn btn-default dropdown-toggle"data-toggle="dropdown">
<i class="glyphicon glyphicon-th icon-th"></i>
<span class="caret"></span>
</button>
<ul class="dropdown-menu dropdown-menu-right" role="menu">
<li><a class="toggle-vis" data-column="0"><label> Iconos</label></a></li>
<li><a class="toggle-vis" data-column="1"><label> ID</label></a></li>
<li><a class="toggle-vis" data-column="2"><label> Fecha Inicial</label></a></li>
<li><a class="toggle-vis" data-column="3"><label> Fecha Final</label></a></li>