Exemple #1
0
function ReplacementSave()
{
    $startDate = CommenModules::Shamsi_to_Miladi($_POST["StartDate"]);
    $endDate = CommenModules::Shamsi_to_Miladi($_POST["EndDate"]);
    $temp = dataAccess::RUNQUERY("select * from wfm_replacement where src_PersonID=" . $_POST["src_PersonID"] . " and (('{$startDate}'>=StartDate and '{$startDate}'<=EndDate) or \r\n\t\t\t\t('{$endDate}'>=StartDate and '{$endDate}'<=EndDate))");
    if (count($temp) != 0) {
        echo "ConflictError";
        die;
    }
    //...........................
    $query = "insert into wfm_replacement(src_PersonID,des_PersonID,StartDate,EndDate) \r\n\t\t\tvalues(" . $_POST["src_PersonID"] . "," . $_POST["des_PersonID"] . ",'" . $startDate . "','" . $endDate . "')";
    dataAccess::RUNQUERY($query);
    dataAccess::AUDIT("ایجاد ردیف جایگزینی با فرد اصلی[" . $_POST["src_PersonID"] . "] و فرد جایگزین[" . $_POST["des_PersonID"] . "] با تاریخ شروع[" . $startDate . "]و تاریخ پایان[" . $endDate . "]");
    echo "true";
    die;
}