/ var / www / html / cai / application / models / [ HOME SHELL ]

Name	Size	Permission	Action
070623-Evnt_model.php	3.67 KB	-rwxr-x--x
15122022-Prod_model.php	4.71 KB	-rwxr-x--x
250123-Home_model.php	1.93 KB	-rwxr-x--x
Blog_model.php	2.88 KB	-rwxr-x--x
Content_model.php	21.72 KB	-rwxr-x--x
Crose_model.php	10.52 KB	-rwxr-x--x
Crosej_model.php	10.52 KB	-rwxr-x--x
Evnt_model.php	3.67 KB	-rwxrwxrwx
Fun_model.php	11.14 KB	-rwxr-x--x
Gblsetup_model.php	61.64 KB	-rwxr-x--x
Home_model.php	5.04 KB	-rwxr-x--x
Itmsetup_model.php	6.27 KB	-rwxr-x--x
Jobc_model.php	10.52 KB	-rwxr-x--x
Login_model.php	4.03 KB	-rwxr-x--x
Mdc_model.php	10.21 KB	-rwxr-x--x
Mems_model.php	3.09 KB	-rwxr-x--x
Pages_model.php	6.04 KB	-rwxr-x--x
Prod_model.php	4.99 KB	-rwxr-x--x
Proj_model.php	10.59 KB	-rwxr-x--x
Publ_model.php	6.72 KB	-rwxr-x--x
Stat_model.php	7.25 KB	-rwxr-x--x
User_model.php	11.63 KB	-rwxr-x--x
Wrks_model.php	10.52 KB	-rwxr-x--x
index.html	131 B	-rwxr-x--x

Code Editor : Content_model.php

<?php
defined('BASEPATH') OR exit('No direct script access allowed');
class Content_model extends CI_Model {

public function __construct()
	{
		parent::__construct();
		//$this->load->database();
	}
	
	
	
	//cat section
	public function bCatList($Cond=null)
	{
		$this->db->select('ID,NAME');
		$this->db->from($this->data['TBL']['BCAT']);
		if($Cond!='')$this->db->where($Cond);
		$this->db->order_by('NAME','ASC');
		$query = $this->db->get();
		//echo $this->db->last_query();
		$data = array(); $i=0;
		if($query->num_rows() > 0)
		{
			foreach ($query->result() as $row){
				$data[$i]['Id']     = $row->ID;
				$data[$i]['NAME']   = dbOut($row->NAME);
				$i++;
			}
		return $data;
		}
		return $data;
	}
	public function blgList($params = array(),$Cond=null,$ShrtName=null,$ShrtBy=null)
	{
		$this->db->select('*');
		$this->db->from($this->data['TBL']['BLG']);
		if($Cond!='')$this->db->where($Cond);
		if($ShrtName!='' && $ShrtBy!='')
		{
		$this->db->order_by($ShrtName,$ShrtBy);
		}else{
		$this->db->order_by('ID','DESC');
		}
		$Sr = 1;
		if(array_key_exists("start",$params) && array_key_exists("limit",$params))
		{
		  $this->db->limit($params['limit'],$params['start']);
		  $Sr = $params['start']+1;
		  if($params['start']<=0)$Sr = 1;
		}
		elseif(!array_key_exists("start",$params) && array_key_exists("limit",$params))
		{
		  $this->db->limit($params['limit']);
		}
		$query = $this->db->get();
		//echo $this->db->last_query();
		$data = array(); $i=0;
		if($query->num_rows() > 0)
		{
			foreach ($query->result() as $row){
				$data[$i]['Sr']     = $Sr;
				$data[$i]['Id']     = $row->ID;
				$data[$i]['NAME']   = dbOut($row->NAME);
				$data[$i]['ALIAS']  = dbOut($row->ALIAS);
				$data[$i]['STATUS'] = dbOut($row->STATUS);
				$data[$i]['IMAGE'] = dbOut($row->IMAGE);
				$data[$i]['ADATE'] = showDate($row->ADATE);
				$i++;$Sr++;
			}
		return $data;
		}
		return $data;
	}
	public function blgDtls($Cond=null)
	{
		$this->db->select('*');
		$this->db->from($this->data['TBL']['BLG']);
		if($Cond!='')$this->db->where($Cond);
		$query = $this->db->get();
		$data = array();
		if($query->num_rows() > 0)
		{
			$data['Id']        = $query->row()->ID;
			$data['NAME']      = dbOut($query->row()->NAME);
			$data['ALIAS']     = dbOut($query->row()->ALIAS);
			$data['CATID']     = dbOut($query->row()->CATID);
			$data['STATUS']    = dbOut($query->row()->STATUS);
			$data['IMAGE']     = dbOut($query->row()->IMAGE);
			$data['BDESC']     = dbOut($query->row()->BDESC);
			$data['STITLE']    = dbOut($query->row()->STITLE);
			$data['SKEYS']     = dbOut($query->row()->SKEYS);
			$data['SDESC']     = dbOut($query->row()->SDESC);
			return $data;
		}
		return $data;
	}
	
	
	
	
	
