Advertisement
Guest User

Untitled

a guest
Apr 25th, 2017
104
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 22.22 KB | None | 0 0
  1. <?php
  2. if(!isset($menuAccess[$s]["view"])) echo "<script>logout();</script>";
  3. $fFile = "images/user/";
  4.  
  5. function cek(){
  6. global $inp,$par;
  7. if(getField("select username from app_user where username='$inp[username]' and username!='$par[username]'"))
  8. return "sorry, username \" $inp[username] \" already exist";
  9. }
  10.  
  11. function gPegawai(){
  12. global $s,$db,$inp,$par;
  13. $sql="select * from emp where reg_no='".$par[nikPegawai]."'";
  14. $res=db($sql);
  15. $r=mysql_fetch_array($res);
  16.  
  17. $data["idPegawai"] = $r[id];
  18. $data["nikPegawai"] = $r[reg_no];
  19. $data["namaPegawai"] = strtoupper($r[name]);
  20.  
  21. return json_encode($data);
  22. }
  23.  
  24. function fotoUser(){
  25. global $s,$inp,$par,$fFile,$cUsername;
  26. if(in_array($_FILES["fotoUser"]["type"],array('image/jpg','image/jpeg','image/gif','image/png'))){
  27. $image =$_FILES["fotoUser"]["name"];
  28. $uploadFile = $_FILES['fotoUser']['tmp_name'];
  29.  
  30. $oldFile = $fFile.$image;
  31. $ext = getExtension($image);
  32. $fotoUser = md5(date("Y-m-d H:i:s").uniqid(rand(), true)).".".$ext;
  33. $newFile = $fFile.$fotoUser;
  34. $ext = getExtension($oldFile);
  35.  
  36. if($ext=="jpg" || $ext=="jpeg" ) $src = imagecreatefromjpeg($uploadFile);
  37. if($ext=="png") $src = imagecreatefrompng($uploadFile);
  38. if($ext=="gif") $src = imagecreatefromgif($uploadFile);
  39.  
  40. $maxWidth = $maxHeight = 100;
  41. list($width,$height)=getimagesize($uploadFile);
  42. $ratioH = $maxHeight/$height;
  43. $ratioW = $maxWidth/$width;
  44. $ratio = min($ratioH, $ratioW);
  45. $newWidth = ($width>$maxWidth || $height>$maxHeight) ? intval($ratio*$width) : $width;
  46. $newHeight = ($width>$maxWidth || $height>$maxHeight) ? intval($ratio*$height) : $height;
  47.  
  48.  
  49. $tmp=imagecreatetruecolor($newWidth,$newHeight);
  50. imagecopyresampled($tmp,$src,0,0,0,0,$newWidth,$newHeight,$width,$height);
  51. $filename = $fFile. $_FILES['fotoUser']['name'];
  52. imagejpeg($tmp,$filename,100);
  53.  
  54. imagedestroy($src);
  55. imagedestroy($tmp);
  56.  
  57. fileRename("", $oldFile, $newFile);
  58. if($par[username] == $cUsername) setcookie("cFoto",$fotoUser);
  59.  
  60. $tFoto = getField("select fotoUser from app_user where username='$par[username]'");
  61. if(file_exists($fFile.$tFoto) and $tFoto!="")unlink($fFile.$tFoto);
  62. }
  63.  
  64. return empty($fotoUser) ? getField("select fotoUser from app_user where username='$par[username]'") : $fotoUser;
  65. }
  66.  
  67. function hapusPic(){
  68. global $s,$inp,$par,$fFile,$cUsername;
  69. if($par[username] == $cUsername) setcookie("cFoto","");
  70.  
  71. $fotoUser = getField("select fotoUser from app_user where username='$par[username]'");
  72. if(file_exists($fFile.$fotoUser) and $fotoUser!="")unlink($fFile.$fotoUser);
  73.  
  74. $sql="update app_user set fotoUser='' where username='$par[username]'";
  75. db($sql);
  76.  
  77. echo "<script>window.location='?par[mode]=edit".getPar($par,"mode")."'</script>";
  78. }
  79.  
  80. function hapus(){
  81. global $s,$inp,$par,$fFile,$cUsername;
  82. $fotoUser = getField("select fotoUser from app_user where username='$par[username]'");
  83. if(file_exists($fFile.$fotoUser) and $fotoUser!="")unlink($fFile.$fotoUser);
  84.  
  85. $sql="delete from app_user where username='$par[username]'";
  86. db($sql);
  87. echo "<script>window.location='?".getPar($par,"mode,username")."';</script>";
  88. }
  89.  
  90. function ubahPas(){
  91. global $s,$inp,$par,$cUsername;
  92. $password = "$inp[password]";
  93. $pengacak = "UzFuM3JHMV9DNV9EM1ZsMHAzUg==";
  94. $pengacak2 = "8eb98b33c777a27ab57a35ee1dc3a389";
  95.  
  96. $password = md5($pengacak2.$pengacak.md5($password).$pengacak.$pengacak2.$pengacak.$pengacak2);
  97. $sql="update app_user set password='".$password."', updateBy='$cUsername', updateTime='".date('Y-m-d H:i:s')."' where username='$par[username]'";
  98. db($sql);
  99. echo "<script>closeBox();reloadPopup();</script>";
  100. }
  101.  
  102.  
  103. function ubah(){
  104. global $s,$inp,$par,$cUsername, $det;
  105. repField();
  106. $fotoUser = fotoUser();
  107. $sql="update app_user set username='$inp[username]', kodeGroup='$inp[kodeGroup]', idPegawai='$inp[idPegawai]', namaUser='$inp[namaUser]', keteranganUser='$inp[keteranganUser]', fotoUser='$fotoUser', statusUser='$inp[statusUser]', updateBy='$cUsername', updateTime='".date('Y-m-d H:i:s')."',jenisUser='1' where username='$par[username]'";
  108. db($sql);
  109.  
  110. db("delete from app_user_area where username='$par[username]'");
  111. if (is_array($det)) {
  112. while (list($kodeArea) = each($det)) {
  113. $sql = "insert into app_user_area (kodeArea, username, createBy, createTime) values ('$kodeArea', '$par[username]', '$cUsername', '" . date('Y-m-d H:i:s') . "')";
  114. db($sql);
  115. }
  116. }
  117.  
  118. echo "<script>closeBox();reloadPage();</script>";
  119. }
  120.  
  121. function tambah(){
  122. global $s,$inp,$par,$cUsername, $det;
  123. repField();
  124. $fotoUser = fotoUser();
  125. $sql="insert into app_user (username, kodeGroup, idPegawai, password, namaUser, keteranganUser, fotoUser, statusUser, createBy, createTime,jenisUser) values ('$inp[username]', '$inp[kodeGroup]', '$inp[idPegawai]', '".md5($inp[password])."', '$inp[namaUser]', '$inp[keteranganUser]', '$fotoUser', '$inp[statusUser]', '$cUsername', '".date('Y-m-d H:i:s')."','1')";
  126. db($sql);
  127.  
  128. if (is_array($det)) {
  129. while (list($kodeArea) = each($det)) {
  130. $sql = "insert into app_user_area (kodeArea, username, createBy, createTime) values ('$kodeArea', '$inp[username]', '$cUsername', '" . date('Y-m-d H:i:s') . "')";
  131. db($sql);
  132. }
  133. }
  134.  
  135. echo "<script>closeBox();reloadPage();</script>";
  136. }
  137.  
  138. function formPas(){
  139. global $s,$inp,$par,$menuAccess;
  140. setValidation("is_null","inp[password]","you must fill password");
  141. setValidation("is_null","inp[repassword]","you must fill re-type password");
  142. $text = getValidation();
  143.  
  144. $text.="<div class=\"centercontent contentpopup\">
  145. <div class=\"pageheader\">
  146. <h1 class=\"pagetitle\">Reset Password</h1>
  147. ".getBread(ucwords("reset password"))."
  148. </div>
  149. <div id=\"contentwrapper\" class=\"contentwrapper\">
  150. <form id=\"form\" name=\"form\" method=\"post\" class=\"stdform\" action=\"?_submit=1".getPar($par)."\">
  151. <div id=\"general\" class=\"subcontent\">
  152. <p>
  153. <label class=\"l-input-small\">Password</label>
  154. <div class=\"field\">
  155. <input type=\"password\" id=\"inp[password]\" name=\"inp[password]\" value=\"\" class=\"mediuminput\" style=\"width:200px;\"/>
  156. </div>
  157. </p>
  158. <p>
  159. <label class=\"l-input-small\">Re-type Password</label>
  160. <div class=\"field\">
  161. <input type=\"password\" id=\"inp[repassword]\" name=\"inp[repassword]\" value=\"\" class=\"mediuminput\" style=\"width:200px;\"/>
  162. </div>
  163. </p>
  164. <p>
  165. <input type=\"submit\" class=\"submit radius2\" name=\"btnSimpan\" value=\"Save\" onclick=\"return pas();\"/>
  166. <input type=\"button\" class=\"cancel radius2\" value=\"Cancel\" onclick=\"closeBox();\"/>
  167. </p>
  168. </div>
  169. </form>
  170. </div>";
  171. return $text;
  172. }
  173.  
  174. function form(){
  175. global $s,$db,$inp,$par,$fFile,$arrTitle,$arrParameter,$menuAccess,$cUsername,$sUser,$kodeModul,$sGroup;
  176.  
  177. $sql="select * from app_user where username='$par[username]'";
  178. $res=db($sql);
  179. $r=mysql_fetch_array($res);
  180.  
  181. $false = $r[statusUser] == "f" ? "checked=\"checked\"" : "";
  182. $true = empty($false) ? "checked=\"checked\"" : "";
  183.  
  184. setValidation("is_null","inp[username]","you must fill username");
  185. if($par[mode]=="add"){
  186. setValidation("is_null","inp[password]","you must fill password");
  187. setValidation("is_null","inp[repassword]","you must fill re-type password");
  188. }
  189. setValidation("is_null","inp[namaUser]","you must fill real name");
  190. setValidation("is_null","inp[kodeGroup]","you must fill group");
  191. $text = getValidation();
  192.  
  193. $text.="<div class=\"centercontent contentpopup\">
  194. <div class=\"pageheader\">
  195. <h1 class=\"pagetitle\">".$arrTitle[$s]."</h1>
  196. ".getBread(ucwords($par[mode]." data"))."
  197. </div>
  198. <div id=\"contentwrapper\" class=\"contentwrapper\">
  199. <form id=\"form\" name=\"form\" method=\"post\" class=\"stdform\" action=\"?_submit=1".getPar($par)."\" onsubmit=\"return validation(document.form);\" enctype=\"multipart/form-data\">
  200. <ul class=\"hornav\" style=\"margin: 0; margin-top: 10px;\">
  201. <li class=\"current\"><a href=\"#general\">General</a></li>
  202. <li><a href=\"#area_akses\">Area Akses</a></li>
  203. </ul>
  204. <div id=\"general\" class=\"subcontent\" style=\"display:block;\">
  205. <p>
  206. <label class=\"l-input-small\">Username</label>
  207. <div class=\"field\">
  208. <input type=\"text\" id=\"inp[username]\" name=\"inp[username]\" value=\"$r[username]\" class=\"mediuminput\" style=\"width:200px;\" maxlength=\"30\"/>
  209. <input type=\"hidden\" id=\"inp[mode]\" name=\"inp[mode]\" value=\"$par[mode]\"/>
  210. </div>
  211. </p>";
  212. if($par[mode] == "add")
  213. $text.="<p>
  214. <label class=\"l-input-small\">Password</label>
  215. <div class=\"field\">
  216. <input type=\"password\" id=\"inp[password]\" name=\"inp[password]\" value=\"\" class=\"mediuminput\" style=\"width:200px;\"/>
  217. </div>
  218. </p>
  219. <p>
  220. <label class=\"l-input-small\">Re-type Password</label>
  221. <div class=\"field\">
  222. <input type=\"password\" id=\"inp[repassword]\" name=\"inp[repassword]\" value=\"\" class=\"mediuminput\" style=\"width:200px;\"/>
  223. </div>
  224. </p>";
  225.  
  226. if ($cUsername != $sUser) $filter= " and namaGroup != '$sGroup' ";
  227. $text.="<p>
  228. <label class=\"l-input-small\">NIK</label>
  229. <div class=\"field\">
  230. <input type=\"hidden\" id=\"inp[idPegawai]\" name=\"inp[idPegawai]\" value=\"$r[idPegawai]\" readonly=\"readonly\"/>
  231. <input type=\"text\" id=\"inp[nikPegawai]\" name=\"inp[nikPegawai]\" value=\"".getField("select reg_no from emp where id='".$r[idPegawai]."'")."\" class=\"mediuminput\" style=\"width:100px;\" onchange=\"getPegawai('".getPar($par,"mode,nikPegawai")."');\"/>
  232. <input type=\"button\" class=\"cancel radius2\" value=\"...\" onclick=\"openBox('popup.php?par[mode]=peg".getPar($par,"mode,filter")."',700,425);\" />
  233. </div>
  234. </p>
  235. <p>
  236. <label class=\"l-input-small\">Real Name</label>
  237. <div class=\"field\">
  238. <input type=\"text\" id=\"inp[namaUser]\" name=\"inp[namaUser]\" size=\"50\" value=\"$r[namaUser]\" class=\"mediuminput\" style=\"width:350px;\" maxlength=\"50\"/>
  239. </div>
  240. </p>
  241. <p>
  242. <label class=\"l-input-small\">Level 3</label>
  243. <div class=\"field\">
  244. ".comboData("select * from app_group where statusGroup='t' AND kodeGroup !='1' $filter order by namaGroup","kodeGroup","namaGroup","inp[kodeGroup]"," ",$r[kodeGroup],"", "360px")."
  245. </div>
  246. </p>
  247. <p>
  248. <label class=\"l-input-small\">Note</label>
  249. <div class=\"field\">
  250. <textarea id=\"inp[keteranganUser]\" name=\"inp[keteranganUser]\" rows=\"3\" cols=\"50\" class=\"longinput\" style=\"height:50px; width:350px;\">$r[keteranganUser]</textarea>
  251. </div>
  252. </p>
  253. <p>
  254. <label class=\"l-input-small\">Photo</label>
  255. <div class=\"field\">";
  256. $text.=empty($r[fotoUser])?
  257. "<input type=\"text\" id=\"fotoTemp\" name=\"fotoTemp\" class=\"input\" style=\"width:295px;\" maxlength=\"100\" />
  258. <div class=\"fakeupload\">
  259. <input type=\"file\" id=\"fotoUser\" name=\"fotoUser\" class=\"realupload\" size=\"50\" onchange=\"this.form.fotoTemp.value = this.value;\" />
  260. </div>":
  261. "<img src=\"".$fFile."".$r[fotoUser]."\" align=\"left\" height=\"25\" style=\"padding-right:5px; padding-bottom:5px;\">
  262. <a href=\"?par[mode]=delPic".getPar($par,"mode")."\" onclick=\"return confirm('are you sure to delete image ?')\" class=\"action delete\"><span>Delete</span></a>
  263. <br clear=\"all\">";
  264. $text.="</div>
  265. </p>
  266. <p>
  267. <label class=\"l-input-small\">Status</label>
  268. <div class=\"fradio\">
  269. <input type=\"radio\" id=\"true\" name=\"inp[statusUser]\" value=\"t\" $true /> <span class=\"sradio\">Active</span>
  270. <input type=\"radio\" id=\"false\" name=\"inp[statusUser]\" value=\"f\" $false /> <span class=\"sradio\">Not Active</span>
  271. </div>
  272. </p>
  273. <p>";
  274. if($par[mode] == "edit")
  275. $text.="<a href=\"#Reset\" style=\"float:right;\" class=\"btn btn1 btn_refresh\" onclick=\"openBox('popup.php?par[mode]=pas".getPar($par,"mode")."',650,250);\"><span>Reset Password</span></a>";
  276. $text .= "
  277. </p>
  278. <br clear=\"all\">
  279. </div>
  280. <div id=\"area_akses\" class=\"subcontent\" style=\"display:none;\">
  281. <p>
  282. <label class=\"l-input-small\">Area Akses</label>
  283. <div class=\"field\" style=\"margin-left:175px;\">";
  284.  
  285. $det = arrayQuery("select kodeArea, username from app_user_area where username='$par[username]'");
  286. $sql_="select * from mst_data where statusData='t' AND kodeCategory = 'S06' order by urutanData";
  287. $res_=db($sql_);
  288. while($r_=mysql_fetch_array($res_)){
  289. $checked = isset($det["$r_[kodeData]"]) ? "checked=\"checked\"" : "";
  290. $text.="<input type=\"checkbox\" id=\"det[".$r_[kodeData]."]\" name=\"det[".$r_[kodeData]."]\" value=\"".$r_[kodeModul]."\" $checked /> ".$r_[namaData]."<br>";
  291. }
  292. $text.="</div>
  293. </p>
  294. </div>
  295. <p style=\"position: absolute; right: 20px; top: 10px;\">
  296. <input type=\"submit\" class=\"submit radius2\" name=\"btnSimpan\" value=\"Save\" onclick=\"return save('".getPar($par,"mode")."');\"/>
  297. <input type=\"button\" class=\"cancel radius2\" value=\"Cancel\" onclick=\"closeBox();\"/>";
  298. $text.="
  299. </p>
  300. </form>
  301. </div>";
  302. return $text;
  303. }
  304.  
  305. function lihat(){
  306.  
  307. global $s,$inp,$par,$arrTitle,$menuAccess,$arrColor;
  308.  
  309. $cols = 8;
  310.  
  311. $cols = (isset($menuAccess[$s]["edit"]) || isset($menuAccess[$s]["delete"])) ? $cols : $cols-1;
  312.  
  313. $text = table($cols, array(($cols-2),($cols-1),$cols));
  314.  
  315.  
  316.  
  317. $text.="<div class=\"pageheader\">
  318.  
  319. <h1 class=\"pagetitle\">".$arrTitle[$s]."</h1>
  320.  
  321. ".getBread()."
  322.  
  323. <span class=\"pagedesc\">&nbsp;</span>
  324.  
  325. </div>
  326.  
  327. <div id=\"contentwrapper\" class=\"contentwrapper\">
  328.  
  329. <form action=\"\" method=\"post\" id = \"form\" class=\"stdform\" onsubmit=\"return false;\">
  330.  
  331. <div id=\"pos_l\" style=\"float:left;\">
  332.  
  333. <p>
  334.  
  335. <input type=\"text\" id=\"fSearch\" name=\"fSearch\" value=\"".$par[filterData]."\" style=\"width:200px;\"/>
  336.  
  337. </p>
  338.  
  339. </div>
  340.  
  341. <div id=\"pos_r\">".comboData("select * from app_group where statusGroup='t' AND kodeGroup !='1' $filter order by namaGroup","kodeGroup","namaGroup","par[group]","All",$par[group],"onchange=\"document.getElementById('form').submit();\"","310px;");$text.="&nbsp;&nbsp;";
  342. if(isset($menuAccess[$s]["add"])) $text.="<a href=\"#Add\" class=\"btn btn1 btn_document\" onclick=\"openBox('popup.php?par[mode]=add".getPar($par,"mode,username")."',825,550);\"><span>Add Data</span></a>";
  343. $text.="</div>
  344.  
  345. </form>
  346.  
  347. <br clear=\"all\" />
  348.  
  349. <table cellpadding=\"0\" cellspacing=\"0\" border=\"0\" class=\"stdtable stdtablequick\" id=\"dataList\">
  350.  
  351. <thead>
  352.  
  353. <tr>
  354. <th width=\"20\">No.</th>
  355. <th width=\"50\">Photo</th>
  356. <th>Real Name</th>
  357. <th width=\"150\">Username</th>
  358. <th width=\"250\">Level 3</th>
  359. <th width=\"125\">Last Login</th>
  360. <th width=\"50\">Status</th>";
  361. if(isset($menuAccess[$s]["edit"]) || isset($menuAccess[$s]["delete"])) $text.="<th width=\"50\">Kontrol</th>";
  362. $text.="</tr>
  363.  
  364. </thead>
  365.  
  366. <tbody></tbody>
  367.  
  368. </table>
  369.  
  370. </div>";
  371.  
  372. return $text;
  373.  
  374. }
  375.  
  376.  
  377.  
  378. function lData(){
  379.  
  380. global $s,$par,$fFile,$menuAccess,$cUsername,$sUser,$sGroup,$arrTitle;
  381. // global $s,$inp,$par,$arrTitle,$fFile,$menuAccess,$cUsername,$sUser;
  382.  
  383. if (isset($_GET['iDisplayStart']) && $_GET['iDisplayLength'] != '-1')
  384.  
  385. $sLimit = "limit ".intval($_GET['iDisplayStart']).", ".intval($_GET['iDisplayLength']);
  386.  
  387.  
  388.  
  389. $sWhere= " where t1.jenisUser = '1'";
  390.  
  391. if (!empty($_GET['fSearch']))
  392.  
  393. $sWhere.= " and (
  394.  
  395. lower(t1.username) like '%".mysql_real_escape_string(strtolower($_GET['fSearch']))."%'
  396.  
  397. or lower(t1.namaUser) like '%".mysql_real_escape_string(strtolower($_GET['fSearch']))."%'
  398.  
  399. or lower(t2.namaGroup) like '%".mysql_real_escape_string(strtolower($_GET['fSearch']))."%'
  400.  
  401. )";
  402.  
  403. if(!empty($par[group])) $sWhere.=" and t1.kodeGroup='$par[group]'";
  404.  
  405. if ($cUsername != $sUser) $sWhere.= " and t1.username != '$sUser' ";
  406.  
  407.  
  408.  
  409. $arrOrder = array(
  410.  
  411. "t1.namaUser",
  412.  
  413. "t1.username",
  414.  
  415. "t1.namaDokumen",
  416.  
  417. "t2.namaData",
  418.  
  419. );
  420.  
  421.  
  422.  
  423. $orderBy = $arrOrder["".$_GET[iSortCol_0].""]." ".$_GET[sSortDir_0];
  424.  
  425. $sql="select * from app_user t1 join app_group t2 on (t1.kodeGroup=t2.kodeGroup) $sWhere order by t1.username $sLimit";
  426. // $sql="select * from mt_dokumen t1 join mst_data t2 on (t1.idBagian=t2.kodeData) $sWhere order by $orderBy $sLimit";
  427.  
  428. $res=db($sql);
  429.  
  430.  
  431.  
  432. $json = array(
  433.  
  434. "iTotalRecords" => mysql_num_rows($res),
  435.  
  436. "iTotalDisplayRecords" => getField("select count(*) from app_user t1 join app_group t2 on (t1.kodeGroup=t2.kodeGroup) $sWhere"),
  437. // app_user t1 join app_group t2 on (t1.kodeGroup=t2.kodeGroup) $sWhere order by t1.username $sLimit
  438.  
  439. "aaData" => array(),
  440.  
  441. );
  442.  
  443.  
  444.  
  445. $no=intval($_GET['iDisplayStart']);
  446.  
  447. while($r=mysql_fetch_array($res)){
  448.  
  449. $no++;
  450.  
  451.  
  452.  
  453. $statusUser = $r[statusUser] == "t"?
  454. "<img src=\"styles/images/t.png\" title='Active'>":
  455. "<img src=\"styles/images/f.png\" title='Not Active'>";
  456.  
  457. if($r[loginUser] == "0000-00-00 00:00:00") $r[loginUser] = "";
  458. list($tanggalLogin, $waktuLogin) = explode(" ",$r[loginUser]);
  459. $spacing = empty($r[loginUser]) ? "-" : "@";
  460.  
  461.  
  462.  
  463. $controlDokumen = "";
  464.  
  465. if(!empty($r[fotoUser])) {
  466. $foto ="<img src=\"".$fFile."".$r[fotoUser]."\" height=\"25\" style=\"padding-right:5px; padding-bottom:5px;\"> ";
  467. }else{
  468. $foto = "";
  469. }
  470.  
  471. if(isset($menuAccess[$s]["edit"]))
  472.  
  473. $controlDokumen.= "<a href=\"#Edit\" title=\"Edit Data\" class=\"edit\" onclick=\"openBox('popup.php?par[mode]=edit&par[username]=$r[username]".getPar($par,"mode,username")."',825,500);\"><span>Edit</span></a>";
  474.  
  475.  
  476.  
  477. if(isset($menuAccess[$s]["delete"]))
  478.  
  479. // $controlDokumen.= "<a href=\"#Delete\" onclick=\"del('$r[username]','".getPar($par,"mode,username")."')\" title=\"Delete Data\" class=\"delete\"><span>Delete</span></a>";
  480.  
  481. $controlDokumen.= "<a href=\"?par[mode]=del&par[username]=$r[username]".getPar($par,"mode,username")."\" onclick=\"return confirm('anda yakin akan menghapus data ini ?')\" title=\"Delete Data\" class=\"delete\"><span>Delete</span></a>";
  482.  
  483.  
  484.  
  485. // $fileDokumen = empty($r[fileDokumen]) ? "" : "<a href=\"#\" onclick=\"openBox('view.php?doc=mt_dokumen&id=$r[idDokumen]',850,500);\"><img src=\"".getIcon($r[fileDokumen])."\"></a>";
  486.  
  487.  
  488.  
  489. $data=array(
  490.  
  491. "<div align=\"center\">".$no.".</div>",
  492.  
  493. "<div align=\"left\">$foto</div>",
  494.  
  495. "<div align=\"left\">$r[namaUser]</div>",
  496.  
  497. "<div align=\"left\">$r[username]</div>",
  498.  
  499. "<div align=\"left\">$r[namaGroup]</div>",
  500.  
  501. "<div align=\"center\">".getTanggal($tanggalLogin)." ".$spacing." ".substr($waktuLogin,0,5)."</div>",
  502.  
  503. "<div align=\"center\">".$statusUser."</div>",
  504.  
  505. "<div align=\"center\">".$controlDokumen."</div>",
  506.  
  507. );
  508.  
  509.  
  510.  
  511.  
  512.  
  513. $json['aaData'][]=$data;
  514.  
  515. }
  516.  
  517. return json_encode($json);
  518.  
  519. }
  520.  
  521. function pegawai(){
  522. global $s,$db,$inp,$par,$arrTitle,$arrParam,$arrParameter,$menuAccess;
  523. $text.="<div class=\"centercontent contentpopup\">
  524. <div class=\"pageheader\">
  525. <h1 class=\"pagetitle\">Daftar Pegawai</h1>
  526. ".getBread()."
  527.  
  528. </div>
  529. <div id=\"contentwrapper\" class=\"contentwrapper\">
  530. <form action=\"\" method=\"post\" class=\"stdform\">
  531. <div id=\"pos_l\" style=\"float:left;\">
  532. <table>
  533. <tr>
  534. <td>Search : </td>
  535. <td>".comboArray("par[search]", array("All", "Nama", "NIK"), $par[search])."</td>
  536. <td><input type=\"text\" id=\"par[filter]\" name=\"par[filter]\" style=\"width:250px;\" value=\"$par[filter]\" class=\"mediuminput\" /></td>
  537. <td>
  538. <input type=\"hidden\" id=\"par[mode]\" name=\"par[mode]\" value=\"$par[mode]\" />
  539. <input type=\"submit\" value=\"GO\" class=\"btn btn_search btn-small\" />
  540. </td>
  541. </tr>
  542. </table>
  543. </div>
  544. </form>
  545. <br clear=\"all\" />
  546. <table cellpadding=\"0\" cellspacing=\"0\" border=\"0\" class=\"stdtable stdtablequick\" id=\"dyntable\">
  547. <thead>
  548. <tr>
  549. <th width=\"20\">No.</th>
  550. <th style=\"min-width:100px;\">NIK</th>
  551. <th style=\"min-width:400px;\">Nama</th>
  552. <th style=\"max-width:50px;\">Kontrol</th>
  553. </tr>
  554. </thead>
  555. <tbody>";
  556.  
  557. $filter = "where reg_no is not null";
  558.  
  559. if($par[search] == "Nama")
  560. $filter.= " and lower(name) like '%".strtolower($par[filter])."%'";
  561. else if($par[search] == "NIK")
  562. $filter.= " and lower(reg_no) like '%".strtolower($par[filter])."%'";
  563. else
  564. $filter.= " and (
  565. lower(name) like '%".strtolower($par[filter])."%'
  566. or lower(reg_no) like '%".strtolower($par[filter])."%'
  567. )";
  568.  
  569. $sql="select * from emp $filter order by name";
  570. $res=db($sql);
  571. while($r=mysql_fetch_array($res)){
  572. $no++;
  573.  
  574. $text.="<tr>
  575. <td>$no.</td>
  576. <td>$r[reg_no]</td>
  577. <td>".strtoupper($r[name])."</td>
  578. <td align=\"center\">
  579. <a href=\"#\" title=\"Pilih Data\" class=\"check\" onclick=\"setPegawai('".$r[reg_no]."', '".getPar($par, "mode, nikPegawai")."')\"><span>Detail</span></a>
  580. </td>
  581. </tr>";
  582. }
  583.  
  584. $text.="</tbody>
  585. </table>
  586. </div>
  587. </div>";
  588. return $text;
  589. }
  590.  
  591. function getContent($par){
  592. global $s,$_submit,$menuAccess;
  593. switch($par[mode]){
  594. case "cek":
  595. $text = cek();
  596. break;
  597. case "lst":
  598.  
  599. $text=lData();
  600.  
  601. break;
  602.  
  603. case "get":
  604. $text = gPegawai();
  605. break;
  606. case "peg":
  607. $text = pegawai();
  608. break;
  609. case "pas":
  610. if(isset($menuAccess[$s]["edit"])) $text = empty($_submit) ? formPas() : ubahPas(); else $text = lihat();
  611. break;
  612. case "delPic":
  613. if(isset($menuAccess[$s]["edit"])) $text = hapusPic(); else $text = lihat();
  614. break;
  615. case "del":
  616. if(isset($menuAccess[$s]["delete"])) $text = hapus(); else $text = lihat();
  617. break;
  618. case "edit":
  619. if(isset($menuAccess[$s]["edit"])) $text = empty($_submit) ? form() : ubah(); else $text = lihat();
  620. break;
  621. case "add":
  622. if(isset($menuAccess[$s]["add"])) $text = empty($_submit) ? form() : tambah(); else $text = lihat();
  623. break;
  624. default:
  625. $text = lihat();
  626. break;
  627. }
  628. return $text;
  629. }
  630. ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement