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