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; }