1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67
|
<?php
$db = new PDO('mysql:host=localhost;dbname=dpazine', 'root', '');
$db->exec('SET NAMES utf8');
class Application_Model_Parts {
public $language = 6;
function __construct() {
$this->db = $db;
}
public function retrieveVendors($asArray = false) {
$sql = "SELECT
MFA_ID,
MFA_BRAND
FROM
`manufacturers`
ORDER BY
MFA_BRAND
# LIMIT
# 100
;";
$result = $this->db->query ( $sql );
if (! $asArray) {
return $result->fetchAll ();
} else {
$vendorList = array ();
foreach ( $result->fetchAll () as $vendor ) {
$vendorList [$vendor ['MFA_ID']] = $vendor ['MFA_BRAND'];
}
return $vendorList;
}
}
*/
public function retrieveVendorModels($vendor_id, $asArray = false) {
if (( int ) $vendor_id) {
$sql = "SELECT MOD_ID, TEX_TEXT AS MOD_CDS_TEXT, MOD_PCON_START, MOD_PCON_END, MOD_PC, MOD_CV
FROM
models
INNER JOIN country_designations ON CDS_ID = MOD_CDS_ID
INNER JOIN des_texts ON TEX_ID = CDS_TEX_ID
WHERE
MOD_MFA_ID = $vendor_id AND
CDS_LNG_ID = $this->language
ORDER BY
MOD_CDS_TEXT;";
$result = $this->db->query ( $sql );
if (! $asArray) {
return $result->fetchAll ();
} else {
$modelList = array ();
foreach ( $result->fetchAll () as $model ) {
$modelList [$model ['MOD_ID']] = $model ['MOD_CDS_TEXT'] . ' [' . substr($model['MOD_PCON_START'],0,4) . ' - '. substr($model['MOD_PCON_END'],0,4) . ']';
}
return $modelList;
}
} else {
throw new Zend_Exception ( 'No vendor is set' );
}
} |
Partager