Esempio n. 1
0
    public function update($data, $catalogID = 0)
    {
        if (!(isset($data['Title']) && strlen(trim($data['Title'])) > 0)) {
            throw new Exception(lang('data_empty', __CLASS__));
        }
        $db = MySQL::getInstance();
        $queryStr = "";
        if ($imageName = File::upload('var/catalog/')) {
            $this->deleteFile($catalogID);
            //			if (File::copy($imageName, 'thumb_' . $imageName, 'var/catalog/')) {
            //				File::imageResize('thumb_' . $imageName, 'var/catalog/', 175, 175);
            //			}
            if (File::copy($imageName, 'tmb/' . $imageName, 'var/catalog/')) {
                File::imageResize($imageName, 'var/catalog/tmb/', 100, 100);
            }
            File::imageResize($imageName, 'var/catalog/', 800, 600);
            $queryStr .= ', `Image` = ' . $db->escape($imageName);
        }
        $status = isset($this->aStatus[$data['Status']]) ? $data['Status'] : 'show';
        $db->query('UPDATE `catalog` SET
				`Status` = ' . $db->escape($status) . ',
				`Title` = ' . $db->escape($data['Title'], 125) . ',
				`PropertyID` = ' . $db->escape((int) $data['PropertyID']) . ',
				`MetaTitle` = ' . $db->escape($data['MetaTitle'], 125) . ',
				`Content2` = ' . $db->escape($data['Content2']) . ',
				`Description` = ' . $db->escape($data['Description']) . ',
				`Code` = ' . $db->escape($data['Code']) . ',
			    `Price` = ' . $db->escape((int) $data['Price']) . ',
			     `Ed` = ' . $db->escape($data['Ed']) . ',

				`Content` = ' . $db->escape($data['Content']) . '
				' . $queryStr . '
			WHERE ItemID = ' . $db->escape((int) $catalogID));
        $oImage = new Catalog_Image();
        if (($imageList = File::upload('var/catalog/gallery/', 'Gallery', false)) !== false) {
            $oImage->insert($imageList, $catalogID, $data['Gallery']);
        }
        //		$oConsistency = new Catalog_Consistency();
        //		$oConsistency->insertItems($data['ConsistencyID'], $catalogID);
        return $catalogID;
    }