function editPhone($id, $val)
{
if ($this->db->update('customers_phones', array('phone' => numberFixAU($val)), array('id' => $id))) {
return true;
} else {
return false;
}
}
public function trysearch()
{
$searchText = $this->input->post('searchText');
//rd($searchText);die;
//try to search from customers table;
$this->db->select('*');
$this->db->from('customers');
if (isset($searchText) && !empty($searchText)) {
$this->db->like('LOWER(name)', strtolower($searchText), 'both');
}
$query = $this->db->get();
//rd($query);die;
$this->load->model('states_model');
$data['states'] = $this->states_model->getAll();
//search by phone
if ($query->num_rows < 1) {
$this->db->select('*');
$this->db->from('customers_phones');
//$fixednumber = numberFixAU($searchText);
//rd($searchText);rd(mb_strlen($searchText)); die;
if (mb_strlen($searchText) == 8) {
$this->db->like('phone', $searchText, 'before');
} else {
$this->db->like('phone', numberFixAU($searchText));
}
$query = $this->db->get();
$res = array();
$this->load->model('customers_model');
foreach ($query->result_array() as $uIds) {
$res[] = $this->customers_model->getById($uIds['customers_id']);
}
$data['customers'] = $res;
$data['uId'] = $uId = $this->dx_auth->get_user_id();
$html = $this->load->view('/search/trysearch2', $data, true);
print $html;
} else {
//
$data['customers'] = $query->result_array();
$data['uId'] = $uId = $this->dx_auth->get_user_id();
$html = $this->load->view('/search/trysearch', $data, true);
print $html;
}
}
function numberFixAULocal($number)
{
$number_org = $number;
$number = numberFixAU($number);
// Turn number into local format, leading 0 or 1, 10 digit number etc, or 13 number 6 digit.
// Check if number is 13-1300/1800 number, if so do not add leading 0.
if (substr($number, 0, 2) == '611') {
$number = substr($number, 2);
} else {
$number = "0" . substr($number, 2);
}
// Check to make sure it is now Austrailan Local format but correct digit length and valid Australian number.
$valid = preg_match('/^(0(2|3|4|7|8))?\\d{8}$/', $number) || preg_match('/^1(3|8)00\\d{6}$/', $number) || preg_match('/^13\\d{4}$/', $number);
// If number was valid AU number return phone number.
if ($valid == true) {
return $number;
} else {
return false;
//return('BAD FORMAT');
}
}
public function getcustomersbynumber()
{
$num = numberFixAU($this->input->post('num'));
$phonesRes = $this->customers_model->getCustomersByNumber($num);
$res = array();
for ($i = 0; $i < count($phonesRes); $i++) {
$res[$i]['phone'] = $phonesRes[$i]['phone'];
$uRes = $this->customers_model->getById($phonesRes[$i]['customers_id']);
$res[$i]['cDetails'] = $uRes;
}
if (isset($res[0]['phone'])) {
print json_encode(array('results' => $res));
} else {
print false;
}
}
