function sig_request_made($docid) { $sql="select * from tblsignaturerequest where signaturerequestdocumentid=".db_number($docid); $res=db_query($sql); if($res) return $res; else return 0; } function createrequestsignaturebutton($documentid) { $out=" "; if(!$documentid || !(db_number($documentid)>0)) return $out; $sigquery=sig_request_made($documentid); $largefile=""; $fullfile= $_SERVER['DOCUMENT_ROOT'] . "/" .get_relativedocpath($documentid); if(file_exists($fullfile)) { $fs=filesize($fullfile); if($fs && (($fs/1000000)>5)) //If larger than 5 megs $largefile="large"; } //d($sigquery); if(!$sigquery) { $btnlink="opensignaturemodal(this,\"$largefile\")"; $btntext="Request Signature"; } else { $btnlink="opensignaturemodal(this,\"$largefile\")"; $approvedcount=0; $signedcount=0; $unsignedcount=0; $refusedcount=0; foreach($sigquery as $signum=>$sigdata) { //d($sigdata['signaturerequestsigneddate']); if($sigdata['signaturerequestapproveddate']) $approvedcount++; if($sigdata['signaturerequestrefuseddate']) $refusedcount++; if($sigdata['signaturerequestsigneddate'] && !$sigdata['signaturerequestinactivateddate']) $signedcount++; if(!$sigdata['signaturerequestinactivateddate']) $unsignedcount++; } $btntext=($signedcount+$refusedcount)."/".$unsignedcount." Completed"; $textcolor="black"; if((($signedcount+$refusedcount) != $unsignedcount) || (($approvedcount) !=$signedcount)) $textcolor="red"; } $out="
"; $sql="select documentid from tbldocument where documentparent=".db_number($documentid); $haschilddocuments=db_query($sql); $sql="select documentid , documentname , documentparent , documentislocked from tbldocument where documentid=".db_number($documentid); $documentinfo=db_first($sql); //d('$documentinfo',$documentinfo); //$imagename = "unlock.png"; //if (check_pdf_encrypted("$_SERVER[DOCUMENT_ROOT]/document".getrelativedocumentdir($documentid).db_firstval ("select documentname from tbldocument where documentid =" . $documentid ) ,1)) if($documentinfo['documentislocked']) { $imagename = "lock.png"; $insertlock = "