if (v::not(v::alnum("-.,()'"))->validate($form_data['emp_lname'])) {
$err_msg .= "The last name of the employee must be alphanumeric.\\n";
}
//if(v::not(v::alnum("-.,()'"))->validate($form_data['account_number'])) { $err_msg .= "The account number must be alphanumeric.\\n"; }
// Phone
if (v::not(v::phone())->validate($form_data['requester_phone'])) {
$err_msg .= "Your phone number is not valid: " . $form_data['requester_phone'] . "\\n";
}
if (v::not(v::phone())->validate($form_data['dept_phone'])) {
$err_msg .= "The department phone number is not valid: " . $form_data['dept_phone'] . "\\n";
}
// Date or Time - should not be in future
if (v::not(v::date('Y-m-d')->max('today'))->validate($mysql_start_date)) {
$err_msg .= "The start date is invalid: " . $start_date . "\\n";
}
if (v::not(v::date('Y-m-d')->max('today'))->validate($mysql_end_date)) {
$err_msg .= "The end date is invalid: " . $end_date . "\\n";
}
// ========================================================================================
// DATA PASSED VALIDATION - INSERT INTO DB AND SEND EMAILS
// ========================================================================================
if ($err_msg == '') {
// ========================================================================================
// GET BUSINESS MANAGER
// ========================================================================================
$facil_conn = new DBConnection('facil');
$conn1 = $facil_conn->openConnection();
$stmt1 = $conn1->prepare("SELECT hr_business_mgr.mgr_fname, hr_business_mgr.mgr_lname, hr_business_mgr.mgr_email FROM hr_business_mgr, a_workplaces WHERE a_workplaces.workplace = :dept AND a_workplaces.business_mgr = hr_business_mgr.mgrID");
$stmt1->bindParam(":dept", $department, PDO::PARAM_STR);
$stmt1->execute();
if ($stmt1->error) {
/**
* Create a negative or optional validator instance.
*
* @param string $filter
* @param array $rules
*
* @return \Respect\Validation\Validator
*/
protected function createNegativeOrOptionalValidator(string $filter, array $rules) : RespectValidator
{
list($method, $parameters) = $this->parseStringRule($rules[0]);
unset($rules[0]);
$validator = call_user_func_array([RespectValidator::class, str_replace($filter, '', $method)], $parameters);
if ($filter === '!') {
return RespectValidator::not($this->createChainableValidators($validator, $rules));
}
return RespectValidator::optional($this->createChainableValidators($validator, $rules));
}
/**
* Regression test #174.
*/
public function testShouldReturnANewValidatorInstanceWhenTheNotRuleIsCalledWithoutAnyArgument()
{
$validator = new Validator();
$this->assertInstanceOf('Respect\\Validation\\Validator', $validator->not());
}
