function getEntry($id)
{
if (!is_numeric($id) || $id == '0') {
return array();
} else {
$id = (int) $id;
$Q = mysql_query("select * from `entry` where entry_id = '" . $id . "' limit 1");
if (!mysql_num_rows($Q)) {
return array();
} else {
$return = mysql_fetch_assoc($Q);
$return['room_id'] = splittIDs($return['room_id']);
$return['edit_by'] = splittIDs($return['edit_by']);
$return['user_assigned'] = splittIDs($return['user_assigned']);
$return['contact_person_email2'] = splittEmails($return['contact_person_email']);
if ($return['invoice_content'] == '') {
$return['invoice_content'] = array();
} else {
$return['invoice_content'] = unserialize($return['invoice_content']);
if (!is_array($return['invoice_content'])) {
$return['invoice_content'] = array();
}
}
$return['mva'] = array();
$return['mva_grunnlag'] = array();
$return['mva_grunnlag_sum'] = 0;
$return['faktura_belop_sum'] = 0;
$return['faktura_belop_sum_mva'] = 0;
$return['eks_mva_tot'] = 0;
foreach ($return['invoice_content'] as $linjenr => $vars) {
$return['faktura_belop_sum_mva'] += $vars['mva_sum'];
$return['faktura_belop_sum'] += $vars['belop_sum'];
$return['eks_mva_tot'] += $vars['belop_sum_netto'];
$vars['mva'] *= 100;
if ($vars['mva'] > 0) {
if (isset($mva[$vars['mva']])) {
$return['mva'][$vars['mva']] += $vars['mva_sum'];
} else {
$return['mva'][$vars['mva']] = $vars['mva_sum'];
}
$return['mva_grunnlag_sum'] += $vars['belop_sum_netto'];
if (isset($return['mva_grunnlag'][$vars['mva']])) {
$return['mva_grunnlag'][$vars['mva']] += $vars['belop_sum_netto'];
} else {
$return['mva_grunnlag'][$vars['mva']] = $vars['belop_sum_netto'];
}
}
}
$return['grunnlag_mva_tot'] = 0;
if (count($return['mva'])) {
foreach ($return['mva'] as $mvaen => $mva_delsum) {
$return['grunnlag_mva_tot'] += $return['mva_grunnlag'][$mvaen];
}
$return['mva_vis'] = true;
} else {
$return['mva_vis'] = false;
}
return $return;
}
}
}
$unknowns_per_shop[$unknown['shop_id']][] = $unknown;
}
printout('');
printout('Unknown goods per shop:');
foreach ($unknowns_per_shop as $shop_id => $unknowns) {
$Q_shop = mysql_query("SELECT * FROM `import_dn_shops` WHERE shop_id='" . $shop_id . "'");
if (mysql_num_rows($Q_shop)) {
$shop = mysql_result($Q_shop, 0, 'shop_name') . ' (shop id ' . $shop_id . ')';
} else {
$shop = 'Unknown shop (shop id ' . $shop_id . ')';
}
printout($shop . ': ' . count($unknowns) . ' unknowns');
// Alerting people about the unknowns
if (isset($shops[$shop_id]) && isset($areas[$shops[$shop_id]])) {
$area = $areas[$shops[$shop_id]];
$emails = splittEmails($area['importdatanova_alert_email']);
$unknowns_txt = '';
foreach ($unknowns as $unknown) {
$unknowns_txt .= '- (' . $unknown['vare_nr'] . ') ' . $unknown['vare_navn'] . chr(10);
}
if (count($emails)) {
foreach ($emails as $email) {
printout('Alerting ' . $email . ' about unknown goods in ' . $area['area_name']);
emailSendDirect($email, 'Import fra Datanova mangler kategori - Gjelder ' . $area['area_name'], 'Hei' . chr(10) . chr(10) . 'I forbindelse med import fra salg i kasseapparatene (Datanova-systemene) til bookingsystemet, ' . 's� var det noen varer som systemet ikke kjenner til og ikke vet hva den skal gj�re med:' . chr(10) . chr(10) . $unknowns_txt . chr(10) . 'G� inn p� f�lgende adresse for � legge inn de nye varene (eller be systemet ignorere de):' . chr(10) . $systemurl . '/admin_import_dn.php?action=notimported_list&area_id=' . $area['area_id'] . chr(10) . chr(10) . 'Grunnen til at du f�r denne e-post, er at du er satt opp i ' . 'bookingsystemet som en som skal varsles om slikt.' . chr(10) . chr(10) . 'Mvh. Bookingsystemet');
}
} else {
printout('No alerts sent out. No email addresses set in area.');
}
}
}
}
function getEntryParseDatabaseArray($return)
{
$return['room_id'] = splittIDs($return['room_id']);
$return['edit_by'] = splittIDs($return['edit_by']);
$return['user_assigned'] = splittIDs($return['user_assigned']);
$return['contact_person_email2'] = splittEmails($return['contact_person_email']);
if ($return['invoice_content'] == '') {
$return['invoice_content'] = array();
} else {
$return['invoice_content'] = unserialize($return['invoice_content']);
if (!is_array($return['invoice_content'])) {
$return['invoice_content'] = array();
}
}
$return['mva'] = array();
$return['mva_grunnlag'] = array();
$return['mva_grunnlag_sum'] = 0;
$return['faktura_belop_sum'] = 0;
$return['faktura_belop_sum_mva'] = 0;
$return['eks_mva_tot'] = 0;
foreach ($return['invoice_content'] as $linjenr => $vars) {
$return['faktura_belop_sum_mva'] += $vars['mva_sum'];
$return['faktura_belop_sum'] += $vars['belop_sum'];
$return['eks_mva_tot'] += $vars['belop_sum_netto'];
$vars['mva'] *= 100;
if ($vars['mva'] > 0) {
if (isset($return['mva'][$vars['mva']])) {
$return['mva'][$vars['mva']] += $vars['mva_sum'];
} else {
$return['mva'][$vars['mva']] = $vars['mva_sum'];
}
$return['mva_grunnlag_sum'] += $vars['belop_sum_netto'];
if (isset($return['mva_grunnlag'][$vars['mva']])) {
$return['mva_grunnlag'][$vars['mva']] += $vars['belop_sum_netto'];
} else {
$return['mva_grunnlag'][$vars['mva']] = $vars['belop_sum_netto'];
}
}
}
$return['grunnlag_mva_tot'] = 0;
if (count($return['mva'])) {
foreach ($return['mva'] as $mvaen => $mva_delsum) {
$return['grunnlag_mva_tot'] += $return['mva_grunnlag'][$mvaen];
}
$return['mva_vis'] = true;
} else {
$return['mva_vis'] = false;
}
return $return;
}
