function ImportPSTNList($cusid = NULL) { if (is_null($cusid)) { $cus = $this->DB->GetAll('SELECT id FROM hv_customers ORDER BY id ASC '); } else { $tmp = $cusid; $cus = array(); $cus[0]['id'] = $tmp; unset($tmp); } $cus_count = count($cus); if ($cus_count !== 0) { for ($i = 0; $i < $cus_count; $i++) { usleep(500000); $lista = HiperusActions::GetPSTNNumberList($cus[$i]['id']); if (is_array($lista)) { $count = count($lista); } else { $count = 0; } if ($count !== 0) { for ($j = 0; $j < $count; $j++) { if (!is_null($lista[$j]['id'])) { if (!$this->DB->GetOne('SELECT 1 FROM hv_pstn WHERE id=? LIMIT 1 ;', array($lista[$j]['id']))) { $this->DB->Execute('INSERT INTO hv_pstn (id,customerid,extension,country_code,number,is_main,disa_enabled,clir,virtual_fax,terminal_name,id_auth,create_date,voicemail_enabled ) VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?) ;', array($lista[$j]['id'], $cus[$i]['id'], !empty($lista[$j]['extension']) ? $lista[$j]['extension'] : NULL, !empty($lista[$j]['country_code']) ? $lista[$j]['country_code'] : '48', !empty($lista[$j]['number']) ? $lista[$j]['number'] : NULL, $lista[$j]['is_main'], $lista[$j]['disa_enabled'], $lista[$j]['clir'], $lista[$j]['virtual_fax'], !empty($lista[$j]['terminal_name']) ? $lista[$j]['terminal_name'] : NULL, !empty($lista[$j]['id_auth']) ? $lista[$j]['id_auth'] : NULL, !empty($lista[$j]['create_date']) ? $lista[$j]['create_date'] : NULL, $lista[$j]['voicemail_enabled'])); } else { $this->DB->Execute('UPDATE hv_pstn SET customerid=?, extension=?, country_code=?, number=?, is_main=?, disa_enabled=?, clir=?, virtual_fax=?, terminal_name=?, id_auth=?, create_date=?, voicemail_enabled=? WHERE id=? ;', array($cus[$i]['id'], !empty($lista[$j]['extension']) ? $lista[$j]['extension'] : NULL, !empty($lista[$j]['country_code']) ? $lista[$j]['country_code'] : '48', !empty($lista[$j]['number']) ? $lista[$j]['number'] : NULL, $lista[$j]['is_main'], $lista[$j]['disa_enabled'], $lista[$j]['clir'], $lista[$j]['virtual_fax'], !empty($lista[$j]['terminal_name']) ? $lista[$j]['terminal_name'] : NULL, !empty($lista[$j]['id_auth']) ? $lista[$j]['id_auth'] : NULL, !empty($lista[$j]['create_date']) ? $lista[$j]['create_date'] : NULL, $lista[$j]['voicemail_enabled'], $lista[$j]['id'])); } } } } } unset($lista); unset($count); } unset($cus); unset($cus_count); }