	// item section
	public function itmList($params = array(),$Cond=null,$ShrtName=null,$ShrtBy=null)
	{
		$this->db->select('i.ID AS ID,i.CATID,i.NAME AS NAME,i.ALIAS,i.SKU AS SKU,i.RPRC AS RPRC,i.DPRC AS DPRC,i.STATUS AS STATUS,c.NAME AS CNAME');
		$this->db->from(''.$this->data['TBL']['ITM'].' AS i');
		$this->db->join(''.$this->data['TBL']['CAT'].' AS c','i.CATID=c.ID','INNER');
		if($Cond!='')$this->db->where($Cond);
		if($ShrtName!='' && $ShrtBy!='')
		{
		$this->db->order_by($ShrtName,$ShrtBy);
		}else{
		$this->db->order_by('ID','DESC');
		}
		$Sr = 1;
		if(array_key_exists("start",$params) && array_key_exists("limit",$params))
		{
		  $this->db->limit($params['limit'],$params['start']);
		  $Sr = $params['start']+1;
		  if($params['start']<=0)$Sr = 1;
		}
		elseif(!array_key_exists("start",$params) && array_key_exists("limit",$params))
		{
		  $this->db->limit($params['limit']);
		}
		$query = $this->db->get();
		//echo $this->db->last_query();
		$data = array(); $i=0;
		if($query->num_rows() > 0)
		{
			foreach ($query->result() as $row){
				$data[$i]['Sr']     = $Sr;
				$data[$i]['Id']     = $row->ID;
				$data[$i]['NAME']   = dbOut($row->NAME);
				$data[$i]['CNAME']   = dbOut($row->CNAME);
				$data[$i]['ALIAS']  = dbOut($row->ALIAS);
				$data[$i]['SKU'] = dbOut($row->SKU);
				$data[$i]['RPRC'] = dbOut($row->RPRC);
				$data[$i]['DPRC'] = dbOut($row->DPRC);
				$data[$i]['STATUS'] = dbOut($row->STATUS);
				$data[$i]['IMAGE'] = dbOut($this->fm->fldval($this->data['TBL']['ITMG'],'NAME',"ITMID='".$row->ID."' AND STATUS='".STATUS_A."'"));
				$i++;$Sr++;
			}
		return $data;
		}
		return $data;
	}
	public function itmCatList($Cond=null)
	{
		$this->db->select('ID,NAME');
		$this->db->from($this->data['TBL']['CAT']);
		if($Cond!='')$this->db->where($Cond);
		$this->db->order_by('ID','DESC');
		$query = $this->db->get();
		$data = array(); $i=0;
		if($query->num_rows() > 0)
		{
			foreach ($query->result() as $row){
				$data[$i]['Id']     = $row->ID;
				$data[$i]['NAME']   = dbOut($row->NAME);
				$i++;
			}
		return $data;
		}
		return $data;
	}
	//cat section
	public function catList($params = array(),$Cond=null,$ShrtName=null,$ShrtBy=null)
	{
		$this->db->select('*');
		$this->db->from($this->data['TBL']['CAT']);
		if($Cond!='')$this->db->where($Cond);
		if($ShrtName!='' && $ShrtBy!='')
		{
		$this->db->order_by($ShrtName,$ShrtBy);
		}else{
		$this->db->order_by('ID','DESC');
		}
		$Sr = 1;
		if(array_key_exists("start",$params) && array_key_exists("limit",$params))
		{
		  $this->db->limit($params['limit'],$params['start']);
		  $Sr = $params['start']+1;
		  if($params['start']<=0)$Sr = 1;
		}
		elseif(!array_key_exists("start",$params) && array_key_exists("limit",$params))
		{
		  $this->db->limit($params['limit']);
		}
		$query = $this->db->get();
		//echo $this->db->last_query();
		$data = array(); $i=0;
		if($query->num_rows() > 0)
		{
			foreach ($query->result() as $row){
				$data[$i]['Sr']     = $Sr;
				$data[$i]['Id']     = $row->ID;
				$data[$i]['NAME']   = dbOut($row->NAME);
				$data[$i]['ALIAS']  = dbOut($row->ALIAS);
				$data[$i]['STATUS'] = dbOut($row->STATUS);
				$data[$i]['IMAGE'] = dbOut($row->IMAGE);
				$data[$i]['STITLE'] = dbOut($row->STITLE);
				$data[$i]['SKEYS'] = dbOut($row->SKEYS);
				$data[$i]['SDESC'] = dbOut($row->SDESC);
				$data[$i]['ADATE'] = showDate($row->ADATE);
				$data[$i]['INUSED'] = 0;
				$i++;$Sr++;
			}
		return $data;
		}
		return $data;
	}
	public function catDtls($Cond=null)
	{
		$this->db->select('*');
		$this->db->from($this->data['TBL']['CAT']);
		if($Cond!='')$this->db->where($Cond);
		$query = $this->db->get();
		$data = array();
		if($query->num_rows() > 0)
		{
			$data['Id']        = $query->row()->ID;
			$data['NAME']      = dbOut($query->row()->NAME);
			$data['ALIAS']     = dbOut($query->row()->ALIAS);
			$data['STATUS']    = dbOut($query->row()->STATUS);
			$data['IMAGE']     = dbOut($query->row()->IMAGE);
			$data['STITLE']    = dbOut($query->row()->STITLE);
			$data['SKEYS']     = dbOut($query->row()->SKEYS);
			$data['SDESC']     = dbOut($query->row()->SDESC);
			return $data;
		}
		return $data;
	}
	
	
	
