proc

Contracts extension tracker by remind date

prepare("SELECT id,SERVICEPROVIDER, CONTRACT, STARTDATE, REMINDDATE, ENDDATE, TIMESTAMPDIFF( YEAR, ENDDATE, now() ) as year , TIMESTAMPDIFF( MONTH, ENDDATE, now() ) % 12 as month , FLOOR( TIMESTAMPDIFF( DAY, ENDDATE, now() ) % 30.4375 ) as day FROM contracts WHERE REMINDDATE < CURDATE() + 1 AND STATUS = 'RUNNING' ORDER BY id DESC"); $result->execute(); for($i=0; $row = $result->fetch(); $i++){ ?>

S/NO. SERVICE PROVIDER CONTRACT DETAILS STRAT DATE REMIND DATE END DATE REM(YRS) REM(M) REM(D) ACTION REQUIRED

Years Months Days

Add || Update ==> Contracts

"; echo ''; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; } ?>

ACTION S/NO SERVICE PROVIDER CONTRACT CONTRACT VALUE PAYMENT SHEDULE STATUS TRUNCATE

ACTION S/NO SERVICE PROVIDER CONTRACT CONTRACT VALUE PAYMENT SHEDULE STATUS TRUNCATE

".$res['id']." ".$res['SERVICEPROVIDER']." ".$res['CONTRACT']." ".$res['CONTRACTVALUE']." ".$res['PAYMENTSHEDULE']." ".$res['STATUS']." Delete

Please confirm your password to switch user mode ==> admin mode

Add new contract

Update projects / contract details

Add new contract

"; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; } ?>

S/NO SERVICE PROVIDER CONTRACT CONTRACT VALUE PAYMENT SHEDULE TENURE STARTDATE ENDDATE REMAINING PERIOD EXTENSION (END DATE) RESPONSIBILITY CENTER ACCOUNTABLE CONSULTED CONTRACT MANAGER

S/NO SERVICE PROVIDER CONTRACT CONTRACT VALUE PAYMENT SHEDULE TENURE STARTDATE ENDDATE REMAINING PERIOD EXTENSION (END DATE) RESPONSIBILITY CENTER ACCOUNTABLE CONSULTED CONTRACT MANAGER

".$res['id']." ".$res['SERVICEPROVIDER']." ".$res['CONTRACT']." ".$res['CONTRACTVALUE']." ".$res['PAYMENTSHEDULE']." ".$res['TENURE']." ".$res['STARTDATE']." ".$res['ENDDATE']." ".$res['year']." Yrs ".$res['month']." Months ".$res['day']." Days ".$res['EXTENSIONENDDATE']." ".$res['RESPONSIBILITYCENTER']." ".$res['ACCOUNTABLE']." ".$res['CONSULTED']." ".$res['CONTRACTMANAGER']."