function validateInput($field_name = '', $table = '') { $table = dev_is_null($table) ? $this->getReferenceTable() : $table; $field_info = $this->getFieldInfo(); $passed = true; if (isset($field_info[$field_name])) { $this_field = $field_info[$field_name]; $field_type = strtolower($this_field['Type']); //If duplicate entry if ($this_field['Key'] == 'PRI' || $this_field['Key'] == 'UNI') { if (!dev_check_dupes($field_name, $this->getField($field_name), $table)) { //$this->setStatusMessage("A row having field '$field_name' with value '" . $this->getField($field_name) . "' already exists."); // No longer needs to send failing state but still good to log // $passed = false; } } else { if ($this->getField($field_name) !== 0 && $this->getField($field_name) == '') { if (!$this_field['Null'] || $this_field['Null'] == 'NO') { if (dev_is_substr($field_type, 'date')) { $this->setField($field_name, dev_join_date($field_name)); if (!is_string($this->getField($field_name)) || !dev_is_date_string($this->getField($field_name))) { $this->setStatusMessage("Field '{$field_name}' contains an inaccurate date format!"); $passed = false; } } else { $this->setStatusMessage("Field '{$field_name}' cannot be empty!"); $passed = false; } } } else { //Correct Datatype/Size if (dev_is_substr($field_type, 'int') || dev_is_substr($field_type, 'double') || dev_is_substr($field_type, 'float')) { if (!is_numeric($this->getField($field_name))) { $this->setStatusMessage("Field '{$field_name}' must be numeric!"); $passed = false; } } if (dev_is_substr($field_type, 'char') || dev_is_substr($field_type, 'text')) { if (!is_string($this->getField($field_name))) { $this->setStatusMessage("Field '{$field_name}' is not text!"); $passed = false; } if (dev_not_null($this_field['LENGTH']) && strlen($this->getField($field_name)) > $this_field['LENGTH']) { $this->setStatusMessage("Field '{$field_name}' is greater than maximum allowed string length!"); $passed = false; } } if (dev_is_substr($field_type, 'date')) { if (!is_string($this->getField($field_name)) || !dev_is_date_string($this->getField($field_name))) { $this->setField($field_name, dev_join_date($field_name)); if (!is_string($this->getField($field_name)) || !dev_is_date_string($this->getField($field_name))) { $this->setStatusMessage("Field '{$field_name}' contains an inaccurate date format!"); $passed = false; } } } if (dev_is_substr($field_type, 'set')) { if (is_array($this->getField($field_name))) { $this->setField($field_name, implode(', ', $this->getField($field_name))); } elseif (!is_string($this->getField($field_name))) { $this->setStatusMessage("Field '{$field_name}' contains invalid input!"); $passed = false; } } } } } return $passed; }
private function validate($field_name = null, $table = null) { $fields = $this->fields(); // if no table is specified, used the first available entry. $table = $table ? $table : (isset($tables[0]) ? $tables[0] : current(DevArray::toArray($this->config(self::NAME_FIELD)))); $passed = true; if (isset($fields[$field_name])) { $field = $fields[$field_name]; $type = strtolower($field['Type']); //If duplicate entry if ($field['Key'] == 'PRI' || $field['Key'] == 'UNI') { if (self::inDB($field_name, $this->field($field_name), $table)) { // In what case do we really need to know this? $this->status("A row having field '{$field_name}' with value '" . $this->field($field_name) . "' already exists."); } } else { if ($this->field($field_name) !== 0 && $this->field($field_name) == '') { if (!$field['Null'] || $field['Null'] == 'NO') { if (DevString::has($type, 'date')) { //$this->field($field_name, dev_join_date($field_name)); $this->field($field_name, date('Y-m-d')); if (!is_string($this->field($field_name)) || !DateTime::stringIsDate($this->field($field_name))) { $this->status("Field '{$field_name}' contains an inaccurate date format!"); $passed = false; } } else { $this->status("Field '{$field_name}' cannot be empty!"); $passed = false; } } } else { //Correct Datatype/Size if (DevString::has($type, 'int') || DevString::has($type, 'double') || DevString::has($type, 'float')) { if (!is_numeric($this->field($field_name))) { $this->status("Field '{$field_name}' must be numeric!"); $passed = false; } } if (DevString::has($type, 'char') || DevString::has($type, 'text')) { if (!is_string($this->field($field_name))) { $this->status("Field '{$field_name}' is not text!"); $passed = false; } if (isset($field['LENGTH']) && DevValue::isNotNull($field['LENGTH']) && strlen($this->field($field_name)) > $field['LENGTH']) { $this->status("Field '{$field_name}' is greater than maximum allowed string length!"); $passed = false; } } if (DevString::has($type, 'date')) { if (!is_string($this->field($field_name)) || !DateTime::stringIsDate($this->field($field_name))) { $this->field($field_name, dev_join_date($field_name)); if (!is_string($this->field($field_name)) || !DateTime::stringIsDate($this->field($field_name))) { $this->status("Field '{$field_name}' contains an inaccurate date format!"); $passed = false; } } } if (DevString::has($type, 'set')) { if (is_array($this->field($field_name))) { $this->field($field_name, implode(', ', $this->field($field_name))); } elseif (!is_string($this->field($field_name))) { $this->status("Field '{$field_name}' contains invalid input!"); $passed = false; } } } } } return $passed; }