	public function frmFnYr($yr=mull)
	{}

//tax section
	public function TaxGList($params = array(),$Condition=null)
	{}
	public function DtlsTaxG($Condition)
	{}
	public function DtlsTax($Condition)
	{}
	public function ListTax($params = array(),$Condition=null)
	{}
	
	
	
	
	public function treeFunItemNamesGrps($Condition,$tree = '') 
	{}
	// item section
	public function ListItemG($params = array(),$Condition=null)
	{}
	public function DtlsItmG($Condition)
	{}
	// raw matrial
	public function rwmList($Condition=null)
	{}
	// Raw material
	public function BsnList($Condition=null)
	{}
	public function ListRwm($params = array(),$Condition=null)
	{}
	public function bsnRwmList($Condition)
	{}
	public function DtlsRwm($Condition)
	{}
	public function rwmBsnIds($FldName,$Condition)
	{}
	// Uom conversation
	public function CnvrsnUomList($ID=null)
	{}
	public function ListUomCnvrsn($params = array(),$Condition=null)
	{}
	public function DtlsCnvrsn($Condition)
	{}
	// uom
	public function ListUom($params = array(),$Condition=null)
	{}
	public function DtlsUom($Condition)
	{}
	// user section
	public function bsnMdlLIst($Cond=null,$UID=null)
	{}
	public function mdlBsnList($Cond,$Cond2)
	{}
	public function ListBsnMdl($Condition,$UID=null)
	{}
	public function ListMdl($Cond1,$Cond2)
	{}
	public function ListHelp($params = array(),$Cond=null)
	{}
	public function ListUser($params = array(),$Cond=null,$totCnt=null)
	{}
	public function FnYrFromDate($dt=null)
	{}
	public function UsrMdl($Condition)
	{}
	public function UsrBns($Condition)
	{}
	public function ListUserId($Condition)
	{}
	public function UsrMdlList($Condition)
	{}
	public function UsrBnsList($Condition)
	{}
	public function DtlsHelp($Condition)
	{}
	public function DtlsUser($Condition)
	{}
	public function UsrBsnMdlIds($FldName,$Condition)
	{
		$this->db->select(''.$FldName.' AS ID');
		$this->db->from($this->data['TBL']['USR_BSN_MDL']);
		if($Condition!='')$this->db->where($Condition);
		$this->db->order_by('ID','ASC');
		$query = $this->db->get();
		$data = array();
		if($query->num_rows() > 0)
		{
			foreach ($query->result() as $row){
				$data[]= $row->ID;
			}
		return array_values($data);
		}
		return $data;
	}
	
	// business nature
	public function ListBsnature($params = array(),$Cond=null)
	{
		$this->db->select('*');
		$this->db->from($this->data['GBL_TBL']['BSN']);
		if($Cond!='')$this->db->where($Cond);
		$this->db->order_by('NAME','ASC');
		$Sr = 1;
		if(array_key_exists("start",$params) && array_key_exists("limit",$params))
		{
		    $this->db->limit($params['limit'],$params['start']);
			$Sr = $params['start'];
			if($params['start']<=0)$Sr = 1;
		}
		elseif(!array_key_exists("start",$params) && array_key_exists("limit",$params))
		{
		   $this->db->limit($params['limit']);
		}
		$query = $this->db->get();
		$data = array(); $i=0;
		if($query->num_rows() > 0)
		{
			foreach ($query->result() as $row){
				$data[$i]['Sr'] = $Sr;
				$data[$i]['Id'] = $row->BSNTID;
				$data[$i]['NAME'] = dbOut($row->NAME);
				$data[$i]['STATUS'] = dbOut($row->STATUS);
				$data[$i]['InUsed'] = $this->fm->cntCon($this->data['GBL_TBL']['MNU'],"BSNTIDS LIKE '%".$row->BSNTID."%'");
				$data[$i]['InUsr'] = $this->fm->cntConGrp($this->data['TBL']['USR_BSN_MDL'],'UID',"BSNTID='".$row->BSNTID."'");
				$data[$i]['InItg'] = $this->fm->cntCon($this->data['GBL_TBL']['ITG'],"BSNTID='".$row->BSNTID."'");
				$i++; $Sr++;
			}
		return $data;
		}
		return $data;
	}
	public function DtlsBsnature($Condition)
	{
		$this->db->select('*');
		$this->db->from($this->data['GBL_TBL']['BSN']);
		if($Condition!='')$this->db->where($Condition);
		$query = $this->db->get();
		$data = array();
		if($query->num_rows() > 0)
		{
			$data['Id'] = $query->row()->BSNTID;
			$data['NAME'] = dbOut($query->row()->NAME);
			$data['STATUS'] = dbOut($query->row()->STATUS);
			return $data;
		}
		return $data;
	}
	// modules 
	public function ListModules($params = array(),$Condition=null)
	{
		$this->db->select('*');
		$this->db->from($this->data['GBL_TBL']['MNU']);
		if($Condition!='')$this->db->where($Condition);
		$this->db->order_by('SORDER','ASC');
		$Sr = 1;
		if(array_key_exists("start",$params) && array_key_exists("limit",$params))
		{
		  $this->db->limit($params['limit'],$params['start']);
		  $Sr = $params['start'];
		}
		elseif(!array_key_exists("start",$params) && array_key_exists("limit",$params))
		{
		  $this->db->limit($params['limit']);
		}
		
		$query = $this->db->get();
		$data = array(); $i=0;
		if($query->num_rows() > 0)
		{
			foreach ($query->result() as $row){
				$data[$i]['Sr']     = $Sr;
				$data[$i]['Id']     = $row->MODLID;
				$data[$i]['PID']    = $row->PID;
				if((int)$row->PID > 0) 
				{
					$data[$i]['PNAME'] = $this->fm->fldVal($this->data['GBL_TBL']['MNU'],"MODLID='".$row->PID."'");
					$data[$i]['InUsed'] = '';
					$data[$i]['InUsr']  = $this->fm->cntCon($this->data['TBL']['USR_BSN_MDL'],"MODLID='".$row->PID."'");
				}
				if((int)$row->PID <= 0)
				{
				 $data[$i]['PNAME']='';  
				 $data[$i]['InUsed'] = $this->mdlBsn("BSNTID IN (".$row->BSNTIDS.")");
				 $data[$i]['InUsr']  = $this->fm->cntCon($this->data['TBL']['USR_BSN_MDL'],"MODLID='".$row->MODLID."'");
				}
				$data[$i]['NAME']   = dbOut($row->NAME);
				$data[$i]['SORDER'] = dbOut($row->SORDER);
				$data[$i]['TotSub'] = $this->fm->cntCon($this->data['GBL_TBL']['MNU'],"PID='".$row->MODLID."'");
				$data[$i]['STATUS'] = $row->STATUS;
				$i++; $Sr++;
			}
		//echo '<pre>'; print_r($data); exit;	
		return $data;
		}
		return $data;
	}
	public function mdlBsn($Cond)
	{
		$this->db->select('NAME');
		$this->db->from($this->data['GBL_TBL']['BSN']);
		if($Cond!='')$this->db->where($Cond);
		$query = $this->db->get();
		$data = array();
		if($query->num_rows() > 0)
		{
			foreach ($query->result() as $row){
			  $data[] = dbOut($row->NAME);
			}
			return implode(', ',$data);
		}
		return $data;
	}
	public function DtlsModules($Condition)
	{
		$this->db->select('*');
		$this->db->from($this->data['GBL_TBL']['MNU']);
		if($Condition!='')$this->db->where($Condition);
		$query = $this->db->get();
		$data = array();
		if($query->num_rows() > 0)
		{
			$data['Id'] = $query->row()->MODLID;
			$data['PID'] = $query->row()->PID;
			$data['NAME'] = dbOut($query->row()->NAME);
			$data['SORDER'] = dbOut($query->row()->SORDER);
			$data['bsnIds'] = explode(',',$query->row()->BSNTIDS);
			$data['STATUS'] = dbOut($query->row()->STATUS);
			$data['L2'] = dbOut($query->row()->L2);
			$data['L3'] = dbOut($query->row()->L3);
			return $data;
		}
		return $data;
	}
	public function bsnIds($FldName,$Condition)
	{
		$this->db->select(''.$FldName.' AS ID');
		$this->db->from($this->data['GBL_TBL']['MDL_BSN']);
		if($Condition!='')$this->db->where($Condition);
		$this->db->order_by('ID','ASC');
		$query = $this->db->get();
		$data = array();
		if($query->num_rows() > 0)
		{
			foreach ($query->result() as $row){
				$data[]= $row->ID;
			}
		return array_values($data);
		}
		return $data;
	}
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	// online channel
	public function ListOnChnl($params = array(),$Cond=null)
	{
		$this->db->select('*');
		$this->db->from($this->data['TBL_CHNL']);
		if($Cond!='')$this->db->where($Cond);
		$this->db->order_by('NAME','ASC');
		
		if(array_key_exists("start",$params) && array_key_exists("limit",$params)){
		$this->db->limit($params['limit'],$params['start']);
		}elseif(!array_key_exists("start",$params) && array_key_exists("limit",$params)){
		$this->db->limit($params['limit']);
		}
		$query = $this->db->get();
		$data = array(); $i=0;
		if($query->num_rows() > 0)
		{
			foreach ($query->result() as $row){
				$data[$i]['Id'] = $row->ID;
				$data[$i]['NAME'] = CaseU(dbOut($row->NAME));
				$data[$i]['STATUS'] = CaseU(dbOut($row->STATUS));
				$data[$i]['SUBLIST'] = $this->chnlBsTypeNameList("bc.CHNLID ='".$row->ID."'");
				$data[$i]['InUsed'] = $this->fm->cntCon($this->data['TBL_BSTP_CHNL'],"CHNLID='".$row->ID."'");
				$i++;
			}
		return $data;
		}
		return $data;
	}
	public function DtlsOnChnl($Condition)
	{
		$this->db->select('*');
		$this->db->from($this->data['TBL_CHNL']);
		if($Condition!='')$this->db->where($Condition);
		$query = $this->db->get();
		$data = array();
		if($query->num_rows() > 0)
		{
			$data['Id'] = $query->row()->ID;
			$data['NAME'] = dbSameShow($query->row()->NAME);
			$data['STATUS'] = dbSameShow($query->row()->STATUS);
			$data['IDSLIST'] = $this->chnlBsIdList('BTID',"CHNLID='". $query->row()->ID."'");
			return $data;
		}
		return $data;
	}
	// service type
	
