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