Ejemplo n.º 1
0
function ReturnLetter()
{
    $temp = dataAccess::RUNQUERY("\r\n\t\tselect if(r.des_PersonID is null, w.PersonID, r.des_PersonID) as ToPersonID\r\n\r\n\t\tfrom fm_workflow as w\r\n\t\tleft join wfm_replacement as r on(src_PersonID=w.PersonID and StartDate <= now() and now() <= EndDate)\r\n\t\t\r\n\t\twhere StepID=" . $StepID . "-1 and FormID=" . $_POST["FormID"]);
    $FromPersonID = $_SESSION["PersonID"];
    $ToPersonID = $temp[0]["PersonID"];
    //....................................
    $db = dataAccess::GET_DB();
    /*@var $db ADODB*/
    $db->BeginTrans();
    dataAccess::RUNQUERY("insert into wfm_send(LetterID,ToPersonID,SendDate,\r\n\t\tSendType,SendComment,ViewFlag,FromPersonID,StepID)\r\n\t\tvalues(" . $_POST["LetterID"] . "," . $ToPersonID . ",now(),'" . $_POST["SendType"] . "','" . $_POST["SendComment"] . "',0," . $FromPersonID . "," . $_POST["StepID"] . "-1)");
    dataAccess::AUDIT("برگشت نامه کد[" . $_POST["LetterID"] . "] به [" . $ToPersonID . "] توسط [" . $FromPersonID . "]");
    dataAccess::RUNQUERY("update wfm_send set SendStatus='return' where RefID=" . $_POST["RefID"]);
    $db->CommitTrans();
    //....................................
    echo "true";
    die;
}