/**
* Firmenliste - lt. Suchekriterien
*/
function getFirmadetail($firma_id, $adresstyp_arr, $user, $neu)
{
global $rechte;
if ($firma_id != '' || $neu == 'true') {
if (!($db = new basis_db())) {
die('Es konnte keine Verbindung zum Server aufgebaut werden.');
}
// Init
$htmlstr = '';
// Datenlesen zur Firma
$firma = new firma();
if ($firma_id != '' && is_numeric($firma_id)) {
if (!$firma->load($firma_id)) {
return '<br>Firma mit der ID <b>' . $firma_id . '</b> existiert nicht';
}
} else {
//Bei neuen Firmen wird standardmaessig Partnerfirma ausgewaehlt
$firma->firmentyp_kurzbz = 'Partnerfirma';
$firma->aktiv = true;
$firma->gesperrt = false;
$firma->schule = false;
}
$htmlstr .= "<form id='addFirma' name='addFirma' action='firma_details.php' method='POST'>\n";
$htmlstr .= "<input type='hidden' name='work' value='saveFirma'>\n";
$htmlstr .= "<input type='hidden' name='firma_id' value='" . $firma->firma_id . "'>\n";
// Firma Detailanzeige
$htmlstr .= "<table class='detail' style='padding-top:10px;'>\n";
$htmlstr .= "<tr><td><table width='100%'><tr>\n";
$htmlstr .= "<td>Typ: </td>";
$htmlstr .= "<td><select name='typ'>\n";
$qry = "SELECT firmentyp_kurzbz FROM public.tbl_firmentyp ORDER BY firmentyp_kurzbz";
if ($result = $db->db_query($qry)) {
while ($row = $db->db_fetch_object($result)) {
$htmlstr .= "<option value='" . $row->firmentyp_kurzbz . "' " . ($firma->firmentyp_kurzbz == $row->firmentyp_kurzbz ? ' selected ' : '') . ">" . $row->firmentyp_kurzbz . "</option>";
}
}
$htmlstr .= "</select></td>";
$htmlstr .= "<td> </td>";
$htmlstr .= "<td>Name: </td>";
$htmlstr .= "<td><input type='text' name='name' value='" . $firma->name . "' size='80' maxlength='128' /></td>\n";
$htmlstr .= "<td align='center' width='20%'><input type='submit' name='save' value='speichern'></td>\n";
$htmlstr .= "</tr></table></td>";
$htmlstr .= "</tr>\n";
$htmlstr .= "<tr><td><table><tr>\n";
$htmlstr .= "<td>Steuernummer: </td>";
$htmlstr .= "<td><input size='32' maxlength='32' type='text' name='steuernummer' value='" . $firma->steuernummer . "'></td>\n";
$htmlstr .= "<td> </td>";
$htmlstr .= "<td>Finanzamt: </td>";
// Finanzamt anzeige und suche
$firma_finanzamt = new firma();
$firmentyp_finanzamt = 'Finanzamt';
$firma_finanzamt->searchFirma('', $firmentyp_finanzamt, true);
$htmlstr .= "<td><select name='finanzamt'>";
$htmlstr .= "<option value=''>-- keine Auswahl --</option>";
foreach ($firma_finanzamt->result as $row_finanzamt) {
if ($firma->finanzamt == $row_finanzamt->standort_id) {
$selected = 'selected="true"';
} else {
$selected = '';
}
$htmlstr .= "\t<option value='" . $row_finanzamt->standort_id . "' " . $selected . ">" . $row_finanzamt->name . ' - ' . $row_finanzamt->bezeichnung . " </option>";
}
$htmlstr .= "</select></td>\n";
$htmlstr .= "<td>Aktiv: </td>";
$htmlstr .= "<td><input " . ($firma->aktiv ? ' style="background-color: #E3FDEE;" ' : ' style="background-color: #FFF4F4;" ') . " type='checkbox' name='aktiv' " . ($firma->aktiv ? 'checked' : '') . "></td>\n";
$htmlstr .= "<td> </td>\n";
$htmlstr .= "<td>Gesperrt: </td>";
$disabled = 'disabled=true';
//Gesperrt Hackerl darf nur gesetzt werden wenn die Berechtigung vorhanden ist
if ($rechte->isBerechtigt('basis/firma', null, 'suid')) {
$disabled = '';
}
$htmlstr .= "<td><input type='checkbox' name='gesperrt' " . ($firma->gesperrt ? 'checked' : '') . " {$disabled}></td>\n";
$htmlstr .= "<td> </td>\n";
$htmlstr .= "<td>Schule:</td>";
$htmlstr .= "<td><input " . ($firma->schule ? ' style="background-color: #E3FDEE;" ' : ' style="background-color: #FFF4F4;" ') . " type='checkbox' name='schule' " . ($firma->schule ? 'checked' : '') . "> </td>";
$htmlstr .= "<td> </td>";
$htmlstr .= "</tr>";
$htmlstr .= "<tr>";
$htmlstr .= "<td title='Trennung mehrerer Tags durch ;'>Tags:</td><td><input type='text' id='tags' name='tags' size='32'>";
/* $htmlstr.="<script type='text/javascript' language='JavaScript1.2'>
$('#tags').autocomplete('stammdaten_autocomplete.php',
{
minChars:1,
matchSubset:1,matchContains:1,
width:400,
multiple: true,
multipleSeparator: '; ',
extraParams:{'work':'tags'}
});
</script>"; */
$htmlstr .= "<script type='text/javascript'>\n \$(document).ready(function()\n {\n \$('#tags').autocomplete({\n source: 'stammdaten_autocomplete.php?work=tags', \n minLength:1,\n response: function(event, ui)\n {\n for(i in ui.content)\n {\n ui.content[i].value=ui.content[i].tag;\n ui.content[i].label=ui.content[i].tag;\n }\n },\n select: function(event, ui)\n {\n ui.item.value=ui.item.tag;\n }\n\t\t\t\t});\n });\n </script>";
$htmlstr .= "</td>";
$htmlstr .= "<td> </td>";
$htmlstr .= "<td colspan='9'>";
foreach ($firma->tags as $tag) {
$htmlstr .= ' ' . $tag . '<a href="firma_details.php?firma_id=' . $firma->firma_id . '&deletetag=true&tag=' . urlencode($tag) . '" title="entfernen"> <img src="../../skin/images/DeleteIcon.png" /></a>';
}
$htmlstr .= "</td></tr></table></td>";
$htmlstr .= "</tr>\n";
$htmlstr .= "\t</table>\n";
$htmlstr .= "</form>\n";
$htmlstr .= '<div id="addFirmaInfo"></div>';
$htmlstr .= '
<!-- Tabs -->
<div id="tabs" style="font-size:80%;">
<ul class="css-tabs">
<li><a href="#standort">Standorte</a></li>
<li><a href="#organisationseinheit">Organisationseinheit</a></li>
<li><a href="#mobilitaetsprogramm">Mobilitätsprogramm</a></li>
<li><a href="#anmerkung">Anmerkungen</a></li>
</ul>
<div id="standort">
' . getStandortliste($firma_id, $adresstyp_arr, $user) . '
</div>
<div id="organisationseinheit">
' . getOrganisationsliste($firma_id, $adresstyp_arr, $user) . '
</div>
<div id="mobilitaetsprogramm">
' . getMobilitaetsprogrammliste($firma_id, $user) . '
</div>
<div id="anmerkung">
' . getAnmerkungen($firma_id, $user) . '
</div>
</div>
<div id="detailstandort"> </div>
';
return $htmlstr;
}
}
$item['artikelnummer'] = html_entity_decode($row->artikelnummer);
$item['preisprove'] = html_entity_decode(number_format($row->preisprove, 2));
$item['menge'] = html_entity_decode($row->menge);
$result[] = $item;
// echo html_entity_decode($row->bestelldetail_id).'|'.', '.html_entity_decode($row->beschreibung).', '.html_entity_decode($row->artikelnummer).' Preis VE '.html_entity_decode(number_format($row->preisprove,2)).', Menge '.html_entity_decode($row->menge)."\n";
}
echo json_encode($result);
break;
// Firmen Search
// Firmen Search
case 'wawi_firma_search':
$firma_search = trim(isset($_REQUEST['term']) ? $_REQUEST['term'] : '');
if (is_null($firma_search) || $firma_search == '') {
exit;
}
$firma = new firma();
$firma->searchFirma($firma_search);
$result = array();
foreach ($firma->result as $row) {
$item['firma_id'] = html_entity_decode($row->firma_id);
$item['name'] = html_entity_decode($row->name);
$result[] = $item;
// echo html_entity_decode($row->firma_id).'|'.', '.html_entity_decode($row->name)."\n";
}
echo json_encode($result);
break;
default:
echo " Funktion {$work} fehlt! ";
break;
}
exit;
require_once '../../config/vilesci.config.inc.php';
require_once '../../include/functions.inc.php';
require_once '../../include/benutzerberechtigung.class.php';
require_once '../../include/person.class.php';
require_once '../../include/datum.class.php';
require_once '../../include/adresse.class.php';
require_once '../../include/nation.class.php';
require_once '../../include/firma.class.php';
require_once '../../include/standort.class.php';
require_once '../../include/kontakt.class.php';
$user = get_uid();
$datum_obj = new datum();
loadVariables($user);
if (isset($_GET['getfirma'])) {
$firma = new firma();
$firma->searchFirma($_GET['q']);
foreach ($firma->result as $row) {
echo $row->name . '|' . $row->firma_id . "\n";
}
exit;
}
if (isset($_GET['getstandort'])) {
if (isset($_GET['firma_id']) && is_numeric($_GET['firma_id'])) {
$standort = new standort();
$standort->load_firma($_GET['firma_id']);
$arr = array();
foreach ($standort->result as $row) {
array_push($arr, array('kurzbz' => $row->bezeichnung, 'standort_id' => $row->standort_id));
}
echo json_encode($arr);
}
return true;
}
</script>';
}
//Suchen von Firmen
if ($method == 'search') {
$filter = isset($_POST['filter']) ? $_POST['filter'] : '';
echo '<H1>Firma suchen</H1>';
echo '<form action="' . $_SERVER['PHP_SELF'] . '?method=search" method="POST">';
echo '<input type="text" size="30" name="filter" value="' . $filter . '">';
echo ' <input type="submit" name="send" value="Suchen">';
echo '</form>';
if ($filter != '') {
$firma = new firma();
if ($firma->searchFirma($filter)) {
echo '<br /><br />
<script type="text/javascript">
$(document).ready(function()
{
$("#myTable").tablesorter(
{
sortList: [[2,0]],
widgets: ["zebra"]
});
});
</script>
<table id="myTable" class="tablesorter">
<thead>
<tr>
function creatList($suchen, $filter, $firmentypfilter)
{
// Initialisieren HTML Listenausgabe
$htmlstr = "";
$firma_finanzamt = new firma();
$firmentyp_finanzamt = 'Finanzamt';
$firma_finanzamt->errormsg = '';
$firma_finanzamt->result = array();
//echo "Filter: ".$filter." Firmentypfilter: ".$firmentypfilter."<br>";
if (!is_null($suchen)) {
// Nur wenn Suchknopf gedrueckt wurde
$firma_finanzamt->searchFirma($filter, $firmentypfilter);
}
if ($firma_finanzamt->errormsg) {
return 'Fehler beim Laden der Firma<br>';
}
if ($firma_finanzamt->result) {
$htmlstr .= "</form><table id='t1' class='liste table-autosort:1 table-stripeclass:alternate table-autostripe'>\n";
$htmlstr .= " <thead><tr class='liste'>\n";
$htmlstr .= " <th class='table-sortable:numeric'>ID</th>";
$htmlstr .= " <th class='table-sortable:default'>Name</th>";
$htmlstr .= " <th class='table-sortable:default'>Anmerkung</th>";
$htmlstr .= " <th class='table-sortable:default'>Kurzbz</th>";
$htmlstr .= " <th class='table-sortable:default'>Standort</th>";
$htmlstr .= " <th class='table-sortable:default'>Plz</th>";
$htmlstr .= " <th class='table-sortable:default'>Ort</th>";
$htmlstr .= " <th class='table-sortable:default'>Strasse</th>";
$htmlstr .= " <th class='table-sortable:default'>Typ</th>";
$htmlstr .= " <th class='table-sortable:default'>Aktiv</th>";
$htmlstr .= " <th class='table-sortable:default'>Gesperrt</th>";
$htmlstr .= " <th class='table-sortable:default'>Schule</th>";
//$htmlstr .= " <th class='table-sortable:default'>Ext ID</th>";
$htmlstr .= " </tr></thead><tbody>\n";
$i = 0;
foreach ($firma_finanzamt->result as $row) {
// Adresse
$row->adresse_neu = $row->plz . ' ' . $row->ort;
$htmlstr .= " <tr class='liste" . $i % 2 . "'>\n";
$htmlstr .= " <td><a onclick=\"parent.frames[2].location.href ='firma_detailwork.php';\" href='firma_details.php?firma_id=" . $row->firma_id . "' target='detail_firma'>" . $row->firma_id . "</a></td>\n";
$htmlstr .= " <td><a onclick=\"parent.frames[2].location.href ='firma_detailwork.php';\" href='firma_details.php?firma_id=" . $row->firma_id . "' target='detail_firma'>" . $row->name . "</a></td>\n";
$htmlstr .= " <td title='" . $row->anmerkung . "'>" . StringCut($row->anmerkung, 27) . "</td>\n";
$htmlstr .= " <td>" . $row->kurzbz . "</td>\n";
$htmlstr .= " <td>" . StringCut($row->bezeichnung, 27) . "</td>\n";
// Adresse
$htmlstr .= " <td>{$row->plz}</td>\n";
$htmlstr .= " <td>{$row->ort}</td>\n";
$htmlstr .= " <td>{$row->strasse}</td>\n";
$htmlstr .= " <td>{$row->firmentyp_kurzbz}</td>\n";
$htmlstr .= " <td>" . ($row->aktiv == 't' ? 'Ja' : 'Nein') . "</td>\n";
$htmlstr .= " <td>" . ($row->gesperrt == 't' ? 'Ja' : 'Nein') . "</td>\n";
$htmlstr .= " <td>" . ($row->schule == 't' ? 'Ja' : 'Nein') . "</td>\n";
//$htmlstr .= " <td>$row->ext_id</td>\n";
$htmlstr .= " </tr>\n";
$i++;
}
$htmlstr .= "</tbody></table>\n";
}
return $htmlstr;
}
