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