Ex.
Given Date: 2008-10-23
Days to be added: 5 days
Due Date: 2008-10-28
It worked perfectly on my localhost and on out testing server at the office. But when I implemented it on our branches, the program doesn't compute for due date.
My code:
Code: Select all
$dDueDate = date("Y-m-d", strtotime("+".$oResTrdRec->fields['DAYS']." days", strtotime($oResTrdRec->fields['INVOICEDATE'])));
if (strtotime($dDueDate) <= strtotime($oResTrdRec->fields['INVOICEDATE'])) // if the above procedure fails, try the next
{
$dInvYear = intval(substr($oResTrdRec->fields['INVOICEDATE'],0,4)); // my efin codes (Jesar James Alas Gacula)
$dInvMonth = intval(substr($oResTrdRec->fields['INVOICEDATE'],5,2));
$dInvDay = intval(substr($oResTrdRec->fields['INVOICEDATE'],8,2));
$dDue = intval($oResTrdRec->fields['DAYS']);
$dNewDate = mktime(0,0,0,$dInvMonth,$dInvDay+$dDue,$dInvYear);
$dDueDate = date("Y-m-d", $dNewDate);
if (strtotime($dDueDate) <= strtotime($oResTrdRec->fields['INVOICEDATE'])) // if the above procedure fails again, try the last computation of date.
{
$dDueDate = fnc_date_calc($oResTrdRec->fields['INVOICEDATE'],$oResTrdRec->fields['DAYS']); // Sir JB's codes
}
else // if still fails..
{
$dDueDate = '0000-00-00';
}
}
$oStrAplHdr = $oResTrdRec->fields['TAON']."|".$oResTrdRec->fields['BUWAN']."|".$oResTrdRec->fields['INVOICENO']."|";
$oStrAplHdr .= $oResTrdRec->fields['INVOICEDATE']."|".$oResTrdRec->fields['VENDORCODE']."|".[b]$dDueDate[/b]."|";
$oStrAplHdr .= $oResTrdRec->fields['BRANCHCODE']."|".$oResTrdRec->fields['TOTAMT']."|".$oResTrdRec->fields['EWT']."|";
$oStrAplHdr .= $oResTrdRec->fields['REFERENCENO']."|".$oResTrdRec->fields['DEPTCODE']."|".$oResTrdRec->fields['DOCTYPEID']."|";
$oStrAplHdr .= $oResTrdRec->fields['TRANSTYPEID']."|".$oResTrdRec->fields['PARTICULARS']."|".'Available'."|";
$oStrAplHdr .= 'Y'."|".$tDateTime."|".$oResTrdRec->fields['ADDEDBY']."|";
$oStrAplHdr .= $oResTrdRec->fields['TOTAMT']."|".$oResTrdRec->fields['EWT']."|".$tDateTime."|";
$oStrAplHdr .= $oResTrdRec->fields['ADDEDBY']."|".$oResSelCom->fields['COMPANYCODE'];