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