API tools faq
paste
Advertisement
Guest User

Untitled

a guest
Jul 17th, 2019
134
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 40.70 KB | None | 0 0
raw download clone embed print report
  1. <?php
  2. require_once($obj.".html.php");
  3. $task=$_REQUEST['task'];
  4.  
  5. class REQUEST_APPROVAL extends REQUEST_APPROVAL_HTML
  6. {
  7.  
  8. function fn_uploaddoc()
  9. {
  10. global $mycn;
  11. $filename=$_FILES['txt_file']['name'];
  12. $filetmp=$_FILES['txt_file']['tmp_name'];
  13. $filesize=$_FILES['txt_file']['size'];
  14. $filetype=$_FILES['txt_file']['type'];
  15.  
  16. //echo $filename.$filetype.$title.$partnership.$contractvalue.$tglstart;
  17. if($_FILES['txt_file']['type']!=="application/pdf")
  18. {
  19. echo "<div class=\"callout callout-danger lead\">
  20. <h4>Alert!</h4>
  21. <p>
  22. Please attach file in PDF Format !!!.&nbsp;<a href=\"index.php?opt=obj_request_approval\">Back</a>
  23. </p>
  24. </div>";
  25. exit;
  26. }
  27.  
  28. if($_FILES['txt_file']['size']>0)
  29. {
  30. if($_FILES['txt_file']['size']<=21000000)
  31. {
  32. $filename=$_FILES['txt_file']['name'];
  33. $filetmp=$_FILES['txt_file']['tmp_name'];
  34. $filesize=$_FILES['txt_file']['size'];
  35. $filetype=$_FILES['txt_file']['type'];
  36.  
  37. $legal_doc_type=$_POST['cbolegaldoctype'];
  38. $docno=$_POST['txtdocno'];
  39. $doc_type=$_POST['chkdoctype'];
  40. for($i=0;$i<=count($doc_type)-1;++$i)
  41. {
  42. $str_doc_type.=$doc_type[$i].",";
  43. }
  44. $str_doc_type=substr($str_doc_type,0,strlen($str_doc_type)-1);
  45.  
  46. $title=$_POST['txt_title'];
  47. $partnership=$_POST['txt_partnership'];
  48. $contractvalue=$_POST['txt_contractvalue'];
  49. $docperiode=$_POST['txt_doc_periode'];
  50. $docperiodetype=$_POST['cbo_doc_periode_type'];
  51. $businessuser=$_POST['cbobusinessuser'];
  52. $data_mitra=$_POST['txtidmitra'];
  53. $data_mitra=$_POST['txtother'];
  54. $tglstart=$_POST['datepicker'];
  55. $tglend=$_POST['datepicker2'];
  56.  
  57. //echo $filename.$filetype;
  58. $rec=date("Ymdhi");
  59.  
  60. $prenodin=$rec."_lampiran.pdf";
  61. $destination_upload="doc_upload/";
  62. $target_path = $destination_upload.basename($_FILES['txt_file']['name']);
  63. $target_path2 = $destination_contract.basename($_FILES['txt_doc_contract']['name']);
  64.  
  65. if(is_uploaded_file($_FILES['txt_file']['tmp_name']))
  66. {
  67. if(move_uploaded_file($_FILES['txt_file']['tmp_name'],$target_path))
  68. {
  69.  
  70. $msg = "Your file has been uploaded successfully.";
  71. rename($destination_upload."".$filename."", $destination_upload."".$prenodin."");
  72. //rename($destination_contract."".$contractname."", $destination_contract."".$preform."");
  73.  
  74. $result=1;
  75.  
  76. }else
  77. {
  78. $msg=$_FILES['txt_file']['name']."Dokumen Lampiran dan Kontrak Gagal di Upload.".$target_path;
  79. }
  80. }
  81.  
  82. if(!get_magic_quotes_gpc())
  83. {
  84. $filename=addslashes($filename);
  85. }
  86. $qry="insert into tbl_document_new set no_doc='$docno',nik='".$_SESSION['usernik']."',legal_doc_type='".$legal_doc_type."',doc_type='".$str_doc_type."',
  87. doc_type_datamitra='$data_mitra',title='".$title."',partnership='".$partnership."',contractvalue=".$contractvalue.",doc_periode='".$docperiode."',
  88. doc_periode_type='".$docperiodetype."',doc_filename='".$filename."',doc_filetype='".$filetype."',";
  89. $qry.=" doc_filesize=".$filesize.",doc_filecontent='".$prenodin."',";
  90. $qry.="doc_filenamecontract='".$contractname."',startdate='".$tglstart."',enddate='".$tglend."',doc_filecontract='".$businessuser."',"; //tambahan 2 dokumen
  91. $qry.=" status=-1,iby='".$_SESSION['usernik']."',idt='".date("Y-m-d H:i:s")."',periode=".date("Y");
  92.  
  93. //echo $qry."<br>";
  94. if(mysql_query($qry))
  95. {
  96. $id_doc=mysql_insert_id();
  97. //#################
  98. $approval=array();$lastapproval='';$j=0;
  99. for($i=1;$i<=8;$i++)
  100. {
  101. if($i==1)
  102. {$sta=2;}else{$sta=1;}
  103. $qry='';
  104. $approval[$i]=$_REQUEST['cboapproval'.$i];
  105. if($approval[$i])
  106. {
  107. $qry="insert into tbl_document_approval_new set id_doc=$id_doc,nik='$approval[$i]',status=".$sta.",periode='".date("Y")."',
  108. iby='".$_SESSION['usernik']."',idt='".date("Y-m-d H:i:s")."'";
  109. }
  110. else
  111. {
  112. $j=$i-1;
  113. $lastapproval=$approval[$j];
  114. $qry="update tbl_document_approval_new set status=1,date_approve='".date("Y-m-d H:i:s")."',
  115. uby='".$_SESSION['usernik']."',udt='".date("Y-m-d H:i:s")."'
  116. where id_doc=$id_doc and nik='$lastapproval'";//modified set status=2
  117. }
  118. if($qry!==''){mysql_query($qry) or die(mysql_error());}
  119. //echo $qry."PHASE 1";
  120. //echo $qry."<br>";
  121.  
  122. }
  123. //############################
  124. if($lastapproval!=='')
  125. {
  126. $qry="update tbl_document_new set status=2,uby='".$_SESSION['usernik']."',udt='".date("Y-m-d H:i:s")."' where id_doc=$id_doc";
  127. if(mysql_query($qry))
  128. {
  129. $qry="insert into tbl_document_log_new set tglupdate='".date("Y-m-d H:i:s")."',status_doc_by='".$_SESSION['usernik']."',
  130. id_status_doc=0,status_doc='Submit By User',remark='".$remark."',
  131. id_doc=$id_doc";
  132. }
  133. else
  134. {die(mysql_error());}
  135. }
  136. else
  137. {
  138. $qry="insert into tbl_document_log_new set tglupdate='".date("Y-m-d H:i:s")."',status_doc_by='".$_SESSION['usernik']."',
  139. id_status_doc=1,status_doc='Accepted By Legal',remark='".$remark."',
  140. id_doc=$id_doc";
  141. $qry="insert into tbl_document_log_new set tglupdate='".date("Y-m-d H:i:s")."',status_doc_by='".$_SESSION['usernik']."',
  142. id_status_doc=1,status_doc='Legal Document Need Approval',remark='Need Approve ASAP',
  143. id_doc=$id_doc";
  144.  
  145. }
  146. //####################
  147. // ============== Update log last approval ==##############
  148. //$qry="insert into tbl_document_log_new set tglupdate='".date("Y-m-d H:i:s")."',status_doc_by='".$_SESSION['usernik']."',
  149. // id_status_doc=1,status_doc='Legal Document Need Approval',remark='Need Approve ASAP',
  150. // id_doc=$id_doc";
  151. //echo $qry."<br>";
  152. if(mysql_query($qry))
  153. {
  154. REQUEST_APPROVAL_HTML::fn_viewdoc($id_doc);
  155. }
  156. }
  157. else
  158. {die(mysql_error());}
  159. }
  160. else
  161. {
  162. echo "<div class=\"callout callout-danger lead\">
  163. <h4>Alert!</h4>
  164. <p>
  165. Your File is too large <b>Max 20.5 MB</b>.&nbsp;
  166. <a href=\"index.php?opt=obj_request_approval\">Back</a>
  167. </p>
  168. </div>
  169. ";
  170. }
  171. }
  172. else
  173. {
  174. echo "<div class=\"callout callout-danger lead\">
  175. <h4>Alert!</h4>
  176. <p>
  177. Your File is too small <b>Max 2.5 MB</b>.&nbsp;
  178. <a href=\"index.php?opt=obj_request_approval\">Back</a>
  179. </p>
  180. </div>
  181. ";
  182. }
  183. }
  184.  
  185. function fn_updatedetail()
  186. {
  187. global $mycn;
  188. //if($_FILES['txt_file']['size']<=2100000)
  189. // {
  190.  
  191. $legal_doc_type=$_POST['cbolegaldoctype'];
  192. $docno=$_POST['txtdocno'];
  193. $doc_type=$_POST['chkdoctype'];
  194. for($i=0;$i<=count($doc_type)-1;++$i)
  195. {
  196. $str_doc_type.=$doc_type[$i].",";
  197. }
  198. $str_doc_type=substr($str_doc_type,0,strlen($str_doc_type)-1);
  199.  
  200. $id_doc=$_POST['txt_iddoc'];
  201. $title=$_POST['txt_title'];
  202. $partnership=$_POST['txt_partnership'];
  203. $contractvalue=$_POST['txt_contractvalue'];
  204. $docperiode=$_POST['txt_doc_periode'];
  205. $docperiodetype=$_POST['cbo_doc_periode_type'];
  206. $businessuser=$_POST['cbobusinessuser'];
  207. //$data_mitra=$_POST['txtidmitra'];
  208. $data_mitra=$_POST['txtother'];
  209. $tglstart=$_POST['datepick'];
  210. $tglend=$_POST['datepick2'];
  211. //echo "00#".$doc_type."#".$id_doc."1#".$title."2#".$partnership."3#".$contractvalue."4#".$businessuser."5#".$tglstart."6#".$tglend."7#".$str_doc_type;
  212. /*$qry="select * from tbl_document_new where id_doc='$docno' ";
  213. echo $qry;
  214. $rs=mysql_query($qry);
  215. $rw=mysql_fetch_object($rs);
  216. $nodinold=$rw->filecontent;*/
  217.  
  218. $rec=date("Ymdhi");
  219.  
  220. $prenodin=$rec."_lampiran.pdf";
  221.  
  222. $destination_upload="doc_upload/";
  223.  
  224. $target_path = $destination_upload.basename($_FILES['txt_file']['name']);
  225.  
  226. if(!get_magic_quotes_gpc())
  227. {
  228. $filename=addslashes($filename);
  229. }
  230.  
  231. $qry="update tbl_document_new set nik='".$_SESSION['usernik']."',legal_doc_type='".$legal_doc_type."',doc_type='".$str_doc_type."',
  232. doc_type_datamitra='$data_mitra',title='".$title."',partnership='".$partnership."',contractvalue=".$contractvalue.",doc_periode='".$docperiode."',
  233. doc_periode_type='".$docperiodetype."',";
  234. //$qry.=" doc_filesize=".$filesize.",doc_filecontent='".$prenodin."',";
  235. $qry.="startdate='".$tglstart."',enddate='".$tglend."',doc_filecontract='".$businessuser."',"; //tambahan 2 dokumen##doc_filenamecontract='".$contractname."',
  236. $qry.=" uby='".$_SESSION['usernik']."',udt='".date("Y-m-d H:i:s")."' where id_doc='$id_doc' and isdeleted=0";//status=-1,
  237. //echo $qry;
  238. if(mysql_query($qry))
  239. {
  240. echo "<div class=\"callout callout-info lead\">
  241. <h4>Alert!</h4>
  242. <p>
  243. Update Detail Submit Document Successfull !!!.&nbsp;<a href=\"index.php?opt=obj_request_approval\">Back</a>
  244. </p>
  245. </div>";
  246. ?>
  247. <!--<meta http-equiv="refresh" content="5;URL='index.php?opt=obj_request_approval'">-->
  248. <?php
  249.  
  250. }
  251. else
  252. {die(mysql_error());}
  253. //}
  254. // else
  255. // {
  256. // echo "<div class=\"callout callout-danger lead\">
  257. // <h4>Reminder!</h4>
  258. // <p>
  259. // Your File is too large <b>Max 2.5 MB</b>.&nbsp;
  260. // <a href=\"index.php?opt=obj_request_approval\">Back</a>
  261. // </p>
  262. // </div>
  263. // ";
  264. // }
  265. }
  266.  
  267. function fn_canceldoc()
  268. {
  269. global $mycn;
  270. //echo "MASUK SINI";
  271. //$id_doc=$_GET['id_doc'];
  272. $id_doc=$_POST['id_doc'];
  273. $qry="select doc_filecontent from tbl_document_new where id_doc=$id_doc";
  274. //echo $qry."<br>".$id_doc;
  275. $rsfile=mysql_query($qry);//,$mycn
  276. $rwfile=mysql_fetch_object($rsfile);
  277. $oldfile=$rwfile->doc_filecontent;
  278. $destination_upload="doc_upload/";
  279.  
  280. $qry="update tbl_document_approval_new set isdeleted=1 where id_doc=$id_doc";
  281. if(mysql_query($qry))//,$mycn
  282. {
  283. $qry="update tbl_document_new set isdeleted=1 where id_doc=$id_doc";
  284. //echo $qry;
  285. if(mysql_query($qry))//,$mycn
  286. {
  287. $qry="update tbl_document_log_new set isdeleted=1 where id_doc=$id_doc";
  288. if(mysql_query($qry))//,$mycn
  289. {
  290. unlink($destination_upload."".$oldfile."");
  291. //echo $destination_upload.$oldfile;
  292. ?>
  293. <div class="box">
  294. <div class="box-header">
  295. <h3 class="box-title">Cancel Submit Document</h3>
  296. </div>
  297. <div class="box-body">
  298. <!--<p>Normal split buttons:</p>
  299.  
  300. <div class="margin">
  301. <div class="btn-group">
  302. <button type="button" class="btn btn-default">Action</button>
  303. <button type="button" class="btn btn-default dropdown-toggle" data-toggle="dropdown">
  304. <span class="caret"></span>
  305. <span class="sr-only">Toggle Dropdown</span>
  306. </button>
  307. <ul class="dropdown-menu" role="menu">
  308. <li><a href="#">Action</a></li>
  309. <li><a href="#">Another action</a></li>
  310. <li><a href="#">Something else here</a></li>
  311. <li class="divider"></li>
  312. <li><a href="#">Separated link</a></li>
  313. </ul>
  314. </div>
  315. <div class="btn-group">
  316. <button type="button" class="btn btn-info">Action</button>
  317. <button type="button" class="btn btn-info dropdown-toggle" data-toggle="dropdown">
  318. <span class="caret"></span>
  319. <span class="sr-only">Toggle Dropdown</span>
  320. </button>
  321. <ul class="dropdown-menu" role="menu">
  322. <li><a href="#">Action</a></li>
  323. <li><a href="#">Another action</a></li>
  324. <li><a href="#">Something else here</a></li>
  325. <li class="divider"></li>
  326. <li><a href="#">Separated link</a></li>
  327. </ul>
  328. </div>
  329. <div class="btn-group">
  330. <button type="button" class="btn btn-danger">Action</button>
  331. <button type="button" class="btn btn-danger dropdown-toggle" data-toggle="dropdown">
  332. <span class="caret"></span>
  333. <span class="sr-only">Toggle Dropdown</span>
  334. </button>
  335. <ul class="dropdown-menu" role="menu">
  336. <li><a href="#">Action</a></li>
  337. <li><a href="#">Another action</a></li>
  338. <li><a href="#">Something else here</a></li>
  339. <li class="divider"></li>
  340. <li><a href="#">Separated link</a></li>
  341. </ul>
  342. </div>
  343. <div class="btn-group">
  344. <button type="button" class="btn btn-success">Action</button>
  345. <button type="button" class="btn btn-success dropdown-toggle" data-toggle="dropdown">
  346. <span class="caret"></span>
  347. <span class="sr-only">Toggle Dropdown</span>
  348. </button>
  349. <ul class="dropdown-menu" role="menu">
  350. <li><a href="#">Action</a></li>
  351. <li><a href="#">Another action</a></li>
  352. <li><a href="#">Something else here</a></li>
  353. <li class="divider"></li>
  354. <li><a href="#">Separated link</a></li>
  355. </ul>
  356. </div>
  357. <div class="btn-group">
  358. <button type="button" class="btn btn-warning">Action</button>
  359. <button type="button" class="btn btn-warning dropdown-toggle" data-toggle="dropdown">
  360. <span class="caret"></span>
  361. <span class="sr-only">Toggle Dropdown</span>
  362. </button>
  363. <ul class="dropdown-menu" role="menu">
  364. <li><a href="#">Action</a></li>
  365. <li><a href="#">Another action</a></li>
  366. <li><a href="#">Something else here</a></li>
  367. <li class="divider"></li>
  368. <li><a href="#">Separated link</a></li>
  369. </ul>
  370. </div>
  371. </div>-->
  372. <p>Document Approval Succesfull Removed</p>
  373. <a href="index.php?opt=obj_request_approval">
  374. <button type="button" class="btn btn-success">Back&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</button>
  375. </a>
  376. <!--<div class="margin">
  377. <div class="btn-group">
  378. <button type="button" class="btn btn-default btn-flat">Action</button>
  379. <button type="button" class="btn btn-default btn-flat dropdown-toggle" data-toggle="dropdown">
  380. <span class="caret"></span>
  381. <span class="sr-only">Toggle Dropdown</span>
  382. </button>
  383. <ul class="dropdown-menu" role="menu">
  384. <li><a href="#">Action</a></li>
  385. <li><a href="#">Another action</a></li>
  386. <li><a href="#">Something else here</a></li>
  387. <li class="divider"></li>
  388. <li><a href="#">Separated link</a></li>
  389. </ul>
  390. </div>
  391. <div class="btn-group">
  392. <button type="button" class="btn btn-info btn-flat">Action</button>
  393. <button type="button" class="btn btn-info btn-flat dropdown-toggle" data-toggle="dropdown">
  394. <span class="caret"></span>
  395. <span class="sr-only">Toggle Dropdown</span>
  396. </button>
  397. <ul class="dropdown-menu" role="menu">
  398. <li><a href="#">Action</a></li>
  399. <li><a href="#">Another action</a></li>
  400. <li><a href="#">Something else here</a></li>
  401. <li class="divider"></li>
  402. <li><a href="#">Separated link</a></li>
  403. </ul>
  404. </div>
  405. <div class="btn-group">
  406. <button type="button" class="btn btn-danger btn-flat">Action</button>
  407. <button type="button" class="btn btn-danger btn-flat dropdown-toggle" data-toggle="dropdown">
  408. <span class="caret"></span>
  409. <span class="sr-only">Toggle Dropdown</span>
  410. </button>
  411. <ul class="dropdown-menu" role="menu">
  412. <li><a href="#">Action</a></li>
  413. <li><a href="#">Another action</a></li>
  414. <li><a href="#">Something else here</a></li>
  415. <li class="divider"></li>
  416. <li><a href="#">Separated link</a></li>
  417. </ul>
  418. </div>
  419. <div class="btn-group">
  420. <button type="button" class="btn btn-success btn-flat">Action</button>
  421. <button type="button" class="btn btn-success btn-flat dropdown-toggle" data-toggle="dropdown">
  422. <span class="caret"></span>
  423. <span class="sr-only">Toggle Dropdown</span>
  424. </button>
  425. <ul class="dropdown-menu" role="menu">
  426. <li><a href="#">Action</a></li>
  427. <li><a href="#">Another action</a></li>
  428. <li><a href="#">Something else here</a></li>
  429. <li class="divider"></li>
  430. <li><a href="#">Separated link</a></li>
  431. </ul>
  432. </div>
  433. <div class="btn-group">
  434. <button type="button" class="btn btn-warning btn-flat">Action</button>
  435. <button type="button" class="btn btn-warning btn-flat dropdown-toggle" data-toggle="dropdown">
  436. <span class="caret"></span>
  437. <span class="sr-only">Toggle Dropdown</span>
  438. </button>
  439. <ul class="dropdown-menu" role="menu">
  440. <li><a href="#">Action</a></li>
  441. <li><a href="#">Another action</a></li>
  442. <li><a href="#">Something else here</a></li>
  443. <li class="divider"></li>
  444. <li><a href="#">Separated link</a></li>
  445. </ul>
  446. </div>
  447. </div>-->
  448. </div>
  449. <!-- /.box-body -->
  450. </div>
  451. <!-- end split buttons box -->
  452. <meta http-equiv="refresh" content="5;URL='index.php?opt=obj_request_approval'">
  453. <?php
  454. //REQUEST_APPROVAL_HTML::fn_page_default(1);
  455. }
  456. }
  457. else
  458. {
  459. echo "<div class=\"callout callout-warning lead\">
  460. <h4>Alert!</h4>
  461. <p>
  462. &nbsp;Cancel document id ".$id_doc." Failed please contact your admin </br>&nbsp;".ADMIN_CONTACT." <a href=\"index.php?opt=obj_request_approval\">Back</a>
  463. </p>
  464. </div>";
  465. //echo "&nbsp;Cancel document id ".$id_doc." Failed please contact your admin </br>&nbsp;".ADMIN_CONTACT;
  466. }
  467. }
  468.  
  469. }
  470.  
  471. function fn_submitdoc()
  472. {
  473. global $mycn;
  474. $cldata=new mylib();
  475.  
  476. $id_doc=$_POST['id_doc'];
  477. $remark=$_POST['remark'];
  478. $qry="update tbl_document_new set status=2,uby='".$_SESSION['usernik']."',udt='".date("Y-m-d H:i:s")."' where id_doc=$id_doc";
  479. //echo $qry."<br>";
  480. if(mysql_query($qry))
  481. {
  482. //SET FIRST APPROVAL
  483. $qry="select id from tbl_document_approval_new where id_doc='$id_doc' order by id asc limit 1";
  484. $rs1=mysql_query($qry);
  485. $rw1=mysql_fetch_object($rs1);
  486. $qry="update tbl_document_approval_new set status=2,uby='".$_SESSION['usernik']."',udt=now() where id='".$rw1->id."' and id_doc='$id_doc' and isdeleted=0";
  487. //echo $qry."<br>";
  488. mysql_query($qry);
  489.  
  490. $qry="insert into tbl_document_log_new set tglupdate='".date("Y-m-d H:i:s")."',status_doc_by='".$_SESSION['usernik']."',
  491. id_status_doc=2,status_doc='Processing Approval',remark='$remark',
  492. id_doc=$id_doc";
  493. //echo $qry."<br>";
  494. if(mysql_query($qry))
  495. {
  496. $arrmsisdn=array();
  497. //KIRIM KE LEGAL REGION
  498. $qry="select email,hp from tbl_user where nik='".$_SESSION['usernik']."' or (menu_group='LGL' and activated='Y' and id_region='".$_SESSION['userregion']."')";
  499. //echo $qry."<br>";
  500. $rsreceipent=mysql_query($qry) or die(mysql_error());
  501. if($rsreceipent)
  502. {
  503. $j=1;
  504. while($rw=mysql_fetch_object($rsreceipent))
  505. {
  506. $email[$j]=$rw->email;
  507. array_push($arrmsisdn,$rw->hp);
  508. $j+=1;
  509. }
  510. }
  511. mysql_free_result($rsreceipent);
  512. //KIRIM KE USER APPROVAL
  513. $qry="select tu.email,tu.hp
  514. from tbl_document_approval_new da
  515. inner join tbl_document_new td on td.id_doc=da.id_doc
  516. inner join tbl_user tu on tu.nik=da.nik
  517. where td.id_doc=$id_doc and tu.activated='Y'
  518. order by da.id asc limit 1";
  519. //echo $qry."<br>";
  520. $rsreceipent2=mysql_query($qry,$mycn) or die(mysql_error());
  521. if($rsreceipent2)
  522. {
  523. //$j=1;
  524. while($rw=mysql_fetch_object($rsreceipent2))
  525. {
  526. $email[$j]=$rw->email;
  527. array_push($arrmsisdn,$rw->hp);
  528. $j+=1;
  529. }
  530.  
  531. $email[$j]="aan_wahyudi_x@telkomsel.co.id";
  532. $j+=1;
  533. $email[$j]="sorpa_e_t@telkomsel.co.id";
  534. $message="FYI\n\nYou Have assignment To Approve Document : ".$_SESSION['usernik']." (".mysql_result($rsdoc,0,"emp_name").") \n";
  535. $message.="\nattachment file : ".mysql_result($rsdoc,0,"doc_filename")."\nDocument type : ".mysql_result($rsdoc,0,"type_name")."\n";
  536. $message.="Document date : ".date("Y-m-d H:i:s");
  537. $message.="\n\n <<< Legal Documentation System Tool : http://10.33.97.177/ladys >>>";
  538. //$message.="\n\n <<< Mobile Approve Ladys Tools : http://10.33.97.172/ldc/mldc/ >>>";
  539. //$message.="\n\n Note : attachment file will be automatically deleted 2 x 24 hours if not verification";
  540. }
  541. mysql_free_result($rsreceipent2);
  542. //######## SEND SMS
  543. //$nomor_approval=$rw->hp;
  544. //$arrmsisdn2=array();
  545.  
  546. array_push($arrmsisdn,'085275373893');
  547. array_push($arrmsisdn,'0811649190');
  548.  
  549. //array_push($arrmsisdn,'0811616919');
  550. //array_push($arrmsisdn,'081380839999');
  551.  
  552.  
  553. $hp=implode(",",$arrmsisdn);
  554. //$hp2=implode(",",$arrmsisdn2);
  555.  
  556. $pesan="Legal Documentation System\n";
  557. $pesan.= "FYI\n\n NEW document ".$no_doc." Need approval uploaded at ".date("Y-m-d H:i:s")." by ".$_SESSION['username']." ( ".$_SESSION['usernik']." ) \n";
  558. //$pesan.= "Project Type: $tipe_project\n";
  559.  
  560. $cldata->sendsmsinfo($hp,$pesan);
  561. //######## BATAS SEND
  562. //echo $email[0].$email[1].$email[2];
  563. if($cldata->fn_sendEmail($message,$email,SENDER,ALIASSENDER,SUBJECT,true))
  564. {
  565. $qry="update tbl_document_new set senttolgl=1 where id_doc=$id_doc";
  566. mysql_query($qry) or die(mysql_error());
  567. }
  568. //REQUEST_APPROVAL_HTML::fn_page_default(1);
  569. echo "<div class=\"callout callout-info lead\">
  570. <h4>Alert!</h4>
  571. <p>
  572. Submit Document Successfull !!!.&nbsp;<a href=\"index.php?opt=obj_request_approval\">Back</a>
  573. </p>
  574. </div>";
  575. }
  576. }
  577. else
  578. {
  579. echo "&nbsp;Cancel document id ".$id_doc." Failed please contact your admin </br>&nbsp;".ADMIN_CONTACT;
  580. }
  581. }
  582.  
  583. function fn_updateupload()
  584. {
  585. global $mycn;
  586.  
  587. if($_FILES['txt_file']['type']!=="application/pdf")//&&$_FILES['txt_file']['type']!=="image/tiff"
  588. {
  589. //id=\"tb_legal\"
  590. echo "<div class=\"callout callout-danger lead\">
  591. <h4>Alert!</h4>
  592. <p>
  593. Please attach file in PDF Format !!!.&nbsp;<a href=\"index.php?opt=obj_request_approval\">Back</a>
  594. </p>
  595. </div>
  596. ";
  597. exit;
  598. }
  599.  
  600. if($_FILES['txt_file']['size']>0)
  601. {
  602. if($_FILES['txt_file']['size']<=21000000)
  603. {
  604.  
  605. $filename=$_FILES['txt_file']['name'];
  606. $filetmp=$_FILES['txt_file']['tmp_name'];
  607. $filesize=$_FILES['txt_file']['size'];
  608. $filetype=$_FILES['txt_file']['type'];
  609.  
  610. $docno=$_POST['txt_iddoc'];
  611.  
  612. $qry="select * from tbl_document_new where id_doc='$docno' ";
  613. //echo $qry;
  614. $rs=mysql_query($qry);
  615. $rw=mysql_fetch_object($rs);
  616. $nodinold=$rw->filecontent;
  617.  
  618. $rec=date("Ymdhi");
  619.  
  620. $prenodin=$rec."_lampiran.pdf";
  621. $destination_upload="doc_upload/";
  622. $target_path = $destination_upload.basename($_FILES['txt_file']['name']);
  623.  
  624. if(is_uploaded_file($_FILES['txt_file']['tmp_name'])) //&& is_uploaded_file($_FILES['txt_doc_contract']['tmp_name'])
  625. {
  626. if(move_uploaded_file($_FILES['txt_file']['tmp_name'],$target_path))// && move_uploaded_file($_FILES['txt_doc_contract']['tmp_name'],$target_path2)
  627. {
  628.  
  629. unlink($destination_upload."".$nodinold."");
  630. $msg = "<div class=\"callout callout-info lead\">
  631. <h4>Alert!</h4>
  632. <p>
  633. Your file has been updated successfully.
  634. </p>
  635. </div>";
  636. rename($destination_upload."".$filename."", $destination_upload."".$prenodin."");
  637. $result=1;
  638.  
  639. }else
  640. {
  641. $msg=$_FILES['txt_file']['name']." Dokumen Lampiran Gagal di Update.";
  642. }
  643. }
  644.  
  645. if(!get_magic_quotes_gpc())
  646. {
  647. $filename=addslashes($filename);
  648. }
  649. $qry="update tbl_document_new set doc_filename='$filename',doc_filetype='$filetype',doc_filesize='$filesize',
  650. doc_filecontent='$prenodin',status=-3,uby='".$_SESSION['usernik']."',udt=now() where id_doc='$docno' and isdeleted=0";
  651. //echo $qry."<br>";
  652. if(mysql_query($qry) or die(mysql_error()))
  653. {
  654. /*$qry="select id from tbl_document_approval_new where id_doc='$docno' order by id asc limit 1";
  655. $rs=mysql_query($qry);
  656. $rw=mysql_fetch_object($rs);
  657. $qry="update tbl_document_approval_new set status=2,uby='".$_SESSION['usernik']."',udt=now() where id='".$rw->id."' and id_doc='$docno' and isdeleted=0";*/
  658. //echo $qry."<br>";
  659. if(mysql_query($qry) or die(mysql_error()))
  660. {
  661. $qry="insert into tbl_document_log_new set tglupdate='".date("Y-m-d H:i:s")."',status_doc_by='".$_SESSION['nik']."',
  662. id_status_doc=-3,status_doc='Resubmit Return Document',remark='After Rejected',
  663. id_doc=$docno";
  664. mysql_query($qry);
  665. REQUEST_APPROVAL_HTML::fn_viewdoc($docno);
  666. }
  667. //echo $msg;//."<br>".$qry."<br>".$_POST['cbolemari']."ALL".$id_doc;
  668. ?>
  669. <!--<meta http-equiv="refresh" content="5;URL='index.php?opt=obj_request_approval'">-->
  670. <?php
  671.  
  672. }
  673. else
  674. {die(mysql_error());}
  675. }
  676. else
  677. {
  678. echo "<div class=\"callout callout-danger lead\">
  679. <h4>Reminder!</h4>
  680. <p>
  681. Your File is too large <b>Max 21.5 MB</b>.&nbsp;
  682. <a href=\"index.php?opt=obj_request_approval\">Back</a>
  683. </p>
  684. </div>
  685. ";
  686. }
  687. }
  688. else
  689. {
  690. echo "<div class=\"callout callout-danger lead\">
  691. <h4>Alert!</h4>
  692. <p>
  693. Your File is <b>0 Size</b>.&nbsp;
  694. <a href=\"index.php?opt=obj_request_approval\">Back</a>
  695. </p>
  696. </div>
  697. ";
  698. }
  699. }
  700.  
  701. function fn_resendtolegal()
  702. {
  703. global $mycn;
  704. $cldata=new cldata();
  705. $id_doc=$_POST['id_doc'];
  706. $index=$_POST['ndx'];
  707. $qry="select td.*,tu.emp_name,tdt.type_name
  708. from tbl_document_new td inner join tbl_user tu on td.nik=tu.nik
  709. inner join tbl_document_type tdt on td.doc_type=tdt.id_type
  710. where td.id_doc=$id_doc";
  711. //echo $qry;
  712. $rsdoc=mysql_query($qry) or die(mysql_error());
  713. if($rsdoc)
  714. {
  715. $message="FYI\n\nYou Have assignment To Approve Document from Nik : ".$_SESSION['usernik']." (".mysql_result($rsdoc,0,"emp_name").") \n";
  716. $message.="\nattachment file : ".mysql_result($rsdoc,0,"doc_filename")."\nDocument type : ".mysql_result($rsdoc,0,"type_name")."\n";
  717. $message.="Document date : ".date("Y-m-d H:i:s");
  718. $message.="\n\n <<< Legal Document Cycle Tools : http://10.33.97.177/ladys >>> ";//Note : attachment file will be automatically deleted 2 x 24 hours if not Approved
  719. }
  720. mysql_free_result($rsdoc);
  721. $qry="select tu.email from tbl_document_approval_new da
  722. inner join tbl_document_new td on td.id_doc=da.id_doc
  723. inner join tbl_user tu on tu.nik=da.nik
  724. where td.id_doc=$id_doc and tu.activated='Y' and da.status<>3
  725. order by da.id asc limit 1";
  726. $rse=mysql_query($qry) or die(mysql_error());
  727. $rwe=mysql_fetch_object($rse);
  728. $email=array();
  729. $email[0]=$rwe->email;
  730. if($cldata->fn_sendEmail($message,$email,SENDER,ALIASSENDER,SUBJECT,true))//$cldata->fn_sendEmail($message)
  731. {
  732. $qry="update tbl_document_new set senttolgl=1 where id_doc=$id_doc";
  733. if(mysql_query($qry))
  734. {
  735. echo "Mail Sent. OK";
  736. }
  737. else
  738. {
  739. echo "<a href=\"#\" title=\"Klik disini untuk resend email\"
  740. onClick=\"confresendemail('div_emailreport".$index."','".$id_doc."',".$index.")\">
  741. Failed
  742. </a>";
  743. die(mysql_error());
  744. }
  745. }else
  746. {
  747. echo "Ups, Gak Bisa Kirim email nih".$message;
  748. }
  749. //HTML_UPLOAD::fn_page_default(1);
  750. }
  751. }
  752.  
  753. $cl=new REQUEST_APPROVAL();
  754.  
  755. switch($task)
  756. {
  757. case "viewdoc":
  758. $cl->fn_viewdoc();
  759. break;
  760.  
  761. case "viewedit":
  762. $cl->fn_viewedit();
  763. break;
  764.  
  765. case "updatedetail";
  766. $cl->fn_updatedetail();
  767. break;
  768.  
  769. case "viewupload":
  770. $cl->fn_viewupload();
  771. break;
  772.  
  773. case "updateupload";
  774. $cl->fn_updateupload();
  775. break;
  776.  
  777. case "getdocnumber";
  778. $cl->fn_getdocnumber();
  779. break;
  780.  
  781. case "uploaddoc";
  782. $cl->fn_uploaddoc();
  783. break;
  784.  
  785. case "submitdoc";
  786. $cl->fn_submitdoc();
  787. break;
  788.  
  789. case "canceldoc";
  790. $cl->fn_canceldoc();
  791. break;
  792.  
  793. case "resendtolegal";
  794. $cl->fn_resendtolegal();
  795. break;
  796. //#####
  797. case "getadn":
  798. $cl->fn_get_adn();
  799. break;
  800.  
  801. default:
  802. $cl->fn_page_default();
  803. breal;
  804. }
  805. ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!