	public function srBsTypeNameList($Condition)
	{
		$this->db->select('b.ID,b.NAME');
		$this->db->from(''.$this->data['TBL_BSTP'].' AS b');
		$this->db->join(''.$this->data['TBL_BS_TYPE_SR'].' as bc','b.ID=bc.BTID','LEFT');
		if($Condition!='')$this->db->where($Condition);
		$this->db->order_by('b.NAME','ASC');
		$query = $this->db->get();
		$data = array(); $i=0;
		if($query->num_rows() > 0)
		{
			foreach ($query->result() as $row){
				$data[$i]['Id'] = $row->ID;
				$data[$i]['NAME'] = CaseU(dbOut($row->NAME));
				$i++;
			}
		return $data;
		}
		return $data;
	}
	// business type
	public function ListBsType($params = array(),$Cond=null)
	{
		$this->db->select('*');
		$this->db->from($this->data['TBL_BSTP']);
		if($Cond!='')$this->db->where($Cond);
		$this->db->order_by('NAME','ASC');
		
		if(array_key_exists("start",$params) && array_key_exists("limit",$params)){
		$this->db->limit($params['limit'],$params['start']);
		}elseif(!array_key_exists("start",$params) && array_key_exists("limit",$params)){
		$this->db->limit($params['limit']);
		}
		$query = $this->db->get();
		$data = array(); $i=0;
		if($query->num_rows() > 0)
		{
			foreach ($query->result() as $row){
				$data[$i]['Id'] = $row->ID;
				$data[$i]['NAME'] = CaseU(dbOut($row->NAME));
				$data[$i]['STATUS'] = CaseU(dbOut($row->STATUS));
				$data[$i]['SRLIST'] = $this->BsSrNameList("bc.BTID ='".$row->ID."'");
				$data[$i]['SUBLIST2'] = $this->bsTypeOnLineNameList("bc.BTID ='".$row->ID."'");
				$data[$i]['InUsed'] = $this->fm->cntCon($this->data['TBL_BSTP_USER'],"BTID='".$row->ID."'");
				$i++;
			}
		return $data;
		}
		return $data;
	}
	public function BsSrNameList($Condition)
	{
		$this->db->select('b.ID,b.NAME');
		$this->db->from(''.$this->data['TBL_SRTP'].' AS b');
		$this->db->join(''.$this->data['TBL_BS_TYPE_SR'].' as bc','b.ID=bc.BSTID','LEFT');
		if($Condition!='')$this->db->where($Condition);
		$this->db->order_by('b.NAME','ASC');
		$query = $this->db->get();
		$data = array(); $i=0;
		if($query->num_rows() > 0)
		{
			foreach ($query->result() as $row){
				$data[$i]['Id'] = $row->ID;
				$data[$i]['NAME'] = CaseU(dbOut($row->NAME));
				$i++;
			}
		return $data;
		}
		return $data;
	}
	public function BsTypeNameList($Condition)
	{
		$this->db->select('ID,NAME,STATUS');
		$this->db->from($this->data['TBL_BSTP']);
		if($Condition!='')$this->db->where($Condition);
		$this->db->order_by('NAME','ASC');
		$query = $this->db->get();
		$data = array(); $i=0;
		if($query->num_rows() > 0)
		{
			foreach ($query->result() as $row){
				$data[$i]['Id'] = $row->ID;
				$data[$i]['NAME'] = CaseU(dbOut($row->NAME));
				$data[$i]['STATUS'] = CaseU(dbOut($row->STATUS));
				$i++;
			}
		return $data;
		}
		return $data;
	}
	public function BsNameList($Condition=null)
	{
		$this->db->select('ID,NAME');
		$this->db->from($this->data['TBL_BSTP']);
		if($Condition!='')$this->db->where($Condition);
		$this->db->order_by('NAME','ASC');
		$query = $this->db->get();
		$data = array(); $i=0;
		if($query->num_rows() > 0)
		{
			foreach ($query->result() as $row){
				$data[$i]['Id'] = $row->ID;
				$data[$i]['NAME'] = CaseU(dbOut($row->NAME));
				$i++;
			}
		return $data;
		}
		return $data;
	}
	public function chnlBsTypeNameList($Condition)
	{
		$this->db->select('b.ID,b.NAME');
		$this->db->from(''.$this->data['TBL_BSTP'].' AS b');
		$this->db->join(''.$this->data['TBL_BSTP_CHNL'].' as bc','b.ID=bc.BTID','LEFT');
		if($Condition!='')$this->db->where($Condition);
		$this->db->order_by('b.NAME','ASC');
		$query = $this->db->get();
		$data = array(); $i=0;
		if($query->num_rows() > 0)
		{
			foreach ($query->result() as $row){
				$data[$i]['Id'] = $row->ID;
				$data[$i]['NAME'] = CaseU(dbOut($row->NAME));
				$i++;
			}
		return $data;
		}
		return $data;
	}
	public function chnlBsIdList($FldName,$Condition)
	{
		$this->db->select(''.$FldName.' AS ID');
		$this->db->from($this->data['TBL_BSTP_CHNL']);
		if($Condition!='')$this->db->where($Condition);
		$this->db->order_by('ID','ASC');
		$query = $this->db->get();
		$data = array();
		if($query->num_rows() > 0)
		{
			foreach ($query->result() as $row){
				$data[]= $row->ID;
			}
		return array_values($data);
		}
		return $data;
	}
	public function bsTypeOnLineNameList($Condition)
	{
		$this->db->select('b.ID,b.NAME');
		$this->db->from(''.$this->data['TBL_CHNL'].' AS b');
		$this->db->join(''.$this->data['TBL_BSTP_CHNL'].' as bc','b.ID=bc.CHNLID','LEFT');
		if($Condition!='')$this->db->where($Condition);
		$this->db->order_by('b.NAME','ASC');
		$query = $this->db->get();
		//echo '<br/>'.$this->db->last_query();
		$data = array(); $i=0;
		if($query->num_rows() > 0)
		{
			foreach ($query->result() as $row){
				$data[$i]['Id'] = $row->ID;
				$data[$i]['NAME'] = CaseU(dbOut($row->NAME));
				$i++;
			}
		return $data;
		}
		return $data;
	}
	public function DtlsBsType($Condition)
	{
		$this->db->select('*');
		$this->db->from($this->data['TBL_BSTP']);
		if($Condition!='')$this->db->where($Condition);
		$query = $this->db->get();
		$data = array();
		if($query->num_rows() > 0)
		{
			$data['Id'] = $query->row()->ID;
			$data['NAME'] = dbSameShow($query->row()->NAME);
			$data['STATUS'] = dbSameShow($query->row()->STATUS);
			$data['IDSLIST'] = $this->bsSrIdList('BSTID',"BTID='". $query->row()->ID."'");
			return $data;
		}
		return $data;
	}
	public function bsSrIdList($FldName,$Condition)
	{
		$this->db->select(''.$FldName.' AS ID');
		$this->db->from($this->data['TBL_BS_TYPE_SR']);
		if($Condition!='')$this->db->where($Condition);
		$this->db->order_by('ID','ASC');
		$query = $this->db->get();
		$data = array();
		if($query->num_rows() > 0)
		{
			foreach ($query->result() as $row){
				$data[]= $row->ID;
			}
		return array_values($data);
		}
		return $data;
	}
	
	
	public function userBsIdList($FldName,$Condition)
	{
		$this->db->select(''.$FldName.' AS ID');
		$this->db->from(TBL_BS_TYPE_USER);
		if($Condition!='')$this->db->where($Condition);
		$this->db->order_by('ID','ASC');
		$query = $this->db->get();
		$data = array();
		if($query->num_rows() > 0)
		{
			foreach ($query->result() as $row){
				$data[]= $row->ID;
			}
		return array_values($data);
		}
		return $data;
	}
	public function userBsTypeNameList($Condition)
	{
		$this->db->select('b.ID,b.NAME');
		$this->db->from(''.$this->data['TBL_BSTP'].' AS b');
		$this->db->join(''.TBL_BS_TYPE_USER.' as bc','b.ID=bc.BTID','LEFT');
		if($Condition!='')$this->db->where($Condition);
		$this->db->order_by('b.NAME','ASC');
		$query = $this->db->get();
		$data = array(); $i=0;
		if($query->num_rows() > 0)
		{
			foreach ($query->result() as $row){
				$data[$i]['Id'] = $row->ID;
				$data[$i]['NAME'] = CaseU(dbOut($row->NAME));
				$i++;
			}
		return $data;
		}
		return $data;
	}
}
?>

Urban Research Lab

Urban Research Lab

The Urban Research Lab (URL) at IIIT-Delhi was established in 2020, during a time when the pandemic brought the complexities of urban life more visible than ever. What started as an initiative by faculty and students has grown into a collaborative space for critically exploring and reimagining the urban questions through research, dialogue, and interdisciplinary engagement.