Subversion-Projekte lars-tiefland.ci

Revision

Revision 2283 | Revision 2286 | Zur aktuellen Revision | Ganze Datei anzeigen | Leerzeichen ignorieren | Details | Blame | Letzte Änderung | Log anzeigen | RSS feed

Revision 2283 Revision 2285
Zeile 3... Zeile 3...
3 
/**
 3 
/**
4 
 *
 4 
 *
5 
 * @package WebanOS CI
 5 
 * @package WebanOS CI
6 
 * @author Lars Tiefland <ltiefland@gmail.com>
6 
 * @author Lars Tiefland <ltiefland@gmail.com>
7 
 * @copyright 2016
 7 
 * @copyright 2016
8 
 * @version $Rev: 2283 $
 8 
 * @version $Rev: 2285 $
9 
 */
 9 
 */
Zeile 10... Zeile 10...
10 
 
 10 
 
11 
class Logistiker_model extends CI_Model
 11 
class Logistiker_model extends CI_Model
12 
{
 12 
{
Zeile 52... Zeile 52...
52 
 
 52 
 
Zeile 53... Zeile 53...
53 
	}
 53 
	}
54 
 
 54 
 
55 
	public function tracking($id)
 55 
	public function tracking($id)
- 
 
 56 
	{
- 
 
 57 
		$sWhere = "";
- 
 
 58 
		if ($GET['sSearch'] != "") {
- 
 
 59 
			$sWhere = "WHERE (";
- 
 
 60 
			for ($i = 0; $i < count($aColumns); $i++) {
- 
 
 61 
				if ($aColumns[$i] == "datum") {
- 
 
 62 
					$a = " from_unixtime(datum) ";
56 
	{
 63 
					$sWhere .= $a . " LIKE '%" . mysql_real_escape_string($GET['sSearch']) .
- 
 
 64 
						"%' OR ";
- 
 
 65 
				} else {
57 
		$sql = "
 66 
					$sWhere .= $aColumns[$i] . " LIKE '%" . mysql_real_escape_string($GET['sSearch']) .
- 
 
 67 
						"%' OR ";
58 
			SELECT
 68 
				}
- 
 
 69 
 
- 
 
 70 
			}
- 
 
 71 
			$sWhere = substr_replace($sWhere, "", -3);
- 
 
 72 
			$sWhere .= ')';
- 
 
 73 
		}
- 
 
 74 
 
- 
 
 75 
		/* Individual column filtering */
- 
 
 76 
		for ($i = 0; $i < count($aColumns); $i++) {
59 
				*
 77 
			if ($GET['bSearchable_' . $i] == "true" && $GET['sSearch_' . $i] != '') {
60 
			FROM
 78 
				if ($sWhere == "") {
61 
				bestellung_paketnummern
 79 
					$sWhere = "WHERE ";
- 
 
 80 
				} else {
- 
 
 81 
					$sWhere .= " AND ";
- 
 
 82 
				}
- 
 
 83 
				if ($aColumns[$i] == "datum") {
62 
			WHERE
 84 
					$r = " from_unixtime(datum) ";
- 
 
 85 
					$sWhere .= $r . " LIKE '%" . mysql_real_escape_string($GET['sSearch_' . $i]) .
- 
 
 86 
						"%' ";
63 
				logistiker=" . $id . "
 87 
				} else {
- 
 
 88 
					$sWhere .= $r . " LIKE '%" . mysql_real_escape_string($GET['sSearch_' . $i]) .
- 
 
 89 
						"%' ";
64 
			ORDER BY
 90 
				}
- 
 
 91 
 
- 
 
 92 
			}
- 
 
 93 
		}
- 
 
 94 
 
- 
 
 95 
		if (empty($sWhere)) {
- 
 
 96 
			$sWhere = " where bp.logistiker=l.id AND l.id = $id ";
- 
 
 97 
		} else {
- 
 
 98 
			$sWhere = " $sWhere and bp.logistiker=l.id AND l.id = $id ";
- 
 
 99 
		}
- 
 
 100 
		$sQuery = "SELECT
- 
 
 101 
                    SQL_CALC_FOUND_ROWS
- 
 
 102 
                    bp.*,
- 
 
 103 
                    l.kname,
- 
 
 104 
                    l.trackinglink
- 
 
 105 
                FROM
- 
 
 106 
                    logistiker l,
- 
 
 107 
                    bestellung_paketnummern bp
- 
 
 108 
 
- 
 
 109 
                    $sWhere
- 
 
 110 
 
- 
 
 111 
                    $sOrder
- 
 
 112 
                        $sLimit
- 
 
 113 
                ";
- 
 
 114 
		//echo $sQuery;
- 
 
 115 
		$rResult = mysql_query($sQuery);
- 
 
 116 
 
- 
 
 117 
		/* Data set length after filtering */
- 
 
 118 
		$sQuery = "
- 
 
 119 
                        SELECT FOUND_ROWS() AS total
- 
 
 120 
                ";
- 
 
 121 
		$rResultFilterTotal = $this->order_db->query($sQuery);
- 
 
 122 
		$aResultFilterTotal = $aResultFilterTotal->unbuffered_row('array');
- 
 
 123 
		$iFilteredTotal = $aResultFilterTotal["total"];
- 
 
 124 
 
- 
 
 125 
		/* Total data set length */
- 
 
 126 
		$sQuery = "
- 
 
 127 
                        SELECT
- 
 
 128 
                    COUNT(" . $sIndexColumn . ") AS total
- 
 
 129 
                FROM
- 
 
 130 
                    logistiker l,
- 
 
 131 
                    bestellung_paketnummern bp
- 
 
 132 
                WHERE
- 
 
 133 
                    bp.logistiker=l.id
- 
 
 134 
                AND
- 
 
 135 
                    l.id = $id
- 
 
 136 
                ";
65 
				datum DESC
 137 
 
- 
 
 138 
 
- 
 
 139 
		$rResultTotal = $this->order_db->query($sQuery);
- 
 
 140 
		$aResultTotal = $aResultTotal->unbuffert_row('array');
- 
 
 141 
		$iTotal = $aResultTotal["total"];
- 
 
 142 
 
- 
 
 143 
 
- 
 
 144 
		/*
- 
 
 145 
		* Output
- 
 
 146 
		*/
- 
 
 147 
		$output = array(
- 
 
 148 
			"sEcho" => intval($_GET['sEcho']),
- 
 
 149 
			"iTotalRecords" => $iTotal,
- 
 
 150 
			"iTotalDisplayRecords" => $iFilteredTotal,
66 
		";
 151 
			"aaData" => array());
- 
 
 152 
 
- 
 
 153 
		while ($aRow = $rResult->unbuffered_row('array')) {
- 
 
 154 
 
- 
 
 155 
			//$aRow['datum'] = strtotime($aRow['datum']);
- 
 
 156 
			$aRow['datum'] = date('d.m.Y', $aRow['datum']);
- 
 
 157 
			$aRow['bestellung'] = ' <a href="/Warenwirtschaft/bestellungen.php?Bestellung=' .
- 
 
 158 
				$aRow['bestellung'] . '">zum Vorgang</a>';
- 
 
 159 
 
- 
 
 160 
			$url = $aRow["trackinglink"];
- 
 
 161 
			if (stristr($url, "%")) {
- 
 
 162 
				$tag = date("d", $row_p["datum"]);
67 
		$res = $this->db->query($sql);
 163 
				$monat = date("m", $row_p["datum"]);
- 
 
 164 
				$jahr = date("Y", $row_p["datum"]);
- 
 
 165 
				$url = str_replace("%tag%", $tag, $url);
- 
 
 166 
				$url = str_replace("%monat%", $monat, $url);
- 
 
 167 
				$url = str_replace("%jahr%", $jahr, $url);
- 
 
 168 
				$url = str_replace("%trackingnr%", $aRow["paketnummer"], $url);
- 
 
 169 
			} else {
- 
 
 170 
				$url .= $aRow["paketnummer"];
- 
 
 171 
			}
- 
 
 172 
 
- 
 
 173 
 
- 
 
 174 
			$aRow["paketnummer"] = $aRow["kname"] . ': <a href=' . $url . ' target=_blank>' .
- 
 
 175 
				$aRow["paketnummer"] . '</a>';
- 
 
 176 
			$row = array();
- 
 
 177 
			for ($i = 0; $i < count($aColumns); $i++)
- 
 
 178 
				if ($aColumns[$i] == "version") {
- 
 
 179 
					/* Special output formatting for 'version' column */
- 
 
 180 
					$row[] = ($aRow[$aColumns[$i]] == "0") ? '-' : $aRow[$aColumns[$i]];
- 
 
 181 
				} else
- 
 
 182 
					if ($aColumns[$i] != ' ') {
- 
 
 183 
						/* General output */
68 
		while ($row = $res->unbuffered_row('array')) {
 184 
						$row[] = $aRow[$aColumns[$i]];
- 
 
 185 
					}
- 
 
 186 
		}
69 
			$trackingNr["aaData"][] = $row;
 187 
		$output['aaData'][] = $row;
- 
 
 188 
 
- 
 
 189 
		return json_encode($output);
- 
 
 190 
	}
- 
 
 191 
 
- 
 
 192 
	public function getexportjson($sLimit, $sOrder, $sWhere, $id, $aColumns, $sIndexColumn,
- 
 
 193 
		$echo)
- 
 
 194 
	{
- 
 
 195 
 
- 
 
 196 
		$sQuery = "SELECT DISTINCT
- 
 
 197 
                    exported
- 
 
 198 
                FROM
- 
 
 199 
                    artikel_to_Bestellung ab
- 
 
 200 
                JOIN
- 
 
 201 
                    bestellung_logistiker bl
- 
 
 202 
                ON
- 
 
 203 
                    bl.logistiker=$id
- 
 
 204 
                AND
- 
 
 205 
                    bl.bestellung = ab.Bestellung
- 
 
 206 
                WHERE
- 
 
 207 
                    exported
- 
 
 208 
 
- 
 
 209 
                $sWhere
- 
 
 210 
                $sOrder
- 
 
 211 
                $sLimit
- 
 
 212 
            ";
- 
 
 213 
 
- 
 
 214 
		$rResult = $this->order_db->query($sQuery);
- 
 
 215 
 
- 
 
 216 
		/* Data set length after filtering */
- 
 
 217 
		$sQuery = "
- 
 
 218 
                        SELECT FOUND_ROWS() AS total
- 
 
 219 
                ";
- 
 
 220 
		$rResultFilterTotal = $this->order_db->query($sQuery);
- 
 
 221 
		$aResultFilterTotal = $aResultFilterTotal->unbuffered_row('array');
- 
 
 222 
		$iFilteredTotal = $aResultFilterTotal["total"];
- 
 
 223 
 
- 
 
 224 
		/* Total data set length */
- 
 
 225 
		$sQuery = "
- 
 
 226 
                        SELECT
- 
 
 227 
                    COUNT(" . $sIndexColumn . ") AS total
- 
 
 228 
                FROM
- 
 
 229 
                    artikel_to_Bestellung ab
- 
 
 230 
                JOIN
- 
 
 231 
                    bestellung_logistiker bl
- 
 
 232 
                ON
- 
 
 233 
                    bl.logistiker=$id
- 
 
 234 
                AND
- 
 
 235 
                    bl.bestellung = ab.Bestellung
- 
 
 236 
                WHERE
- 
 
 237 
                    exported
- 
 
 238 
                ";
- 
 
 239 
		$rResultTotal = $this->order_db->query($sQuery);
- 
 
 240 
		$aResultTotal = $aResultTotal->unbuffert_row('array');
- 
 
 241 
		$iTotal = $aResultTotal["total"];
- 
 
 242 
 
- 
 
 243 
 
- 
 
 244 
		/*
- 
 
 245 
		* Output
- 
 
 246 
		*/
- 
 
 247 
		$output = array(
- 
 
 248 
			"sEcho" => intval($echo['sEcho']),
- 
 
 249 
			"iTotalRecords" => $iTotal,
- 
 
 250 
			"iTotalDisplayRecords" => $iTotal,
- 
 
 251 
			"aaData" => array());
- 
 
 252 
 
- 
 
 253 
		$sql = "SELECT
- 
 
 254 
                    export_script
- 
 
 255 
                FROM
- 
 
 256 
                    logistiker
- 
 
 257 
                WHERE
- 
 
 258 
                    id = " . $id . "
- 
 
 259 
            ";
- 
 
 260 
		$res = $this->order_db->query($sql);
- 
 
 261 
		$nrow = $res->unbuffered_row('array');
- 
 
 262 
		if (strstr($nrow["export_script"], "=")) {
- 
 
 263 
			$qs = explode(";", $nrow["export_script"]);
- 
 
 264 
			foreach ($qs as $val) {
- 
 
 265 
				list($key, $wert) = explode("=", $val);
- 
 
 266 
				if ($key == "mode") {
- 
 
 267 
					$qsArr[] = "mode=" . $wert;
- 
 
 268 
				} elseif (is_null($wert)) {
- 
 
 269 
					$script = $key;
- 
 
 270 
				} elseif (!stristr($key, "status") && $wert) {
- 
 
 271 
					$qsArr[] = "$key=" . $wert;
- 
 
 272 
				}
- 
 
 273 
			}
- 
 
 274 
			$qs = implode("&", $qsArr);
- 
 
 275 
		} else {
- 
 
 276 
			list($script, $mode) = explode(";", $nrow["export_script"]);
- 
 
 277 
			$qs = "mode=" . $mode;
- 
 
 278 
		}
- 
 
 279 
		while ($aRow = $rResult->unbuffered_row('array')) {
- 
 
 280 
			$aRow['exported'] = '<a href="/Warenwirtschaft/' . $script . '?time=' . $aRow['exported'] .
- 
 
 281 
				'&id=' . $id . '&' . $qs . '" target="_blank">' . date('d.m.Y H:i:s', strtotime
- 
 
 282 
				($aRow['exported'])) . '</a>';
- 
 
 283 
			$row = array();
- 
 
 284 
			for ($i = 0; $i < count($aColumns); $i++) {
- 
 
 285 
				if ($aColumns[$i] == "version") {
- 
 
 286 
					/* Special output formatting for 'version' column */
- 
 
 287 
					$row[] = ($aRow[$aColumns[$i]] == "0") ? '-' : $aRow[$aColumns[$i]];
- 
 
 288 
				} else
- 
 
 289 
					if ($aColumns[$i] != ' ') {
- 
 
 290 
						/* General output */
- 
 
 291 
						$row[] = $aRow[$aColumns[$i]];
- 
 
 292 
					}
- 
 
 293 
			}
- 
 
 294 
			$output['aaData'][] = $row;
70 
		}
 295 
		}
71 
		$trackingNr = json_encode($trackingNr);
 296 
 
72 
		return $trackingNr;
 297 
		return json_encode($output);
Zeile 73... Zeile 298...
73 
	}
 298 
	}