Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?php
- require_once($obj.".html.php");
- $task=$_REQUEST['task'];
- class REQUEST_APPROVAL extends REQUEST_APPROVAL_HTML
- {
- function fn_uploaddoc()
- {
- global $mycn;
- $filename=$_FILES['txt_file']['name'];
- $filetmp=$_FILES['txt_file']['tmp_name'];
- $filesize=$_FILES['txt_file']['size'];
- $filetype=$_FILES['txt_file']['type'];
- //echo $filename.$filetype.$title.$partnership.$contractvalue.$tglstart;
- if($_FILES['txt_file']['type']!=="application/pdf")
- {
- echo "<div class=\"callout callout-danger lead\">
- <h4>Alert!</h4>
- <p>
- Please attach file in PDF Format !!!. <a href=\"index.php?opt=obj_request_approval\">Back</a>
- </p>
- </div>";
- exit;
- }
- if($_FILES['txt_file']['size']>0)
- {
- if($_FILES['txt_file']['size']<=21000000)
- {
- $filename=$_FILES['txt_file']['name'];
- $filetmp=$_FILES['txt_file']['tmp_name'];
- $filesize=$_FILES['txt_file']['size'];
- $filetype=$_FILES['txt_file']['type'];
- $legal_doc_type=$_POST['cbolegaldoctype'];
- $docno=$_POST['txtdocno'];
- $doc_type=$_POST['chkdoctype'];
- for($i=0;$i<=count($doc_type)-1;++$i)
- {
- $str_doc_type.=$doc_type[$i].",";
- }
- $str_doc_type=substr($str_doc_type,0,strlen($str_doc_type)-1);
- $title=$_POST['txt_title'];
- $partnership=$_POST['txt_partnership'];
- $contractvalue=$_POST['txt_contractvalue'];
- $docperiode=$_POST['txt_doc_periode'];
- $docperiodetype=$_POST['cbo_doc_periode_type'];
- $businessuser=$_POST['cbobusinessuser'];
- $data_mitra=$_POST['txtidmitra'];
- $data_mitra=$_POST['txtother'];
- $tglstart=$_POST['datepicker'];
- $tglend=$_POST['datepicker2'];
- //echo $filename.$filetype;
- $rec=date("Ymdhi");
- $prenodin=$rec."_lampiran.pdf";
- $destination_upload="doc_upload/";
- $target_path = $destination_upload.basename($_FILES['txt_file']['name']);
- $target_path2 = $destination_contract.basename($_FILES['txt_doc_contract']['name']);
- if(is_uploaded_file($_FILES['txt_file']['tmp_name']))
- {
- if(move_uploaded_file($_FILES['txt_file']['tmp_name'],$target_path))
- {
- $msg = "Your file has been uploaded successfully.";
- rename($destination_upload."".$filename."", $destination_upload."".$prenodin."");
- //rename($destination_contract."".$contractname."", $destination_contract."".$preform."");
- $result=1;
- }else
- {
- $msg=$_FILES['txt_file']['name']."Dokumen Lampiran dan Kontrak Gagal di Upload.".$target_path;
- }
- }
- if(!get_magic_quotes_gpc())
- {
- $filename=addslashes($filename);
- }
- $qry="insert into tbl_document_new set no_doc='$docno',nik='".$_SESSION['usernik']."',legal_doc_type='".$legal_doc_type."',doc_type='".$str_doc_type."',
- doc_type_datamitra='$data_mitra',title='".$title."',partnership='".$partnership."',contractvalue=".$contractvalue.",doc_periode='".$docperiode."',
- doc_periode_type='".$docperiodetype."',doc_filename='".$filename."',doc_filetype='".$filetype."',";
- $qry.=" doc_filesize=".$filesize.",doc_filecontent='".$prenodin."',";
- $qry.="doc_filenamecontract='".$contractname."',startdate='".$tglstart."',enddate='".$tglend."',doc_filecontract='".$businessuser."',"; //tambahan 2 dokumen
- $qry.=" status=-1,iby='".$_SESSION['usernik']."',idt='".date("Y-m-d H:i:s")."',periode=".date("Y");
- //echo $qry."<br>";
- if(mysql_query($qry))
- {
- $id_doc=mysql_insert_id();
- //#################
- $approval=array();$lastapproval='';$j=0;
- for($i=1;$i<=8;$i++)
- {
- if($i==1)
- {$sta=2;}else{$sta=1;}
- $qry='';
- $approval[$i]=$_REQUEST['cboapproval'.$i];
- if($approval[$i])
- {
- $qry="insert into tbl_document_approval_new set id_doc=$id_doc,nik='$approval[$i]',status=".$sta.",periode='".date("Y")."',
- iby='".$_SESSION['usernik']."',idt='".date("Y-m-d H:i:s")."'";
- }
- else
- {
- $j=$i-1;
- $lastapproval=$approval[$j];
- $qry="update tbl_document_approval_new set status=1,date_approve='".date("Y-m-d H:i:s")."',
- uby='".$_SESSION['usernik']."',udt='".date("Y-m-d H:i:s")."'
- where id_doc=$id_doc and nik='$lastapproval'";//modified set status=2
- }
- if($qry!==''){mysql_query($qry) or die(mysql_error());}
- //echo $qry."PHASE 1";
- //echo $qry."<br>";
- }
- //############################
- if($lastapproval!=='')
- {
- $qry="update tbl_document_new set status=2,uby='".$_SESSION['usernik']."',udt='".date("Y-m-d H:i:s")."' where id_doc=$id_doc";
- if(mysql_query($qry))
- {
- $qry="insert into tbl_document_log_new set tglupdate='".date("Y-m-d H:i:s")."',status_doc_by='".$_SESSION['usernik']."',
- id_status_doc=0,status_doc='Submit By User',remark='".$remark."',
- id_doc=$id_doc";
- }
- else
- {die(mysql_error());}
- }
- else
- {
- $qry="insert into tbl_document_log_new set tglupdate='".date("Y-m-d H:i:s")."',status_doc_by='".$_SESSION['usernik']."',
- id_status_doc=1,status_doc='Accepted By Legal',remark='".$remark."',
- id_doc=$id_doc";
- $qry="insert into tbl_document_log_new set tglupdate='".date("Y-m-d H:i:s")."',status_doc_by='".$_SESSION['usernik']."',
- id_status_doc=1,status_doc='Legal Document Need Approval',remark='Need Approve ASAP',
- id_doc=$id_doc";
- }
- //####################
- // ============== Update log last approval ==##############
- //$qry="insert into tbl_document_log_new set tglupdate='".date("Y-m-d H:i:s")."',status_doc_by='".$_SESSION['usernik']."',
- // id_status_doc=1,status_doc='Legal Document Need Approval',remark='Need Approve ASAP',
- // id_doc=$id_doc";
- //echo $qry."<br>";
- if(mysql_query($qry))
- {
- REQUEST_APPROVAL_HTML::fn_viewdoc($id_doc);
- }
- }
- else
- {die(mysql_error());}
- }
- else
- {
- echo "<div class=\"callout callout-danger lead\">
- <h4>Alert!</h4>
- <p>
- Your File is too large <b>Max 20.5 MB</b>.
- <a href=\"index.php?opt=obj_request_approval\">Back</a>
- </p>
- </div>
- ";
- }
- }
- else
- {
- echo "<div class=\"callout callout-danger lead\">
- <h4>Alert!</h4>
- <p>
- Your File is too small <b>Max 2.5 MB</b>.
- <a href=\"index.php?opt=obj_request_approval\">Back</a>
- </p>
- </div>
- ";
- }
- }
- function fn_updatedetail()
- {
- global $mycn;
- //if($_FILES['txt_file']['size']<=2100000)
- // {
- $legal_doc_type=$_POST['cbolegaldoctype'];
- $docno=$_POST['txtdocno'];
- $doc_type=$_POST['chkdoctype'];
- for($i=0;$i<=count($doc_type)-1;++$i)
- {
- $str_doc_type.=$doc_type[$i].",";
- }
- $str_doc_type=substr($str_doc_type,0,strlen($str_doc_type)-1);
- $id_doc=$_POST['txt_iddoc'];
- $title=$_POST['txt_title'];
- $partnership=$_POST['txt_partnership'];
- $contractvalue=$_POST['txt_contractvalue'];
- $docperiode=$_POST['txt_doc_periode'];
- $docperiodetype=$_POST['cbo_doc_periode_type'];
- $businessuser=$_POST['cbobusinessuser'];
- //$data_mitra=$_POST['txtidmitra'];
- $data_mitra=$_POST['txtother'];
- $tglstart=$_POST['datepick'];
- $tglend=$_POST['datepick2'];
- //echo "00#".$doc_type."#".$id_doc."1#".$title."2#".$partnership."3#".$contractvalue."4#".$businessuser."5#".$tglstart."6#".$tglend."7#".$str_doc_type;
- /*$qry="select * from tbl_document_new where id_doc='$docno' ";
- echo $qry;
- $rs=mysql_query($qry);
- $rw=mysql_fetch_object($rs);
- $nodinold=$rw->filecontent;*/
- $rec=date("Ymdhi");
- $prenodin=$rec."_lampiran.pdf";
- $destination_upload="doc_upload/";
- $target_path = $destination_upload.basename($_FILES['txt_file']['name']);
- if(!get_magic_quotes_gpc())
- {
- $filename=addslashes($filename);
- }
- $qry="update tbl_document_new set nik='".$_SESSION['usernik']."',legal_doc_type='".$legal_doc_type."',doc_type='".$str_doc_type."',
- doc_type_datamitra='$data_mitra',title='".$title."',partnership='".$partnership."',contractvalue=".$contractvalue.",doc_periode='".$docperiode."',
- doc_periode_type='".$docperiodetype."',";
- //$qry.=" doc_filesize=".$filesize.",doc_filecontent='".$prenodin."',";
- $qry.="startdate='".$tglstart."',enddate='".$tglend."',doc_filecontract='".$businessuser."',"; //tambahan 2 dokumen##doc_filenamecontract='".$contractname."',
- $qry.=" uby='".$_SESSION['usernik']."',udt='".date("Y-m-d H:i:s")."' where id_doc='$id_doc' and isdeleted=0";//status=-1,
- //echo $qry;
- if(mysql_query($qry))
- {
- echo "<div class=\"callout callout-info lead\">
- <h4>Alert!</h4>
- <p>
- Update Detail Submit Document Successfull !!!. <a href=\"index.php?opt=obj_request_approval\">Back</a>
- </p>
- </div>";
- ?>
- <!--<meta http-equiv="refresh" content="5;URL='index.php?opt=obj_request_approval'">-->
- <?php
- }
- else
- {die(mysql_error());}
- //}
- // else
- // {
- // echo "<div class=\"callout callout-danger lead\">
- // <h4>Reminder!</h4>
- // <p>
- // Your File is too large <b>Max 2.5 MB</b>.
- // <a href=\"index.php?opt=obj_request_approval\">Back</a>
- // </p>
- // </div>
- // ";
- // }
- }
- function fn_canceldoc()
- {
- global $mycn;
- //echo "MASUK SINI";
- //$id_doc=$_GET['id_doc'];
- $id_doc=$_POST['id_doc'];
- $qry="select doc_filecontent from tbl_document_new where id_doc=$id_doc";
- //echo $qry."<br>".$id_doc;
- $rsfile=mysql_query($qry);//,$mycn
- $rwfile=mysql_fetch_object($rsfile);
- $oldfile=$rwfile->doc_filecontent;
- $destination_upload="doc_upload/";
- $qry="update tbl_document_approval_new set isdeleted=1 where id_doc=$id_doc";
- if(mysql_query($qry))//,$mycn
- {
- $qry="update tbl_document_new set isdeleted=1 where id_doc=$id_doc";
- //echo $qry;
- if(mysql_query($qry))//,$mycn
- {
- $qry="update tbl_document_log_new set isdeleted=1 where id_doc=$id_doc";
- if(mysql_query($qry))//,$mycn
- {
- unlink($destination_upload."".$oldfile."");
- //echo $destination_upload.$oldfile;
- ?>
- <div class="box">
- <div class="box-header">
- <h3 class="box-title">Cancel Submit Document</h3>
- </div>
- <div class="box-body">
- <!--<p>Normal split buttons:</p>
- <div class="margin">
- <div class="btn-group">
- <button type="button" class="btn btn-default">Action</button>
- <button type="button" class="btn btn-default dropdown-toggle" data-toggle="dropdown">
- <span class="caret"></span>
- <span class="sr-only">Toggle Dropdown</span>
- </button>
- <ul class="dropdown-menu" role="menu">
- <li><a href="#">Action</a></li>
- <li><a href="#">Another action</a></li>
- <li><a href="#">Something else here</a></li>
- <li class="divider"></li>
- <li><a href="#">Separated link</a></li>
- </ul>
- </div>
- <div class="btn-group">
- <button type="button" class="btn btn-info">Action</button>
- <button type="button" class="btn btn-info dropdown-toggle" data-toggle="dropdown">
- <span class="caret"></span>
- <span class="sr-only">Toggle Dropdown</span>
- </button>
- <ul class="dropdown-menu" role="menu">
- <li><a href="#">Action</a></li>
- <li><a href="#">Another action</a></li>
- <li><a href="#">Something else here</a></li>
- <li class="divider"></li>
- <li><a href="#">Separated link</a></li>
- </ul>
- </div>
- <div class="btn-group">
- <button type="button" class="btn btn-danger">Action</button>
- <button type="button" class="btn btn-danger dropdown-toggle" data-toggle="dropdown">
- <span class="caret"></span>
- <span class="sr-only">Toggle Dropdown</span>
- </button>
- <ul class="dropdown-menu" role="menu">
- <li><a href="#">Action</a></li>
- <li><a href="#">Another action</a></li>
- <li><a href="#">Something else here</a></li>
- <li class="divider"></li>
- <li><a href="#">Separated link</a></li>
- </ul>
- </div>
- <div class="btn-group">
- <button type="button" class="btn btn-success">Action</button>
- <button type="button" class="btn btn-success dropdown-toggle" data-toggle="dropdown">
- <span class="caret"></span>
- <span class="sr-only">Toggle Dropdown</span>
- </button>
- <ul class="dropdown-menu" role="menu">
- <li><a href="#">Action</a></li>
- <li><a href="#">Another action</a></li>
- <li><a href="#">Something else here</a></li>
- <li class="divider"></li>
- <li><a href="#">Separated link</a></li>
- </ul>
- </div>
- <div class="btn-group">
- <button type="button" class="btn btn-warning">Action</button>
- <button type="button" class="btn btn-warning dropdown-toggle" data-toggle="dropdown">
- <span class="caret"></span>
- <span class="sr-only">Toggle Dropdown</span>
- </button>
- <ul class="dropdown-menu" role="menu">
- <li><a href="#">Action</a></li>
- <li><a href="#">Another action</a></li>
- <li><a href="#">Something else here</a></li>
- <li class="divider"></li>
- <li><a href="#">Separated link</a></li>
- </ul>
- </div>
- </div>-->
- <p>Document Approval Succesfull Removed</p>
- <a href="index.php?opt=obj_request_approval">
- <button type="button" class="btn btn-success">Back </button>
- </a>
- <!--<div class="margin">
- <div class="btn-group">
- <button type="button" class="btn btn-default btn-flat">Action</button>
- <button type="button" class="btn btn-default btn-flat dropdown-toggle" data-toggle="dropdown">
- <span class="caret"></span>
- <span class="sr-only">Toggle Dropdown</span>
- </button>
- <ul class="dropdown-menu" role="menu">
- <li><a href="#">Action</a></li>
- <li><a href="#">Another action</a></li>
- <li><a href="#">Something else here</a></li>
- <li class="divider"></li>
- <li><a href="#">Separated link</a></li>
- </ul>
- </div>
- <div class="btn-group">
- <button type="button" class="btn btn-info btn-flat">Action</button>
- <button type="button" class="btn btn-info btn-flat dropdown-toggle" data-toggle="dropdown">
- <span class="caret"></span>
- <span class="sr-only">Toggle Dropdown</span>
- </button>
- <ul class="dropdown-menu" role="menu">
- <li><a href="#">Action</a></li>
- <li><a href="#">Another action</a></li>
- <li><a href="#">Something else here</a></li>
- <li class="divider"></li>
- <li><a href="#">Separated link</a></li>
- </ul>
- </div>
- <div class="btn-group">
- <button type="button" class="btn btn-danger btn-flat">Action</button>
- <button type="button" class="btn btn-danger btn-flat dropdown-toggle" data-toggle="dropdown">
- <span class="caret"></span>
- <span class="sr-only">Toggle Dropdown</span>
- </button>
- <ul class="dropdown-menu" role="menu">
- <li><a href="#">Action</a></li>
- <li><a href="#">Another action</a></li>
- <li><a href="#">Something else here</a></li>
- <li class="divider"></li>
- <li><a href="#">Separated link</a></li>
- </ul>
- </div>
- <div class="btn-group">
- <button type="button" class="btn btn-success btn-flat">Action</button>
- <button type="button" class="btn btn-success btn-flat dropdown-toggle" data-toggle="dropdown">
- <span class="caret"></span>
- <span class="sr-only">Toggle Dropdown</span>
- </button>
- <ul class="dropdown-menu" role="menu">
- <li><a href="#">Action</a></li>
- <li><a href="#">Another action</a></li>
- <li><a href="#">Something else here</a></li>
- <li class="divider"></li>
- <li><a href="#">Separated link</a></li>
- </ul>
- </div>
- <div class="btn-group">
- <button type="button" class="btn btn-warning btn-flat">Action</button>
- <button type="button" class="btn btn-warning btn-flat dropdown-toggle" data-toggle="dropdown">
- <span class="caret"></span>
- <span class="sr-only">Toggle Dropdown</span>
- </button>
- <ul class="dropdown-menu" role="menu">
- <li><a href="#">Action</a></li>
- <li><a href="#">Another action</a></li>
- <li><a href="#">Something else here</a></li>
- <li class="divider"></li>
- <li><a href="#">Separated link</a></li>
- </ul>
- </div>
- </div>-->
- </div>
- <!-- /.box-body -->
- </div>
- <!-- end split buttons box -->
- <meta http-equiv="refresh" content="5;URL='index.php?opt=obj_request_approval'">
- <?php
- //REQUEST_APPROVAL_HTML::fn_page_default(1);
- }
- }
- else
- {
- echo "<div class=\"callout callout-warning lead\">
- <h4>Alert!</h4>
- <p>
- Cancel document id ".$id_doc." Failed please contact your admin </br> ".ADMIN_CONTACT." <a href=\"index.php?opt=obj_request_approval\">Back</a>
- </p>
- </div>";
- //echo " Cancel document id ".$id_doc." Failed please contact your admin </br> ".ADMIN_CONTACT;
- }
- }
- }
- function fn_submitdoc()
- {
- global $mycn;
- $cldata=new mylib();
- $id_doc=$_POST['id_doc'];
- $remark=$_POST['remark'];
- $qry="update tbl_document_new set status=2,uby='".$_SESSION['usernik']."',udt='".date("Y-m-d H:i:s")."' where id_doc=$id_doc";
- //echo $qry."<br>";
- if(mysql_query($qry))
- {
- //SET FIRST APPROVAL
- $qry="select id from tbl_document_approval_new where id_doc='$id_doc' order by id asc limit 1";
- $rs1=mysql_query($qry);
- $rw1=mysql_fetch_object($rs1);
- $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";
- //echo $qry."<br>";
- mysql_query($qry);
- $qry="insert into tbl_document_log_new set tglupdate='".date("Y-m-d H:i:s")."',status_doc_by='".$_SESSION['usernik']."',
- id_status_doc=2,status_doc='Processing Approval',remark='$remark',
- id_doc=$id_doc";
- //echo $qry."<br>";
- if(mysql_query($qry))
- {
- $arrmsisdn=array();
- //KIRIM KE LEGAL REGION
- $qry="select email,hp from tbl_user where nik='".$_SESSION['usernik']."' or (menu_group='LGL' and activated='Y' and id_region='".$_SESSION['userregion']."')";
- //echo $qry."<br>";
- $rsreceipent=mysql_query($qry) or die(mysql_error());
- if($rsreceipent)
- {
- $j=1;
- while($rw=mysql_fetch_object($rsreceipent))
- {
- $email[$j]=$rw->email;
- array_push($arrmsisdn,$rw->hp);
- $j+=1;
- }
- }
- mysql_free_result($rsreceipent);
- //KIRIM KE USER APPROVAL
- $qry="select tu.email,tu.hp
- from tbl_document_approval_new da
- inner join tbl_document_new td on td.id_doc=da.id_doc
- inner join tbl_user tu on tu.nik=da.nik
- where td.id_doc=$id_doc and tu.activated='Y'
- order by da.id asc limit 1";
- //echo $qry."<br>";
- $rsreceipent2=mysql_query($qry,$mycn) or die(mysql_error());
- if($rsreceipent2)
- {
- //$j=1;
- while($rw=mysql_fetch_object($rsreceipent2))
- {
- $email[$j]=$rw->email;
- array_push($arrmsisdn,$rw->hp);
- $j+=1;
- }
- $email[$j]="aan_wahyudi_x@telkomsel.co.id";
- $j+=1;
- $email[$j]="sorpa_e_t@telkomsel.co.id";
- $message="FYI\n\nYou Have assignment To Approve Document : ".$_SESSION['usernik']." (".mysql_result($rsdoc,0,"emp_name").") \n";
- $message.="\nattachment file : ".mysql_result($rsdoc,0,"doc_filename")."\nDocument type : ".mysql_result($rsdoc,0,"type_name")."\n";
- $message.="Document date : ".date("Y-m-d H:i:s");
- $message.="\n\n <<< Legal Documentation System Tool : http://10.33.97.177/ladys >>>";
- //$message.="\n\n <<< Mobile Approve Ladys Tools : http://10.33.97.172/ldc/mldc/ >>>";
- //$message.="\n\n Note : attachment file will be automatically deleted 2 x 24 hours if not verification";
- }
- mysql_free_result($rsreceipent2);
- //######## SEND SMS
- //$nomor_approval=$rw->hp;
- //$arrmsisdn2=array();
- array_push($arrmsisdn,'085275373893');
- array_push($arrmsisdn,'0811649190');
- //array_push($arrmsisdn,'0811616919');
- //array_push($arrmsisdn,'081380839999');
- $hp=implode(",",$arrmsisdn);
- //$hp2=implode(",",$arrmsisdn2);
- $pesan="Legal Documentation System\n";
- $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";
- //$pesan.= "Project Type: $tipe_project\n";
- $cldata->sendsmsinfo($hp,$pesan);
- //######## BATAS SEND
- //echo $email[0].$email[1].$email[2];
- if($cldata->fn_sendEmail($message,$email,SENDER,ALIASSENDER,SUBJECT,true))
- {
- $qry="update tbl_document_new set senttolgl=1 where id_doc=$id_doc";
- mysql_query($qry) or die(mysql_error());
- }
- //REQUEST_APPROVAL_HTML::fn_page_default(1);
- echo "<div class=\"callout callout-info lead\">
- <h4>Alert!</h4>
- <p>
- Submit Document Successfull !!!. <a href=\"index.php?opt=obj_request_approval\">Back</a>
- </p>
- </div>";
- }
- }
- else
- {
- echo " Cancel document id ".$id_doc." Failed please contact your admin </br> ".ADMIN_CONTACT;
- }
- }
- function fn_updateupload()
- {
- global $mycn;
- if($_FILES['txt_file']['type']!=="application/pdf")//&&$_FILES['txt_file']['type']!=="image/tiff"
- {
- //id=\"tb_legal\"
- echo "<div class=\"callout callout-danger lead\">
- <h4>Alert!</h4>
- <p>
- Please attach file in PDF Format !!!. <a href=\"index.php?opt=obj_request_approval\">Back</a>
- </p>
- </div>
- ";
- exit;
- }
- if($_FILES['txt_file']['size']>0)
- {
- if($_FILES['txt_file']['size']<=21000000)
- {
- $filename=$_FILES['txt_file']['name'];
- $filetmp=$_FILES['txt_file']['tmp_name'];
- $filesize=$_FILES['txt_file']['size'];
- $filetype=$_FILES['txt_file']['type'];
- $docno=$_POST['txt_iddoc'];
- $qry="select * from tbl_document_new where id_doc='$docno' ";
- //echo $qry;
- $rs=mysql_query($qry);
- $rw=mysql_fetch_object($rs);
- $nodinold=$rw->filecontent;
- $rec=date("Ymdhi");
- $prenodin=$rec."_lampiran.pdf";
- $destination_upload="doc_upload/";
- $target_path = $destination_upload.basename($_FILES['txt_file']['name']);
- if(is_uploaded_file($_FILES['txt_file']['tmp_name'])) //&& is_uploaded_file($_FILES['txt_doc_contract']['tmp_name'])
- {
- if(move_uploaded_file($_FILES['txt_file']['tmp_name'],$target_path))// && move_uploaded_file($_FILES['txt_doc_contract']['tmp_name'],$target_path2)
- {
- unlink($destination_upload."".$nodinold."");
- $msg = "<div class=\"callout callout-info lead\">
- <h4>Alert!</h4>
- <p>
- Your file has been updated successfully.
- </p>
- </div>";
- rename($destination_upload."".$filename."", $destination_upload."".$prenodin."");
- $result=1;
- }else
- {
- $msg=$_FILES['txt_file']['name']." Dokumen Lampiran Gagal di Update.";
- }
- }
- if(!get_magic_quotes_gpc())
- {
- $filename=addslashes($filename);
- }
- $qry="update tbl_document_new set doc_filename='$filename',doc_filetype='$filetype',doc_filesize='$filesize',
- doc_filecontent='$prenodin',status=-3,uby='".$_SESSION['usernik']."',udt=now() where id_doc='$docno' and isdeleted=0";
- //echo $qry."<br>";
- if(mysql_query($qry) or die(mysql_error()))
- {
- /*$qry="select id from tbl_document_approval_new where id_doc='$docno' order by id asc limit 1";
- $rs=mysql_query($qry);
- $rw=mysql_fetch_object($rs);
- $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";*/
- //echo $qry."<br>";
- if(mysql_query($qry) or die(mysql_error()))
- {
- $qry="insert into tbl_document_log_new set tglupdate='".date("Y-m-d H:i:s")."',status_doc_by='".$_SESSION['nik']."',
- id_status_doc=-3,status_doc='Resubmit Return Document',remark='After Rejected',
- id_doc=$docno";
- mysql_query($qry);
- REQUEST_APPROVAL_HTML::fn_viewdoc($docno);
- }
- //echo $msg;//."<br>".$qry."<br>".$_POST['cbolemari']."ALL".$id_doc;
- ?>
- <!--<meta http-equiv="refresh" content="5;URL='index.php?opt=obj_request_approval'">-->
- <?php
- }
- else
- {die(mysql_error());}
- }
- else
- {
- echo "<div class=\"callout callout-danger lead\">
- <h4>Reminder!</h4>
- <p>
- Your File is too large <b>Max 21.5 MB</b>.
- <a href=\"index.php?opt=obj_request_approval\">Back</a>
- </p>
- </div>
- ";
- }
- }
- else
- {
- echo "<div class=\"callout callout-danger lead\">
- <h4>Alert!</h4>
- <p>
- Your File is <b>0 Size</b>.
- <a href=\"index.php?opt=obj_request_approval\">Back</a>
- </p>
- </div>
- ";
- }
- }
- function fn_resendtolegal()
- {
- global $mycn;
- $cldata=new cldata();
- $id_doc=$_POST['id_doc'];
- $index=$_POST['ndx'];
- $qry="select td.*,tu.emp_name,tdt.type_name
- from tbl_document_new td inner join tbl_user tu on td.nik=tu.nik
- inner join tbl_document_type tdt on td.doc_type=tdt.id_type
- where td.id_doc=$id_doc";
- //echo $qry;
- $rsdoc=mysql_query($qry) or die(mysql_error());
- if($rsdoc)
- {
- $message="FYI\n\nYou Have assignment To Approve Document from Nik : ".$_SESSION['usernik']." (".mysql_result($rsdoc,0,"emp_name").") \n";
- $message.="\nattachment file : ".mysql_result($rsdoc,0,"doc_filename")."\nDocument type : ".mysql_result($rsdoc,0,"type_name")."\n";
- $message.="Document date : ".date("Y-m-d H:i:s");
- $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
- }
- mysql_free_result($rsdoc);
- $qry="select tu.email from tbl_document_approval_new da
- inner join tbl_document_new td on td.id_doc=da.id_doc
- inner join tbl_user tu on tu.nik=da.nik
- where td.id_doc=$id_doc and tu.activated='Y' and da.status<>3
- order by da.id asc limit 1";
- $rse=mysql_query($qry) or die(mysql_error());
- $rwe=mysql_fetch_object($rse);
- $email=array();
- $email[0]=$rwe->email;
- if($cldata->fn_sendEmail($message,$email,SENDER,ALIASSENDER,SUBJECT,true))//$cldata->fn_sendEmail($message)
- {
- $qry="update tbl_document_new set senttolgl=1 where id_doc=$id_doc";
- if(mysql_query($qry))
- {
- echo "Mail Sent. OK";
- }
- else
- {
- echo "<a href=\"#\" title=\"Klik disini untuk resend email\"
- onClick=\"confresendemail('div_emailreport".$index."','".$id_doc."',".$index.")\">
- Failed
- </a>";
- die(mysql_error());
- }
- }else
- {
- echo "Ups, Gak Bisa Kirim email nih".$message;
- }
- //HTML_UPLOAD::fn_page_default(1);
- }
- }
- $cl=new REQUEST_APPROVAL();
- switch($task)
- {
- case "viewdoc":
- $cl->fn_viewdoc();
- break;
- case "viewedit":
- $cl->fn_viewedit();
- break;
- case "updatedetail";
- $cl->fn_updatedetail();
- break;
- case "viewupload":
- $cl->fn_viewupload();
- break;
- case "updateupload";
- $cl->fn_updateupload();
- break;
- case "getdocnumber";
- $cl->fn_getdocnumber();
- break;
- case "uploaddoc";
- $cl->fn_uploaddoc();
- break;
- case "submitdoc";
- $cl->fn_submitdoc();
- break;
- case "canceldoc";
- $cl->fn_canceldoc();
- break;
- case "resendtolegal";
- $cl->fn_resendtolegal();
- break;
- //#####
- case "getadn":
- $cl->fn_get_adn();
- break;
- default:
- $cl->fn_page_default();
- breal;
- }
- ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement