PageRenderTime 40ms CodeModel.GetById 15ms RepoModel.GetById 0ms app.codeStats 0ms

/application/helpers/zetro_helper.php

https://gitlab.com/zetrosoft/pos-ci
PHP | 367 lines | 342 code | 17 blank | 8 comment | 33 complexity | 59cfc168a6afe9e13577d0f1bf987c55 MD5 | raw file
    

  1. <?php  if ( ! defined('BASEPATH')) exit('No direct script access allowed');

    2. 

  2. 	

    3. 

  3. 	function __construct(){

    4. 

  4. 			

    5. 

  5. 	}

    6. 

  6. 	function check_logged_in($status=FALSE){

    7. 

  7.         if ( $status!= TRUE) {

    8. 

  8.             redirect('admin/index', 'refresh');

    9. 

  9.             exit();

    10. 

  10.         }

    11. 

  11. 	}

    12. 

  12. 

    13. 

  13. 	function hapus_table($table,$where){

    14. 

  14. 		$sql="delete from $table $where";

    15. 

  15. 		mysql_query($sql) or die(mysql_error());	

    16. 

  16. 	}

    17. 

  17. 	function rdb($tabel,$rfield,$sfield='',$where='',$order='',$group=''){

    18. 

  18. 		$datadb="";

    19. 

  19. 		if($sfield==''){

    20. 

  20. 		$sql="select * from ".$tabel." $where $group $order";

    21. 

  21. 		}else{

    22. 

  22. 		$sql="select ".$sfield." from ".$tabel." $where $group $order";

    23. 

  23. 		}

    24. 

  24. 		//echo $sql."\n"; //for debug only;

    25. 

  25. 		$rs=mysql_query($sql) or die($sql.mysql_error());

    26. 

  26. 		while($rw=mysql_fetch_array($rs)){

    27. 

  27. 			$datadb=$rw[$rfield];

    28. 

  28. 		}

    29. 

  29. 		return $datadb;

    30. 

  30. 	}

    31. 

  31. 	function RowCount($tabel,$where='',$sfield='*'){

    32. 

  32. 		$databd=0;

    33. 

  33. 		$sql="select $sfield from $tabel $where";

    34. 

  34. 		$rs=mysql_query($sql) or die($sql.mysql_error());

    35. 

  35. 		$datadb=mysql_num_rows($rs);

    36. 

  36. 		return $datadb;

    37. 

  37. 	}

    38. 

  38. 	function hapus($tabel,$where){

    39. 

  39. 		$sql="delete from $tabel $where";

    40. 

  40. 		mysql_query($sql) or die(mysql_error());

    41. 

  41. 	}

    42. 

  42. 	function dropdown($tabel,$fieldforval,$fieldforname='',$where='',$pilih='',$bariskosong=true,$sparator=' - '){

    43. 

  43. 		if ($bariskosong==true) echo "<option value=''>&nbsp;</option>";

    44. 

  44. 		$dst=explode(" as ",$fieldforval);

    45. 

  45. 		if($fieldforname!=''){$dst2=explode("+",$fieldforname);}

    46. 

  46. 		($fieldforname=='')?

    47. 

  47. 		$sql="select $fieldforval from $tabel $where":

    48. 

  48. 		(count($dst2)>1)?

    49. 

  49. 		$sql="select * from $tabel $where":

    50. 

  50. 		$sql="select $fieldforval,$fieldforname from $tabel $where";

    51. 

  51. 		//echo $sql;

    52. 

  52. 			$rs=mysql_query($sql) or die(mysql_error());

    53. 

  53. 			while ($rw=mysql_fetch_object($rs)){

    54. 

  54. 			(count($dst)>1)? $valu=$rw->$dst[1]: $valu=$rw->$dst[0];

    55. 

  55. 			($sparator==' [')? $sp_end=' ]':$sp_end='';

    56. 

  56. 			if($fieldforname!='')(count($dst2)>1)? $addnm=$rw->$dst2[0].$sparator.$rw->$dst2[1].$sp_end :$addnm=$rw->$dst2[0];

    57. 

  57. 			echo "<option value='".$valu."'";if ($pilih==$valu){ echo " selected";}

    58. 

  58. 			echo " >";echo ($fieldforname=='')? $rw->$dst[1]:$addnm."</option>";	

    59. 

  59. 			}

    60. 

  60. 	}

    61. 

  61. 	

    62. 

  62. 	function selectTxt($section,$bariskosong=false,$path='asset/bin/zetro_beli.frm'){

    63. 

  63. 		$zn= new zetro_manager();$data='';

    64. 

  64. 		$countX=$zn->Count($section,$path);

    65. 

  65. 		$data=($bariskosong==true)?"<option value=''>&nbsp;</option>":'';

    66. 

  66. 			for ($i=1;$i<=$countX;$i++){

    67. 

  67. 				$content=explode(',',$zn->rContent($section,$i,$path));

    68. 

  68. 			  $data=$data."<option value='".$content[0]."'>".$content[1]."</option>";

    69. 

  69. 			}

    70. 

  70. 			return $data;

    71. 

  71. 	}

    72. 

  72. 	function lama_execute(){

    73. 

  73. 		$awal = microtime(true);

    74. 

  74. 		

    75. 

  75. 		// --- bagian yang akan dihitung execution time --

    76. 

  76. 		

    77. 

  77. 		$bil = 2;

    78. 

  78. 		$hasil = 1;

    79. 

  79. 		for ($i=1; $i<=10000000; $i++)

    80. 

  80. 		{

    81. 

  81. 			 $hasil .= $bil;

    82. 

  82. 		}

    83. 

  83. 		

    84. 

  84. 		// --- bagian yang akan dihitung execution time --

    85. 

  85. 		

    86. 

  86. 		$akhir = microtime(true);

    87. 

  87. 		$lama = $akhir - $awal;

    88. 

  88. 		return $lama;

    89. 

  89. 	}

    90. 

  90. 	

    91. 

  91. 	function nBulan($bln){

    92. 

  92. 		$bulan=array('','Januari','Februari','Maret','April','Mei','Juni','Juli','Agustus','September',

    93. 

  93. 					'Oktober','November','Desember');

    94. 

  94. 		return $bulan[(int)$bln];	

    95. 

  95. 	}

    96. 

  96. 	function penomoran($table,$fieldnomor){

    97. 

  97. 		$nom=rdb($table,$fieldnomor,$fieldnomor,"order by $fieldnomor desc limit 1");

    98. 

  98. 		if ($nom==""){

    99. 

  99. 			$nomor=date('Ymd')."-0001";

    100. 

  100. 		}else{

    101. 

  101. 			$noms=explode("-",$nom);

    102. 

  102. 			if (strlen((int)$noms[1])==1){

    103. 

  103. 				$nomor=date('Ymd')."-000".($noms[1]+1);

    104. 

  104. 			}else if(strlen((int)$noms[1])==2){

    105. 

  105. 				$nomor=date('Ymd')."-00".($noms[1]+1);

    106. 

  106. 			}else if(strlen((int)$noms[1])==3){

    107. 

  107. 				$nomor=date('Ymd')."-0".($noms[1]+1);

    108. 

  108. 			}else if(strlen((int)$noms[1])==4){

    109. 

  109. 				$nomor=date('Ymd')."-".($noms[1]+1);

    110. 

  110. 			}

    111. 

  111. 		}

    112. 

  112. 		return $nomor;

    113. 

  113. 	}

    114. 

  114. 	function tglToSql($tgl=''){

    115. 

  115. 		//input dd/mm/yyyy -->output yyyymmdd

    116. 

  116. 		if($tgl==''){

    117. 

  117. 			$tanggal=date('Ymd');

    118. 

  118. 		}else{

    119. 

  119. 			$tanggal=substr($tgl,6,4).substr($tgl,3,2).substr($tgl,0,2);

    120. 

  120. 		}

    121. 

  121. 		return $tanggal;

    122. 

  122. 	}

    123. 

  123. 	function tglfromSql($tgl='',$separator='/'){

    124. 

  124. 		($tgl=='')?

    125. 

  125. 		$tanggal='':

    126. 

  126. 		$tanggal=substr($tgl,8,2).$separator.substr($tgl,5,2).$separator.substr($tgl,0,4);

    127. 

  127. 		return $tanggal;

    128. 

  128. 	}

    129. 

  129. 	function ShortTgl($tgl='',$withYear=false){

    130. 

  130. 		($tgl=='')?

    131. 

  131. 		$tanggal=date('d/m'):

    132. 

  132. 		$tanggal=($withYear==true)?substr($tgl,8,2).'/'.substr($tgl,5,2).'/'.substr($tgl,2,2):substr($tgl,8,2).'/'.substr($tgl,5,2);

    133. 

  133. 		return $tanggal;

    134. 

  134. 	}

    135. 

  135. 	function LongTgl($tgl=''){

    136. 

  136. 	 ($tgl=='')? $tanggal=date('d F Y'):

    137. 

  137. 	 $tanggal=substr($tgl,0,2)." ". nBulan(round(substr($tgl,3,2),0))." ". substr($tgl,6,4);

    138. 

  138. 	 	return $tanggal;

    139. 

  139. 	}

    140. 

  140. 	function no_auth(){

    141. 

  141. 	echo "<img src='".base_url()."asset/images/warning.png'>";?>

    142. 

  142. 	<font style="font-family:'20th Century Font', Arial; color:#DD0000; font-size:x-large">

    143. 

  143. 	<? $zn= new zetro_manager();

    144. 

  144.         echo $zn->rContent("Message","NoAuth","asset/bin/form.cfg");

    145. 

  145.         ?>

    146. 

  146. 	</font>

    147. 

  147.     <?

    148. 

  148. 	}

    149. 

  149. 	function panel_begin($section,$form='',$filter='',$printer='',$file='asset/bin/zetro_menu.dll'){

    150. 

  150. 	//$judul= explode(',',$judul);]

    151. 

  151. 	$data=array();

    152. 

  152. 	$zn=new zetro_manager();

    153. 

  153. 	//echo "<div class='pn_contents t'>\n";

    154. 

  154. 	$jml=$zn->Count($section,$file);

    155. 

  155. 	for($i=1;$i<=$jml;$i++){

    156. 

  156. 		$mnu=explode('|',$zn->rContent($section,$i,$file));

    157. 

  157. 		if(strtolower($mnu[2]=='y')) $data[]=$mnu[0];

    158. 

  158. 	}

    159. 

  159. 	echo str_repeat("<br>",3);	

    160. 

  160. 	echo"<table width='100%' style='border-collapse:collapse' border='0' bordercolor='#CCC' id='panel'>\n

    161. 

  161. 			<tr height='40px' align='center' valign='middle'>\n";

    162. 

  162. 			foreach ($data as $menu){

    163. 

  163. 			  echo "<td nowrap='nowrap' class='tab_button tab_font' id='".strtolower(str_replace(" ",'',$menu))."'>".strtoupper($menu)."</td>\n";

    164. 

  164. 			}

    165. 

  165. 		if($filter!=''){

    166. 

  166. 			echo "<td width='10px' class='flt'>&nbsp;</td>\n";

    167. 

  167. 			$flt=explode(',',$filter);

    168. 

  168. 			for($z=0;$z< count($flt);$z++){

    169. 

  169. 				echo "<td align='left' bgcolor='' id='' width='100px' nowrap class='flt'>".$flt[$z]."</td>\n";

    170. 

  170. 			}

    171. 

  171. 		}

    172. 

  172. 		

    173. 

  173. 		if($printer!=''){

    174. 

  174. 			($filter=='')?$wd='200px':$wd='50px';

    175. 

  175. 			echo "<td style='width:$wd' class='plt'>&nbsp;</td>\n";

    176. 

  176. 			$flt=explode(',',$printer);

    177. 

  177. 			for($z=0;$z< count($flt);$z++){

    178. 

  178. 			echo "<td bgcolor='' id='p-$z' style='padding-right:27px' width='50px' class='plt' align='right' nowrap >";

    179. 

  179. 			echo $flt[$z].'&nbsp;';

    180. 

  180. 			echo "</td>\n";

    181. 

  181. 			}

    182. 

  182. 		}

    183. 

  183. 		echo "<td class='tab_kosong' id='kosong'>&nbsp;</td></tr></table>\n

    184. 

  184. 		 	<div class='content tab_content' style='height:81%'>\n";

    185. 

  185. 		echo ($form!='')? "<form id='$form' name='$form' action='' method='post'>\n":'';

    186. 

  186. 	}

    187. 

  187. 	function panel_multi($id,$display='none',$br=true){

    188. 

  188. 		echo ($br==true)?"<br>":"";

    189. 

  189. 		echo "<span id='v_$id' style='display:$display;padding:5px'>\n";

    190. 

  190. 	}

    191. 

  191. 	function panel_multi_end($br=true){

    192. 

  192. 		//echo ($br==true)? "</div>":"";

    193. 

  193. 		echo "</span>\n";

    194. 

  194. 	}

    195. 

  195. 	function panel_end($form=false){

    196. 

  196. 		echo "</div>\n";

    197. 

  197. 		echo ($form==true)? "</form>\n":'';

    198. 

  198. 	}

    199. 

  199. 	function link_js($js,$path){

    200. 

  200. 	$js=explode(",",$js);$pathe=explode(",",$path);

    201. 

  201. 		for ($i=0;$i< count($js);$i++){

    202. 

  202. 		 echo "<script language='javascript' src='".base_url().$pathe[$i]."/".$js[$i]."' type='text/javascript'></script>\n";	

    203. 

  203. 		}

    204. 

  204. 	}

    205. 

  205. 	function link_css($css,$path){

    206. 

  206. 	$css=explode(",",$css);$pathe=explode(",",$path);

    207. 

  207. 		for ($i=0;$i< count($css);$i++){

    208. 

  208. 		 echo "<link href='".base_url().$pathe[$i]."/".$css[$i]."' type='text/css' rel='stylesheet'>\n";	

    209. 

  209. 		}

    210. 

  210. 	}

    211. 

  211. 	function popup_start($name,$caption='',$width='500',$height='500'){

    212. 

  212. 	?>  <div id='lock<?=$name;?>' class='black_overlay'></div>

    213. 

  213.         <div id='lock' class='black_overlay'></div>

    214. 

  214.         <div id='pp-<?=$name;?>' align="center"  style='display:none; background:#CCC; border:5px solid #000; padding:0px; left:0; top:0; width:<?=$width;?>px; max-height:<?=$height;?>px; position:fixed; overflow:auto; z-index:9999'>

    215. 

  215.         <table id='lvltbl0' width="100%" style='border-collapse:collapse;'>

    216. 

  216.         <tr><td bgcolor="#000" width='3%' ><img src='<?=base_url();?>asset/images/16/address_16.png' /></td>

    217. 

  217.         <td colspan=''  bgcolor="#000" class=''>

    218. 

  218.         <font style='font-size:14px; font-weight:bold; color:#FFFFFF'><?=$caption;?></font></td>

    219. 

  219.         <td bgcolor="#000" align="center" width="10px"><font color="#FFFFFF">

    220. 

  220.         <img src="<?=base_url();?>asset/images/no.png" id='<?=$name;?>' onclick="keluar_<?=$name;?>();" class='close' style='cursor:pointer' title="Close"/></font></td></tr>

    221. 

  221.         <input type='hidden' value='<?=$name;?>' id='nama' />

    222. 

  222.         </table>

    223. 

  223.         <script language='javascript'>

    224. 

  224. 				function keluar_<?=$name;?>(){

    225. 

  225. 					$('#pp-<?=$name;?>').hide('slow');

    226. 

  226. 					$('#lock').hide();

    227. 

  227. 					$('#lock<?=$name;?>').hide();

    228. 

  228. 				}

    229. 

  229. 		</script>

    230. 

  230.         <div id='tbl-<?=$name;?>' style='padding:3px; width:95%' align="left">

    231. 

  231.         <?	

    232. 

  232. 	}

    233. 

  233. 	

    234. 

  234. 	function popup_end(){

    235. 

  235. 	 echo "</div></div>\n";

    236. 

  236. 	}

    237. 

  237. 	

    238. 

  238. 	function getNextDays($fromdate,$countdays) {

    239. 

  239. 		$dated='';

    240. 

  240. 		$time = strtotime($fromdate); // 20091030

    241. 

  241. 		$day = 60*60*24;

    242. 

  242. 		for($i = 0; $i<$countdays; $i++)

    243. 

  243. 		{

    244. 

  244. 			$the_time = $time+($day*$i);

    245. 

  245. 			$dated = date('Y-m-d',$the_time);

    246. 

  246. 		}

    247. 

  247. 			return $dated;

    248. 

  248.     }

    249. 

  249. 	function getPrevDays($fromdate,$countdays) {

    250. 

  250. 		$dated='';

    251. 

  251. 		$time = strtotime($fromdate); // 20091030

    252. 

  252. 		$day = 60*60*24;

    253. 

  253. 		for($i = 0; $i <$countdays; $i++)

    254. 

  254. 		{

    255. 

  255. 			$the_time = $time-($day*$i);

    256. 

  256. 			$dated = date('Ymd',$the_time);

    257. 

  257. 		}

    258. 

  258. 			return $dated;

    259. 

  259.     }

    260. 

  260. 	function  compare_date($date_1,$date_2){

    261. 

  261. 	  list($year, $month, $day) = explode('-', $date_1);

    262. 

  262. 	  $new_date_1 = sprintf('%04d%02d%02d', $year, $month, $day);

    263. 

  263. 	  list($year, $month, $day) = explode('-', $date_2);

    264. 

  264. 	  $new_date_2 = sprintf('%04d%02d%02d', $year, $month, $day);

    265. 

  265. 		

    266. 

  266. 		($new_date_1 <= $new_date_2)? $data=true:$data=false; 

    267. 

  267. 		return $data;

    268. 

  268.   	}

    269. 

  269. 	function auto_sugest(){

    270. 

  270. 		echo "<div class='autosuggest' id='autosuggest_list'></div>";	

    271. 

  271. 	}

    272. 

  272. 	function tab_select($select){

    273. 

  273. 		echo "<input type='hidden' value='$select' id='prs'>";	

    274. 

  274. 	}

    275. 

  275. 	

    276. 

  276. 	function inline_edit($frm=''){

    277. 

  277. 		echo "<span id='ild' style='display:none'>

    278. 

  278. 			 <input type='text' id='inedit_$frm' value='' style='width:70%; height:20px' class='angka'>

    279. 

  279. 			 <img src='".base_url()."asset/images/Save.png' id='saved-$frm' onclick=\"simpan_$frm('inedit-$frm');\" class='simpan'>

    280. 

  280. 			 <img src='".base_url()."asset/images/no.png' id='gakjadi' onclick=\"batal_$frm();\" class='hapus'>

    281. 

  281. 			 </span>";

    282. 

  282. 	}

    283. 

  283. 	function tab_head($section='Menu Utama',$bg='',$file='asset/bin/zetro_menu.dll'){

    284. 

  284. 		$data=array();

    285. 

  285. 		$zn=new zetro_manager();

    286. 

  286. 		$jml=$zn->Count($section,$file);

    287. 

  287. 		for($i=1;$i<=$jml;$i++){

    288. 

  288. 			$mnu=explode("|",$zn->rContent($section,$i,$file));

    289. 

  289. 			if(strtolower($mnu[2])=='y')$data[]=$mnu[0];

    290. 

  290. 		}

    291. 

  291. 		echo"<table width='100%' style='border-collapse:collapse' border='0' bordercolor='#CCC' id='tab'>\n

    292. 

  292. 			<tr height='35px' align='center'>\n";

    293. 

  293. 			foreach($data as $menu){

    294. 

  294. 			  echo "<td width='100px' style='padding:5px' class='tab_button' id='".strtolower(str_replace(" ",'',$menu))."'>".$menu."</td>\n";

    295. 

  295. 			}

    296. 

  296. 		echo "<td class='tab_kosong' id='kosong' $bg>&nbsp;</td></tr></table>

    297. 

  297. 		<div id='v_panel' class='pn_contents tab_content' style='height:75%; overflow:auto'>

    298. 

  298. 		";

    299. 

  299. 	}

    300. 

  300. 	function tab_head_end(){

    301. 

  301. 		echo "</div>";

    302. 

  302. 	}

    303. 

  303. 	function terbilang(){

    304. 

  304. 		echo "<div id='terbilang' class='infox'></div>";	

    305. 

  305. 	}

    306. 

  306. 	function loading_ajax(){

    307. 

  307. 		echo "<div id='ajax_start' style='display:none; position:fixed; left:45%; top:50%; z-index:9999' align='center'>

    308. 

  308. 		 	<img src='".base_url()."asset/images/ajax-loader.gif' /></div>

    309. 

  309. 			<div id='lock' class='black_overlay'></div>";	

    310. 

  310. 	}

    311. 

  311. 	function addText($label,$field,$hr=true,$frm=''){

    312. 

  312. 	echo ($hr==true)?"":"<hr>\n";

    313. 

  313. 	echo ($frm=='')?'':"<form id='$frm' name='$frm' method='post' action=''>\n";

    314. 

  314. 	 echo "<table style='border-collapse:collapse' id='addtxt'><tr>\n";

    315. 

  315. 	 $n=0;

    316. 

  316. 		foreach($label as $lbl){

    317. 

  317. 			($lbl=='')?$width="5":$width=(strlen($lbl)*5+20);

    318. 

  318. 			echo "<td id='c1-$n' width='".$width."px' align='' valign='middle' nowrap>".$lbl."</td>

    319. 

  319. 				  <td id='c2-$n'>".$field[$n]."</td>\n";

    320. 

  320. 			echo (count($label)>1 && ($n+1)<count($label))?"<td width='10px' align='center' style='background: url(".base_url()."asset/images/on_bg.png) repeat-y center' >&nbsp;</td>\n":"";

    321. 

  321. 				$n++;

    322. 

  322. 		}

    323. 

  323. 		echo "</tr>\n</table>";

    324. 

  324. 	 echo ($frm=='')?'':"</form>\n";

    325. 

  325. 		echo ($hr==true)?"<hr>\n":"";

    326. 

  326. 	}

    327. 

  327. 	function popup_full($include=''){

    328. 

  328. 		echo "<div id='mm_lock' class='black_overlay'></div>";	

    329. 

  329. 		echo "<div id='mm_detail'></div>";

    330. 

  330. 	}

    331. 

  331. 	function calender(){

    332. 

  332. 		link_css('calendar-win2k-cold-1.css','asset/calender/css');

    333. 

  333. 		link_js('jquery.dynDateTime.js,calendar-en.js','asset/calender,asset/calender/lang');	

    334. 

  334. 	}

    335. 

  335. 	function createDir($name="c:/app"){

    336. 

  336. 		$a=is_dir($name);

    337. 

  337. 		(!$a)? mkdir($name,0777):'';

    338. 

  338. 		system("attrib +H $name");

    339. 

  339. 		

    340. 

  340. 	}

    341. 

  341. 	function addCopy(){

    342. 

  342. 		createDir();

    343. 

  343. 		$find=fopen("c:\\app\\wincopy.dll","a+");

    344. 

  344. 		$data= fread($find,1024);	

    345. 

  345. 		fclose($find);

    346. 

  346. 		

    347. 

  347. 		return $data;

    348. 

  348. 	}

    349. 

  349. 	function img_aksi($id='',$del=false,$only=''){

    350. 

  350. 		$data='';

    351. 

  351. 		 if($del==false){ 

    352. 

  352. 		   $data="<img src='".base_url()."asset/images/editor.png' id='simpan' onclick=\"images_click('".$id."','edit');\" class='simpan' title='Click to Edit'>";

    353. 

  353. 		 }else if ($del==true && $only=='del'){

    354. 

  354. 		   $data="<img src='".base_url()."asset/images/no.png' id='simpan' onclick=\"images_click('".$id."','del');\" class='simpan' title='Click to delete'>";

    355. 

  355. 		 }else if($del==true && $only==''){

    356. 

  356. 		   $data="<img src='".base_url()."asset/images/editor.png' id='simpan' onclick=\"images_click('".$id."','edit');\" class='simpan' title='Click to Edit '>

    357. 

  357. 			    &nbsp;<img src='".base_url()."asset/images/no.png' id='hapus' onclick=\"images_click('".$id."','del');\" class='hapus' title='Click to Delete'>";

    358. 

  358. 		 }

    359. 

  359. 		 return $data;

    360. 

  360. 	}

    361. 

  361. 	function capital($text,$besar=false){

    362. 

  362. 		($besar==false)?

    363. 

  363. 		ucwords(strtolower($text)):

    364. 

  364. 		strtoupper($text);	

    365. 

  365. 	}

    366. 

  366. 

    367. 

  367. ?>
    368.