Example #1
0
 protected function _filterSql()
 {
     $date = new Zend_Date();
     if (isset($this->filterdata['created_by']) && !empty($this->filterdata['created_by'])) {
         $this->_select->where("p.created_by = (?)", new Zend_Db_Expr("SELECT id FROM public.user WHERE upper(login) ilike '" . strtoupper($this->filterdata['created_by'] . "'")));
     }
     if (isset($this->filterdata['name']) && !empty($this->filterdata['name'])) {
         $this->_select->where("p.name ilike ?", $this->filterdata['name']);
     }
     if (isset($this->filterdata['date_for']) && !empty($this->filterdata['date_for'])) {
         $this->filterdata['date_for'] = $date->setDate($this->filterdata['date_for'], 'YYYY-MM-dd')->toString(Zend_Date::ISO_8601);
     }
     if (isset($this->filterdata['date_to']) && !empty($this->filterdata['date_to'])) {
         $this->filterdata['date_to'] = $date->setDate($this->filterdata['date_to'], 'YYYY-MM-dd')->toString(Zend_Date::ISO_8601);
     }
     if (isset($this->filterdata['date_for']) && !empty($this->filterdata['date_for']) && isset($this->filterdata['date_to']) && !empty($this->filterdata['date_to'])) {
         $this->_select->where('created_at BETWEEN \'' . $this->filterdata['date_for'] . '\' AND \'' . $this->filterdata['date_to'] . '\'');
     } elseif (isset($this->filterdata['date_for']) && !empty($this->filterdata['date_for'])) {
         $this->_select->where('created_at > ?', $this->filterdata['date_for']);
     } elseif (isset($this->filterdata['date_to']) && !empty($this->filterdata['date_to'])) {
         $this->_select->where('created_at < ?', $this->filterdata['date_to']);
     }
     if (isset($this->filterdata['ws_service_set_id']) && !empty($this->filterdata['ws_service_set_id'])) {
         $this->_select->where("ws_service_set_id = ?", $this->filterdata['ws_service_set_id']);
     }
     if (isset($this->filterdata['ws_service_group_id']) && !empty($this->filterdata['ws_service_group_id'])) {
         $this->_select->where("ws_service_group_id = ?", $this->filterdata['ws_service_group_id']);
     }
 }
Example #2
0
 /**
  * Retrieve Bestseller product to show in frontend
  * @return mixed
  */
 public function myBest()
 {
     $storeId = Mage::app()->getStore()->getId();
     $HandleArray = Mage::app()->getLayout()->getUpdate()->getHandles();
     $CategoryHandle = 'catalog_category_view';
     $SourceConfig = Mage::getStoreConfig('sm_bestseller/sm_bestseller_source');
     if ($SourceConfig && !empty($SourceConfig)) {
         $SourceType = $SourceConfig['timeperiod'];
         $date = new Zend_Date();
         /**
          * Select time range to retrive bestseller
          */
         if ($SourceType && $SourceType == 'specify') {
             $fromDate = $date->setDate($SourceConfig['fromdate'])->get('Y-MM-dd');
             $toDate = $date->setDate($SourceConfig['todate'])->get('Y-MM-dd');
         } else {
             /**
              * use switch to return begin of week, month, year...
              */
             switch ($SourceType) {
                 case 'subWeek':
                     $toDate = $date->subDay($date->getDate()->get('e'))->getDate()->get('Y-MM-dd');
                     break;
                 case 'subMonth':
                     $toDate = $date->setDay(1)->getDate()->get('Y-MM-dd');
                     break;
                 case 'subYear':
                     $toDate = $date->subDay($date->getDate()->get('D'))->getDate()->get('Y-MM-dd');
                     break;
                 default:
                     $toDate = $date->getDate()->get('Y-MM-dd');
             }
             // end switch
             $subType = $SourceType;
             $unit = $SourceConfig['unit'] ? $SourceConfig['unit'] : 1;
             $fromDate = $date->{$subType}($unit)->getDate()->get('Y-MM-dd');
         }
         // end else
         /**
          * Limit maximum product retrieve
          */
         $limit = $SourceConfig['limitproduct'];
         if ($limit > 0 && ctype_digit($limit)) {
             $this->setProductsCount($limit);
         }
         $products = Mage::getResourceModel('reports/product_collection')->addOrderedQty($fromDate, $toDate)->addAttributeToSelect('*')->addAttributeToSelect(array('name', 'price', 'small_image'))->setStoreId($storeId)->addStoreFilter($storeId)->setOrder('ordered_qty', 'desc');
         // most best sellers on top
         Mage::getSingleton('catalog/product_status')->addVisibleFilterToCollection($products);
         Mage::getSingleton('catalog/product_visibility')->addVisibleInCatalogFilterToCollection($products);
         $products->setPageSize($limit)->setCurPage(1);
         if (in_array($CategoryHandle, $HandleArray)) {
             $CategoryId = Mage::getModel('catalog/layer')->getCurrentCategory()->getId();
             $CategoryModel = Mage::getModel('catalog/category')->load($CategoryId);
             $products->addCategoryFilter($CategoryModel);
         }
         return $products;
     }
     // end if sourceconfig
 }
Example #3
0
 public function downloadAction()
 {
     $this->_helper->viewRenderer->setNoRender(true);
     $this->_helper->layout->disableLayout();
     $request = $this->getRequest();
     $start = $this->_helper->IdConvert->hexToStr($request->getParam('date_for'));
     $end = $this->_helper->IdConvert->hexToStr($request->getParam('date_to'));
     $date = new Zend_Date();
     if (empty($start) || empty($end) || (!$date->setDate($start, "YYYY-MM-dd")->isDate($start, "YYYY-MM-dd") || !$date->setDate($end, "YYYY-MM-dd")->isDate($end, "YYYY-MM-dd"))) {
         $this->_helper->messenger()->error("Nie podano zakresu dat");
         return $this->_helper->redirector('index');
     }
     $logic = new Logic_Raports_Render($start, $end, $this->_helper->currentip());
     $logic->render();
 }
Example #4
0
 /**
  * 
  */
 public function listAvisos($curso)
 {
     try {
         $auth = Zend_Auth::getInstance();
         $parameters = array('usuario' => $auth->getIdentity()->codigo, 'curso' => $curso);
         // Cria hash de comunicacao
         $parameters['hash'] = App_Util_Cenbrap::getHash($parameters, array('usuario', 'curso'));
         // Faz requisição para API
         $response = App_Util_Cenbrap::request('MuralAvisos', $parameters);
         if (empty($response['status'])) {
             throw new Exception('Erro ao listar mural de avisos');
         }
         $avisos = array();
         $date = new Zend_Date();
         foreach ($response['avisos'] as $aviso) {
             if (!empty($aviso['data'])) {
                 $date->setDate($aviso['data'], 'dd/MM/yyyy');
                 $avisos[$date->toString('yyyy-MM-dd')][] = $aviso;
             }
         }
         ksort($avisos);
         $avisos = array_reverse($avisos);
         return $avisos;
     } catch (Exception $e) {
         $this->_message->addMessage($e->getMessage(), App_Message::WARNING);
         return array();
     }
 }
Example #5
0
 /**
  * 
  * @return int|bool
  */
 public function save()
 {
     $dbAdapter = Zend_Db_Table_Abstract::getDefaultAdapter();
     $dbAdapter->beginTransaction();
     try {
         $dataForm = $this->_data;
         $dataForm['client'] = array_keys($this->_data['cost_client']);
         $mapperRule = new Fefop_Model_Mapper_Rule();
         $mapperRule->validate($this->_message, $dataForm, Fefop_Model_Mapper_Expense::CONFIG_PFPCI_FP);
         // If there is no contract yet
         if (empty($this->_data['fk_id_fefop_contract'])) {
             $dataContract = array('module' => Fefop_Model_Mapper_Module::FP, 'district' => $this->_data['fk_id_adddistrict']);
             $mapperFefopContract = new Fefop_Model_Mapper_Contract();
             $this->_data['fk_id_fefop_contract'] = $mapperFefopContract->save($dataContract);
         }
         $this->_data['amount'] = App_General_String::toFloat($this->_data['amount']);
         $date = new Zend_Date();
         $this->_data['date_start'] = $date->setDate($this->_data['start_date'])->toString('yyyy-MM-dd');
         $this->_data['date_finish'] = $date->setDate($this->_data['finish_date'])->toString('yyyy-MM-dd');
         $dataForm = $this->_data;
         // Save the contract
         $dataForm['id_fp_contract'] = parent::_simpleSave();
         // Set the class to the Planning Course
         $dbPlanningCourse = App_Model_DbTable_Factory::get('FPPlanningCourse');
         $row = $dbPlanningCourse->fetchRow(array('id_planning_course = ?' => $dataForm['fk_id_planning_course']));
         $row->fk_id_fefpstudentclass = $dataForm['fk_id_fefpstudentclass'];
         $row->save();
         // Save budget category
         $this->_saveBudgetCategory($dataForm);
         // Save the contract beneficiaries
         $this->_saveBeneficiaries($dataForm);
         if (empty($this->_data['id_fp_contract'])) {
             $history = 'REJISTU KONTRAKTU: %s BA ANNUAL PLANNING: %s';
         } else {
             $history = 'ATUALIZA KONTRAKTU: %s BA ANNUAL PLANNING: %s';
         }
         $history = sprintf($history, $dataForm['id_fp_contract'], $this->_data['fk_id_annual_planning']);
         $this->_sysAudit($history);
         $dbAdapter->commit();
         return $dataForm['id_fp_contract'];
     } catch (Exception $e) {
         $dbAdapter->rollBack();
         $this->_message->addMessage($this->_config->messages->error, App_Message::ERROR);
         return false;
     }
 }
 public function indexAction()
 {
     $raportsModel = new Raports();
     $request = $this->getRequest();
     $hash = $request->getParam('hash');
     if (empty($hash)) {
         return;
     }
     $raport = $raportsModel->getRaportByHash($hash);
     if ($raport === null) {
         return;
     }
     $start = $raport->date_for;
     $end = $raport->date_to;
     $date = new Zend_Date();
     if (empty($start) || empty($end) || (!$date->setDate($start, "YYYY-MM-dd")->isDate($start, "YYYY-MM-dd") || !$date->setDate($end, "YYYY-MM-dd")->isDate($end, "YYYY-MM-dd"))) {
         return;
     }
     $logic = new Logic_Raports_Render($start, $end, $this->_helper->currentip());
     $logic->render();
 }
Example #7
0
 public function isValid($data)
 {
     $isValid = parent::isValid($data);
     if (!empty($data['date_for']) && !empty($data['date_to'])) {
         $date = new Zend_Date();
         $date2 = clone $date;
         $date->setDate($data['date_for'], 'YYYY-MM-dd')->getTimestamp();
         $date2->setDate($data['date_to'], 'YYYY-MM-dd')->getTimestamp();
         if ($date->isLater($date2)) {
             $isValid = false;
             $this->getElement('date_to')->addError("Data do nie może być wcześniejsza niż data od");
         }
     }
     return $isValid;
 }
Example #8
0
 public function baseInit()
 {
     $this->datee(false, 'date_for', "Data od:", true);
     $this->date_for->addValidator('Callback', false, array('callback' => function ($value) {
         $date = new Zend_Date();
         $date->setDate($value, 'YYYY-MM-dd');
         return $date->isEarlier(new Zend_date()) || $date->isToday();
     }, 'messages' => array(Zend_Validate_Callback::INVALID_VALUE => "Data od nie może być datą przyszłą")));
     $this->datee(false, 'date_to', "Data do:", true);
     $this->date_to->addValidator('Callback', false, array('callback' => function ($value) {
         $date = new Zend_Date();
         $date->setDate($value, 'YYYY-MM-dd');
         return $date->isEarlier(new Zend_date()) || $date->isToday();
     }, 'messages' => array(Zend_Validate_Callback::INVALID_VALUE => "Data do nie może być datą przyszłą")));
     $this->submit(false, 'create_raport', 'Generuj raport');
 }
 public function getPredefinedStartDate()
 {
     $_editableOptions = $this->getProduct()->getPreconfiguredValues();
     if (isset($_editableOptions['aw_sarp_subscription_start'])) {
         $date = $_editableOptions['aw_sarp_subscription_start'];
         $zDate = new Zend_Date();
         $zDate->setDate($date);
         $today = new Zend_Date();
         $period = Mage::getModel('sarp/period')->load($_editableOptions['aw_sarp_subscription_type']);
         if ($zDate->compare($today, Zend_Date::DATE_SHORT) < 0 || !$period->isAllowedDate($zDate, $this->getProduct())) {
             $zDate = $period->getNearestAvailableDay();
         }
         $date = $zDate->toString(preg_replace(array('/M+/', '/d+/'), array('MM', 'dd'), Mage::app()->getLocale()->getDateFormat(Mage_Core_Model_Locale::FORMAT_TYPE_SHORT)));
         return $date;
     }
     return null;
 }
Example #10
0
 protected function _afterSave(Mage_Core_Model_Abstract $object)
 {
     //insert field values
     if (count($object->getData('field')) > 0) {
         foreach ($object->getData('field') as $field_id => $value) {
             if (is_array($value)) {
                 $value = implode("\n", $value);
             }
             $field = Mage::getModel('webforms/fields')->load($field_id);
             if (strstr($field->getType(), 'date') && strlen($value) > 0) {
                 $date = new Zend_Date();
                 $date->setDate($value, $field->getDateFormat(), Mage::app()->getLocale()->getLocaleCode());
                 if ($field->getType() == 'datetime') {
                     $date->setTime($value, $field->getDateFormat(), Mage::app()->getLocale()->getLocaleCode());
                 }
                 $value = date($field->getDbDateFormat(), $date->getTimestamp());
             }
             if ($field->getType() == 'select/contact' && is_numeric($value)) {
                 $value = $field->getContactValueById($value);
             }
             if ($value == $field->getHint()) {
                 $value = '';
             }
             // create key
             $key = "";
             if ($field->getType() == 'file' || $field->getType() == 'image') {
                 $key = Mage::helper('webforms')->randomAlphaNum(6);
                 if ($object->getData('key_' . $field_id)) {
                     $key = $object->getData('key_' . $field_id);
                 }
             }
             $object->setData('key_' . $field_id, $key);
             $select = $this->_getReadAdapter()->select()->from($this->getTable('webforms/results_values'))->where('result_id = ?', $object->getId())->where('field_id = ?', $field_id);
             $result_value = $this->_getReadAdapter()->fetchAll($select);
             if (!empty($result_value[0])) {
                 $this->_getWriteAdapter()->update($this->getTable('webforms/results_values'), array("value" => $value, "key" => $key), "id = " . $result_value[0]['id']);
             } else {
                 $this->_getWriteAdapter()->insert($this->getTable('webforms/results_values'), array("result_id" => $object->getId(), "field_id" => $field_id, "value" => $value, "key" => $key));
             }
         }
     }
     Mage::dispatchEvent('webforms_result_save', array('result' => $object));
     return parent::_afterSave($object);
 }
Example #11
0
 /**
  * Sets the internal value to ISO date format, based on either a database value in ISO date format,
  * or a form submssion in the user date format. Uses the individual date and time fields
  * to take care of the actual formatting and value conversion.
  * 
  * Value setting happens *before* validation, so we have to set the value even if its not valid.
  * 
  * Caution: Only converts user timezones when value is passed as array data (= form submission).
  * Weak indication, but unfortunately the framework doesn't support a distinction between
  * setting a value from the database, application logic, and user input.
  * 
  * @param string|array $val String expects an ISO date format. Array notation with 'date' and 'time'
  *  keys can contain localized strings. If the 'dmyfields' option is used for {@link DateField},
  *  the 'date' value may contain array notation was well (see {@link DateField->setValue()}).
  */
 function setValue($val)
 {
     // If timezones are enabled, assume user data needs to be reverted to server timezone
     if ($this->getConfig('usertimezone')) {
         // Accept user input on timezone, but only when timezone support is enabled
         $userTz = is_array($val) && array_key_exists('timezone', $val) ? $val['timezone'] : null;
         if (!$userTz) {
             $userTz = $this->getConfig('usertimezone');
         }
         // fall back to defined timezone
     } else {
         $userTz = null;
     }
     if (empty($val)) {
         $this->value = null;
         $this->dateField->setValue(null);
         $this->timeField->setValue(null);
     } else {
         // Case 1: String setting from database, in ISO date format
         if (is_string($val) && Zend_Date::isDate($val, $this->getConfig('datavalueformat'), $this->locale)) {
             $this->value = $val;
         } elseif (is_array($val) && array_key_exists('date', $val) && array_key_exists('time', $val)) {
             $dataTz = date_default_timezone_get();
             // If timezones are enabled, assume user data needs to be converted to server timezone
             if ($userTz) {
                 date_default_timezone_set($userTz);
             }
             // Uses sub-fields to temporarily write values and delegate dealing with their normalization,
             // actual sub-field value setting happens later
             $this->dateField->setValue($val['date']);
             $this->timeField->setValue($val['time']);
             if ($this->dateField->dataValue() && $this->timeField->dataValue()) {
                 $userValueObj = new Zend_Date(null, null, $this->locale);
                 $userValueObj->setDate($this->dateField->dataValue(), $this->dateField->getConfig('datavalueformat'));
                 $userValueObj->setTime($this->timeField->dataValue(), $this->timeField->getConfig('datavalueformat'));
                 if ($userTz) {
                     $userValueObj->setTimezone($dataTz);
                 }
                 $this->value = $userValueObj->get($this->getConfig('datavalueformat'), $this->locale);
                 unset($userValueObj);
             } else {
                 // Validation happens later, so set the raw string in case Zend_Date doesn't accept it
                 $this->value = sprintf($this->getConfig('datetimeorder'), $val['date'], $val['time']);
             }
             if ($userTz) {
                 date_default_timezone_set($dataTz);
             }
         } else {
             $this->dateField->setValue($val);
             if (is_string($val)) {
                 $this->timeField->setValue($val);
             }
             $this->value = $val;
         }
         // view settings (dates might differ from $this->value based on user timezone settings)
         if (Zend_Date::isDate($this->value, $this->getConfig('datavalueformat'), $this->locale)) {
             $valueObj = new Zend_Date($this->value, $this->getConfig('datavalueformat'), $this->locale);
             if ($userTz) {
                 $valueObj->setTimezone($userTz);
             }
             // Set view values in sub-fields
             if ($this->dateField->getConfig('dmyfields')) {
                 $this->dateField->setValue($valueObj->toArray());
             } else {
                 $this->dateField->setValue($valueObj->get($this->dateField->getConfig('dateformat'), $this->locale));
             }
             $this->timeField->setValue($valueObj->get($this->timeField->getConfig('timeformat'), $this->locale));
         }
     }
 }
Example #12
0
 /**
  * @ZF-7589
  */
 public function testSetDateWithArray()
 {
     $date = new Zend_Date(1234567890);
     $result = $date->setDate(array('year' => 2009, 'month' => 8, 'day' => 14));
     $this->assertSame('2009-08-14T04:31:30+05:00', $result->get(Zend_Date::W3C));
 }
 protected function _afterSave()
 {
     if (!Mage::helper('customoptions')->isEnabled() || Mage::app()->getRequest()->getControllerName() != 'catalog_product' && Mage::app()->getRequest()->getControllerName() != 'adminhtml_catalog_product') {
         return parent::_afterSave();
     }
     $optionId = $this->getData('option_id');
     $defaultArray = $this->getData('default') ? $this->getData('default') : array();
     $tablePrefix = (string) Mage::getConfig()->getTablePrefix();
     $connection = Mage::getSingleton('core/resource')->getConnection('core_write');
     $helper = Mage::helper('customoptions');
     $storeId = $this->getProduct()->getStoreId();
     if (is_array($this->getData('values'))) {
         $values = array();
         foreach ($this->getData('values') as $key => $value) {
             if (isset($value['option_type_id'])) {
                 if (isset($value['dependent_ids']) && $value['dependent_ids'] != '') {
                     $dependentIds = array();
                     $dependentIdsTmp = explode(',', $value['dependent_ids']);
                     foreach ($dependentIdsTmp as $d_id) {
                         if ($this->decodeViewIGI($d_id) > 0) {
                             $dependentIds[] = $this->decodeViewIGI($d_id);
                         }
                     }
                     $value['dependent_ids'] = implode(',', $dependentIds);
                 }
                 $value['sku'] = trim($value['sku']);
                 // prepare customoptions_qty
                 $customoptionsQty = '';
                 if (isset($value['customoptions_qty']) && (!$helper->isSkuQtyLinkingEnabled() || $helper->getProductIdBySku($value['sku']) == 0)) {
                     $customoptionsQty = strtolower(trim($value['customoptions_qty']));
                     if (substr($customoptionsQty, 0, 1) != 'x' && substr($customoptionsQty, 0, 1) != 'i' && substr($customoptionsQty, 0, 1) != 'l' && !is_numeric($customoptionsQty)) {
                         $customoptionsQty = '';
                     }
                     if (is_numeric($customoptionsQty)) {
                         $customoptionsQty = intval($customoptionsQty);
                     }
                     if (substr($customoptionsQty, 0, 1) == 'i') {
                         $customoptionsQty = $this->decodeViewIGI($customoptionsQty);
                     }
                 }
                 $optionValue = array('option_id' => $optionId, 'sku' => $value['sku'], 'sort_order' => $value['sort_order'], 'customoptions_qty' => $customoptionsQty, 'default' => array_search($key, $defaultArray) !== false ? 1 : 0, 'in_group_id' => $value['in_group_id']);
                 if (isset($value['dependent_ids'])) {
                     $optionValue['dependent_ids'] = $value['dependent_ids'];
                 }
                 if (isset($value['weight'])) {
                     $optionValue['weight'] = $value['weight'];
                 }
                 if (isset($value['cost'])) {
                     $optionValue['cost'] = $value['cost'];
                 }
                 $optionTypePriceId = 0;
                 if ($helper->isSkuNameLinkingEnabled() && (!isset($value['scope']['title']) || $value['scope']['title'] != 1) && (!isset($value['title']) || $value['title'] == '') && $value['sku']) {
                     $value['title'] = $helper->getProductNameBySku($value['sku'], $storeId);
                 }
                 if (isset($value['option_type_id']) && $value['option_type_id'] > 0) {
                     $optionTypeId = $value['option_type_id'];
                     if ($value['is_delete'] == '1') {
                         $connection->delete($tablePrefix . 'catalog_product_option_type_value', 'option_type_id = ' . $optionTypeId);
                         $helper->deleteOptionFile(null, $optionId, $optionTypeId);
                     } else {
                         $connection->update($tablePrefix . 'catalog_product_option_type_value', $optionValue, 'option_type_id = ' . $optionTypeId);
                         // update or insert price
                         $select = $connection->select()->from($tablePrefix . 'catalog_product_option_type_price', array('option_type_price_id'))->where('option_type_id = ' . $optionTypeId . ' AND `store_id` = ' . $storeId);
                         $optionTypePriceId = $isUpdate = $connection->fetchOne($select);
                         if (isset($value['price']) && isset($value['price_type'])) {
                             $priceValue = array('price' => $value['price'], 'price_type' => $value['price_type']);
                             if ($isUpdate) {
                                 $connection->update($tablePrefix . 'catalog_product_option_type_price', $priceValue, 'option_type_id = ' . $optionTypeId . ' AND `store_id` = ' . $storeId);
                             } else {
                                 $priceValue['option_type_id'] = $optionTypeId;
                                 $priceValue['store_id'] = $storeId;
                                 $connection->insert($tablePrefix . 'catalog_product_option_type_price', $priceValue);
                                 $optionTypePriceId = $connection->lastInsertId($tablePrefix . 'catalog_product_option_type_price');
                             }
                         } elseif (isset($value['scope']['price']) && $value['scope']['price'] == 1 && $isUpdate && $storeId > 0) {
                             $connection->delete($tablePrefix . 'catalog_product_option_type_price', 'option_type_id = ' . $optionTypeId . ' AND `store_id` = ' . $storeId);
                             $optionTypePriceId = -1;
                         }
                         // update or insert title
                         if ($storeId > 0) {
                             $select = $connection->select()->from($tablePrefix . 'catalog_product_option_type_title', array('COUNT(*)'))->where('option_type_id = ' . $optionTypeId . ' AND `store_id` = ' . $storeId);
                             $isUpdate = $connection->fetchOne($select);
                         } else {
                             $isUpdate = 1;
                         }
                         if (isset($value['title'])) {
                             if ($isUpdate) {
                                 $connection->update($tablePrefix . 'catalog_product_option_type_title', array('title' => $value['title']), 'option_type_id = ' . $optionTypeId . ' AND `store_id` = ' . $storeId);
                             } else {
                                 $connection->insert($tablePrefix . 'catalog_product_option_type_title', array('option_type_id' => $optionTypeId, 'store_id' => $storeId, 'title' => $value['title']));
                             }
                         } elseif (isset($value['scope']['title']) && $value['scope']['title'] == 1 && $isUpdate && $storeId > 0) {
                             $connection->delete($tablePrefix . 'catalog_product_option_type_title', 'option_type_id = ' . $optionTypeId . ' AND `store_id` = ' . $storeId);
                         }
                         // update or insert description
                         if (isset($value['description']) || isset($value['scope']['description'])) {
                             $select = $connection->select()->from($tablePrefix . 'custom_options_option_type_description', array('COUNT(*)'))->where('option_type_id = ' . $optionTypeId . ' AND `store_id` = ' . $storeId);
                             $isUpdate = $connection->fetchOne($select);
                         }
                         if (isset($value['description']) && $value['description'] != '') {
                             if ($isUpdate) {
                                 $connection->update($tablePrefix . 'custom_options_option_type_description', array('description' => $value['description']), 'option_type_id = ' . $optionTypeId . ' AND `store_id` = ' . $storeId);
                             } else {
                                 $connection->insert($tablePrefix . 'custom_options_option_type_description', array('option_type_id' => $optionTypeId, 'store_id' => $storeId, 'description' => $value['description']));
                             }
                         } elseif (isset($value['scope']['description']) && $value['scope']['description'] == 1 && $isUpdate && $storeId > 0 || isset($value['description']) && $value['description'] == '') {
                             $connection->delete($tablePrefix . 'custom_options_option_type_description', 'option_type_id = ' . $optionTypeId . ' AND `store_id` = ' . $storeId);
                         }
                     }
                 } else {
                     if ($value['is_delete'] == '1') {
                         continue;
                     }
                     $connection->insert($tablePrefix . 'catalog_product_option_type_value', $optionValue);
                     $optionTypeId = $connection->lastInsertId($tablePrefix . 'catalog_product_option_type_value');
                     if (isset($value['price']) && isset($value['price_type'])) {
                         // save not default
                         //if ($storeId>0) $connection->insert($tablePrefix . 'catalog_product_option_type_price', array('option_type_id' =>$optionTypeId, 'store_id'=>$storeId, 'price' => $value['price'], 'price_type' => $value['price_type']));
                         // save default
                         $connection->insert($tablePrefix . 'catalog_product_option_type_price', array('option_type_id' => $optionTypeId, 'store_id' => 0, 'price' => $value['price'], 'price_type' => $value['price_type']));
                         $optionTypePriceId = $connection->lastInsertId($tablePrefix . 'catalog_product_option_type_price');
                     }
                     if (isset($value['title'])) {
                         // save default
                         $connection->insert($tablePrefix . 'catalog_product_option_type_title', array('option_type_id' => $optionTypeId, 'store_id' => 0, 'title' => $value['title']));
                     }
                     if (isset($value['description']) && $value['description'] != '') {
                         // save default
                         $connection->insert($tablePrefix . 'custom_options_option_type_description', array('option_type_id' => $optionTypeId, 'store_id' => 0, 'description' => $value['description']));
                     }
                 }
                 if ($optionTypeId > 0 && $optionTypePriceId >= 0) {
                     $id = $this->getData('id');
                     $this->_uploadImage('file_' . $id . '_' . $key, $optionId, $optionTypeId, $value);
                     // check $optionTypePriceId
                     if ($optionTypePriceId == 0) {
                         $select = $connection->select()->from($tablePrefix . 'catalog_product_option_type_price', array('option_type_price_id'))->where('option_type_id = ' . $optionTypeId . ' AND `store_id` = ' . $storeId);
                         $optionTypePriceId = $isUpdate = $connection->fetchOne($select);
                     }
                     if ($optionTypePriceId) {
                         // save special prices
                         if (isset($value['specials']) && is_array($value['specials'])) {
                             $specials = array();
                             foreach ($value['specials'] as $special) {
                                 if ($special['is_delete'] == '1' || isset($specials[$special['customer_group_id']])) {
                                     if ($special['special_price_id'] > 0) {
                                         $connection->delete($tablePrefix . 'custom_options_option_type_special_price', 'option_type_special_price_id = ' . intval($special['special_price_id']));
                                     }
                                     continue;
                                 }
                                 $specials[$special['customer_group_id']] = $special;
                             }
                             if (count($specials) > 0) {
                                 foreach ($specials as $special) {
                                     $zendDate = new Zend_Date();
                                     $dateFormat = Mage::app()->getLocale()->getDateFormat(Mage_Core_Model_Locale::FORMAT_TYPE_SHORT);
                                     if ($special['date_from']) {
                                         $special['date_from'] = $zendDate->setDate($special['date_from'], $dateFormat)->toString(Varien_Date::DATE_INTERNAL_FORMAT);
                                     } else {
                                         $special['date_from'] = null;
                                     }
                                     if ($special['date_to']) {
                                         $special['date_to'] = $zendDate->setDate($special['date_to'], $dateFormat)->toString(Varien_Date::DATE_INTERNAL_FORMAT);
                                     } else {
                                         $special['date_to'] = null;
                                     }
                                     $specialData = array('option_type_price_id' => $optionTypePriceId, 'customer_group_id' => $special['customer_group_id'], 'price' => floatval($special['price']), 'price_type' => $special['price_type'], 'comment' => trim($special['comment']), 'date_from' => $special['date_from'], 'date_to' => $special['date_to']);
                                     if ($special['special_price_id'] > 0) {
                                         $connection->update($tablePrefix . 'custom_options_option_type_special_price', $specialData, 'option_type_special_price_id = ' . intval($special['special_price_id']));
                                     } else {
                                         $connection->insert($tablePrefix . 'custom_options_option_type_special_price', $specialData);
                                     }
                                 }
                             }
                         }
                         // save tier prices
                         if (isset($value['tiers']) && is_array($value['tiers'])) {
                             $tiers = array();
                             foreach ($value['tiers'] as $tier) {
                                 $uniqKey = $tier['qty'] . '+' . $tier['customer_group_id'];
                                 if ($tier['is_delete'] == '1' || isset($tiers[$uniqKey])) {
                                     if ($tier['tier_price_id'] > 0) {
                                         $connection->delete($tablePrefix . 'custom_options_option_type_tier_price', 'option_type_tier_price_id = ' . intval($tier['tier_price_id']));
                                     }
                                     continue;
                                 }
                                 $tiers[$uniqKey] = $tier;
                             }
                             if (count($tiers) > 0) {
                                 foreach ($tiers as $tier) {
                                     $tierData = array('option_type_price_id' => $optionTypePriceId, 'customer_group_id' => $tier['customer_group_id'], 'qty' => intval($tier['qty']), 'price' => floatval($tier['price']), 'price_type' => $tier['price_type']);
                                     if ($tier['tier_price_id'] > 0) {
                                         $connection->update($tablePrefix . 'custom_options_option_type_tier_price', $tierData, 'option_type_tier_price_id = ' . intval($tier['tier_price_id']));
                                     } else {
                                         $connection->insert($tablePrefix . 'custom_options_option_type_tier_price', $tierData);
                                     }
                                 }
                             }
                         }
                     }
                 }
                 unset($value['option_type_id']);
             }
             $values[$key] = $value;
         }
         $this->setData('values', $values);
     } elseif ($this->getGroupByType($this->getType()) == self::OPTION_GROUP_SELECT) {
         Mage::throwException(Mage::helper('catalog')->__('Select type options required values rows.'));
     }
     if (version_compare($helper->getMagetoVersion(), '1.4.0', '>=')) {
         $this->cleanModelCache();
     }
     Mage::dispatchEvent('model_save_after', array('object' => $this));
     if (version_compare($helper->getMagetoVersion(), '1.4.0', '>=')) {
         Mage::dispatchEvent($this->_eventPrefix . '_save_after', $this->_getEventData());
     }
     return $this;
 }
Example #14
0
 /**
  * Test for setDate
  */
 public function testSetDate()
 {
     $locale = new Zend_Locale('de_AT');
     $date = new Zend_Date(1234567890, null, $locale);
     $d2 = new Zend_Date(1234567899, null, $locale);
     $result = $date->setDate(Zend_Date::now());
     $this->assertTrue($result instanceof Zend_Date);
     $result = $date->setDate('11.05.2008');
     $this->assertSame($result->get(Zend_Date::W3C), '2008-04-11T00:31:30+02:00');
     $this->assertSame($date->get(Zend_Date::W3C), '2008-04-11T00:31:30+02:00');
     $date->setDate('2008-05-11', 'YYYY-MM-dd');
     $this->assertSame($date->get(Zend_Date::W3C), '2008-04-11T00:31:30+02:00');
     $date->setDate($d2);
     $this->assertSame($date->get(Zend_Date::W3C), '2009-02-14T00:31:30+01:00');
 }
Example #15
0
 /**
  * test looseBehaviour
  */
 public function testLoose()
 {
     $date = new Zend_Date(0, 'de');
     try {
         $date->set(null, Zend_Date::YEAR);
         $this->fail();
     } catch (Zend_Date_Exception $e) {
         // success
     }
     $date->set(10, 'de');
     $this->assertEquals($date->getTimestamp(), 10);
     try {
         $date->add(null, Zend_Date::YEAR);
         $this->fail();
     } catch (Zend_Date_Exception $e) {
         // success
     }
     $date->add(10, 'de');
     $this->assertEquals($date->getTimestamp(), 20);
     try {
         $date->sub(null, Zend_Date::YEAR);
         $this->fail();
     } catch (Zend_Date_Exception $e) {
         // success
     }
     $date->sub(10, 'de');
     $this->assertEquals($date->getTimestamp(), 10);
     try {
         $date->compare(null, Zend_Date::YEAR);
         $this->fail();
     } catch (Zend_Date_Exception $e) {
         // success
     }
     try {
         $date->equals(null, Zend_Date::YEAR);
         $this->fail();
     } catch (Zend_Date_Exception $e) {
         // success
     }
     try {
         $date->isEarlier(null, Zend_Date::YEAR);
         $this->fail();
     } catch (Zend_Date_Exception $e) {
         // success
     }
     try {
         $date->isLater(null, Zend_Date::YEAR);
         $this->fail();
     } catch (Zend_Date_Exception $e) {
         // success
     }
     try {
         $date->setTime(null);
         $this->fail();
     } catch (Zend_Date_Exception $e) {
         // success
     }
     try {
         $date->addTime(null);
         $this->fail();
     } catch (Zend_Date_Exception $e) {
         // success
     }
     try {
         $date->subTime(null);
         $this->fail();
     } catch (Zend_Date_Exception $e) {
         // success
     }
     try {
         $date->compareTime(null);
         $this->fail();
     } catch (Zend_Date_Exception $e) {
         // success
     }
     try {
         $date->setDate(null);
         $this->fail();
     } catch (Zend_Date_Exception $e) {
         // success
     }
     try {
         $date->addDate(null);
         $this->fail();
     } catch (Zend_Date_Exception $e) {
         // success
     }
     try {
         $date->subDate(null);
         $this->fail();
     } catch (Zend_Date_Exception $e) {
         // success
     }
     try {
         $date->compareDate(null);
         $this->fail();
     } catch (Zend_Date_Exception $e) {
         // success
     }
     try {
         $date->setIso(null);
         $this->fail();
     } catch (Zend_Date_Exception $e) {
         // success
     }
     try {
         $date->addIso(null);
         $this->fail();
     } catch (Zend_Date_Exception $e) {
         // success
     }
     try {
         $date->subIso(null);
         $this->fail();
     } catch (Zend_Date_Exception $e) {
         // success
     }
     try {
         $date->compareIso(null);
         $this->fail();
     } catch (Zend_Date_Exception $e) {
         // success
     }
     try {
         $date->setArpa(null);
         $this->fail();
     } catch (Zend_Date_Exception $e) {
         // success
     }
     try {
         $date->addArpa(null);
         $this->fail();
     } catch (Zend_Date_Exception $e) {
         // success
     }
     try {
         $date->subArpa(null);
         $this->fail();
     } catch (Zend_Date_Exception $e) {
         // success
     }
     try {
         $date->compareArpa(null);
         $this->fail();
     } catch (Zend_Date_Exception $e) {
         // success
     }
     try {
         $date->setYear(null);
         $this->fail();
     } catch (Zend_Date_Exception $e) {
         // success
     }
     try {
         $date->addYear(null);
         $this->fail();
     } catch (Zend_Date_Exception $e) {
         // success
     }
     try {
         $date->subYear(null);
         $this->fail();
     } catch (Zend_Date_Exception $e) {
         // success
     }
     try {
         $date->compareYear(null);
         $this->fail();
     } catch (Zend_Date_Exception $e) {
         // success
     }
     try {
         $date->setMonth(null);
         $this->fail();
     } catch (Zend_Date_Exception $e) {
         // success
     }
     try {
         $date->addMonth(null);
         $this->fail();
     } catch (Zend_Date_Exception $e) {
         // success
     }
     try {
         $date->subMonth(null);
         $this->fail();
     } catch (Zend_Date_Exception $e) {
         // success
     }
     try {
         $date->compareMonth(null);
         $this->fail();
     } catch (Zend_Date_Exception $e) {
         // success
     }
     try {
         $date->setDay(null);
         $this->fail();
     } catch (Zend_Date_Exception $e) {
         // success
     }
     try {
         $date->addDay(null);
         $this->fail();
     } catch (Zend_Date_Exception $e) {
         // success
     }
     try {
         $date->subDay(null);
         $this->fail();
     } catch (Zend_Date_Exception $e) {
         // success
     }
     try {
         $date->compareDay(null);
         $this->fail();
     } catch (Zend_Date_Exception $e) {
         // success
     }
     try {
         $date->setWeekday(null);
         $this->fail();
     } catch (Zend_Date_Exception $e) {
         // success
     }
     try {
         $date->addWeekday(null);
         $this->fail();
     } catch (Zend_Date_Exception $e) {
         // success
     }
     try {
         $date->subWeekday(null);
         $this->fail();
     } catch (Zend_Date_Exception $e) {
         // success
     }
     try {
         $date->compareWeekday(null);
         $this->fail();
     } catch (Zend_Date_Exception $e) {
         // success
     }
     try {
         $date->setDayOfYear(null);
         $this->fail();
     } catch (Zend_Date_Exception $e) {
         // success
     }
     try {
         $date->addDayOfYear(null);
         $this->fail();
     } catch (Zend_Date_Exception $e) {
         // success
     }
     try {
         $date->subDayOfYear(null);
         $this->fail();
     } catch (Zend_Date_Exception $e) {
         // success
     }
     try {
         $date->compareDayOfYear(null);
         $this->fail();
     } catch (Zend_Date_Exception $e) {
         // success
     }
     try {
         $date->setHour(null);
         $this->fail();
     } catch (Zend_Date_Exception $e) {
         // success
     }
     try {
         $date->addHour(null);
         $this->fail();
     } catch (Zend_Date_Exception $e) {
         // success
     }
     try {
         $date->subHour(null);
         $this->fail();
     } catch (Zend_Date_Exception $e) {
         // success
     }
     try {
         $date->compareHour(null);
         $this->fail();
     } catch (Zend_Date_Exception $e) {
         // success
     }
     try {
         $date->setMinute(null);
         $this->fail();
     } catch (Zend_Date_Exception $e) {
         // success
     }
     try {
         $date->addMinute(null);
         $this->fail();
     } catch (Zend_Date_Exception $e) {
         // success
     }
     try {
         $date->subMinute(null);
         $this->fail();
     } catch (Zend_Date_Exception $e) {
         // success
     }
     try {
         $date->compareMinute(null);
         $this->fail();
     } catch (Zend_Date_Exception $e) {
         // success
     }
     try {
         $date->setSecond(null);
         $this->fail();
     } catch (Zend_Date_Exception $e) {
         // success
     }
     try {
         $date->addSecond(null);
         $this->fail();
     } catch (Zend_Date_Exception $e) {
         // success
     }
     try {
         $date->subSecond(null);
         $this->fail();
     } catch (Zend_Date_Exception $e) {
         // success
     }
     try {
         $date->compareSecond(null);
         $this->fail();
     } catch (Zend_Date_Exception $e) {
         // success
     }
     try {
         $date->setWeek(null);
         $this->fail();
     } catch (Zend_Date_Exception $e) {
         // success
     }
     try {
         $date->addWeek(null);
         $this->fail();
     } catch (Zend_Date_Exception $e) {
         // success
     }
     try {
         $date->subWeek(null);
         $this->fail();
     } catch (Zend_Date_Exception $e) {
         // success
     }
     try {
         $date->compareWeek(null);
         $this->fail();
     } catch (Zend_Date_Exception $e) {
         // success
     }
 }
 /**
  * 取得某个预定义时间段
  * 
  * @static
  * @param integer $interval
  * @param string $forceUnit
  * @param integer $timestamp
  * @return array
  */
 public static function getPredefinedRange($interval, $forceUnit = null, $timestamp = null)
 {
     if (empty($timestamp)) {
         $timestamp = time();
     }
     $start = new Zend_Date($timestamp);
     $end = new Zend_Date($timestamp);
     switch ($interval) {
         case self::TODAY:
             $start->setHour(0)->setMinute(0)->setSecond(0);
             $unit = Zend_Date::HOUR;
             break;
         case self::YESTODAY:
             $start->subDay(1)->setHour(0)->setMinute(0)->setSecond(0);
             $end = clone $start;
             $end->addDay(1);
             $unit = Zend_Date::HOUR;
             break;
         case self::TOMORROW:
             $start->addDay(1)->setHour(0)->setMinute(0)->setSecond(0);
             $end = clone $start;
             $end->addDay(1);
             $unit = Zend_Date::HOUR;
             break;
         case self::THIS_MONTH:
             $start->setDay(1)->setHour(0)->setMinute(0)->setSecond(0);
             $unit = Zend_Date::DAY;
             break;
         case self::THIS_YEAR:
             $start->setMonth(1)->setDay(1)->setHour(0)->setMinute(0)->setSecond(0);
             $end->addMonth(1)->setDay(1)->setHour(0)->setMinute(0)->setSecond(0);
             $unit = Zend_Date::DAY;
             break;
         case self::THIS_SEASON:
             $start->setMonth(3 * floor(($start->toValue('M') - 1) / 3) + 1)->setDay(1)->setHour(0)->setMinute(0)->setSecond(0);
             $unit = Zend_Date::DAY;
         case self::RECENT_24HOUR:
             $start->subHour(24);
             $unit = Zend_Date::HOUR;
             break;
         case self::RECENT_48HOUR:
             $start->subHour(48);
             $unit = Zend_Date::HOUR;
             break;
         case self::RECENT_1WEEK:
             $start->subWeek(1);
             $unit = Zend_Date::DAY;
             break;
         case self::RECENT_1MONTH:
             $start->subMonth(1);
             $unit = Zend_Date::DAY;
             break;
         case self::RECENT_24MONTH:
             $start->subMonth(24);
             $unit = Zend_Date::DAY;
             break;
         case self::LAST_1MONTH:
             $start->subMonth(1)->setDay(1)->setHour(0)->setMinute(0)->setSecond(0);
             $end = clone $start;
             $end->addMonth(1);
             $unit = Zend_Date::DAY;
             break;
         case self::LAST_1YEAR:
             $start->subYear(1)->setMonth(1)->setDay(1)->setHour(0)->setMinute(0)->setSecond(0);
             $end = clone $start;
             $end->addYear(1);
             $unit = Zend_Date::DAY;
             break;
         case self::ENTIRE_DAY:
             $start->setDate(self::ERA_DATE, self::ZF_DATE_FORMAT)->setTime(self::ERA_TIME, self::ZF_TIME_FORMAT);
             $end->addDay(1);
             $unit = Zend_Date::DAY;
             break;
         default:
             $unit = Zend_Date::SECOND;
     }
     if (!empty($forceUnit)) {
         $unit = $forceUnit;
     }
     $start = max(self::truncateDatetime($start, $unit), self::truncateDatetime(self::ERA_DATETIME, $unit));
     $end = max(self::truncateDatetime($end, $unit), self::truncateDatetime(self::ERA_DATETIME, $unit));
     return compact('start', 'end', 'unit');
 }
Example #17
0
 protected function mapDirectiveSalePriceEffectiveDate($params = array())
 {
     $map = $params['map'];
     $product = $this->getProduct();
     /* @var $product Mage_Catalog_Model_Product */
     $cell = "";
     if (!$this->hasSpecialPrice()) {
         return $cell;
     }
     $cDate = Mage::app()->getLocale()->date(null, null, Mage::app()->getLocale()->getDefaultLocale());
     $timezone = Mage::app()->getStore($this->getStoreId())->getConfig(Mage_Core_Model_Locale::XML_PATH_DEFAULT_TIMEZONE);
     $fromDate = new Zend_Date(null, null, Mage::app()->getLocale()->getDefaultLocale());
     if ($timezone) {
         $fromDate->setTimezone($timezone);
     }
     $fromDate->setDate(substr($product->getSpecialFromDate(), 0, 10), 'yyyy-MM-dd');
     $fromDate->setTime(substr($product->getSpecialFromDate(), 11, 8), 'HH:mm:ss');
     $toDate = new Zend_Date(null, null, Mage::app()->getLocale()->getDefaultLocale());
     if (!is_empty_date($product->getSpecialToDate())) {
         if ($timezone) {
             $toDate->setTimezone($timezone);
         }
         $toDate->setDate(substr($product->getSpecialToDate(), 0, 10), 'yyyy-MM-dd');
         $toDate->setTime('23:59:59', 'HH:mm:ss');
     } else {
         if ($timezone) {
             $toDate->setTimezone($timezone);
         }
         $toDate->setDate($cDate->toString('yyyy-MM-dd'), 'yyyy-MM-dd');
         $toDate->setTime('23:59:59', 'HH:mm:ss');
         $toDate->add(7, Zend_Date::DAY);
     }
     $cell = $fromDate->toString(Zend_Date::ISO_8601) . "/" . $toDate->toString(Zend_Date::ISO_8601);
     return $cell;
 }
 public function getOptionValues()
 {
     $optionsCollection = $this->getProduct()->getOptions();
     // if option enabled = no && hasOptions = 0
     if (!$optionsCollection) {
         $optionsCollection = $this->getProduct()->getProductOptionsCollection();
     }
     $zendDate = new Zend_Date();
     $dateFormat = Mage::app()->getLocale()->getDateFormat(Mage_Core_Model_Locale::FORMAT_TYPE_SHORT);
     if (!$this->_values) {
         $values = array();
         $scope = (int) Mage::app()->getStore()->getConfig(Mage_Core_Model_Store::XML_PATH_PRICE_SCOPE);
         $helper = Mage::helper('customoptions');
         foreach ($optionsCollection as $option) {
             /* @var $option Mage_Catalog_Model_Product_Option */
             $this->setItemCount($option->getOptionId());
             $value = array();
             $value['id'] = $option->getOptionId();
             $value['template_title'] = $option->getGroupTitle() ? $helper->__('Options Template:') . ' ' . $option->getGroupTitle() : '';
             $value['item_count'] = $this->getItemCount();
             $value['option_id'] = $option->getOptionId();
             $value['title'] = $this->htmlEscape($option->getTitle());
             $value['type'] = $option->getType();
             $value['is_require'] = $option->getIsRequire(true);
             $value['view_mode'] = $option->getViewMode();
             $value['is_dependent'] = $option->getIsDependent();
             $value['div_class'] = $option->getDivClass();
             $value['sku_policy'] = $option->getSkuPolicy();
             $value['customoptions_is_onetime'] = $option->getCustomoptionsIsOnetime();
             $value['qnty_input'] = $option->getQntyInput() ? 'checked' : '';
             $value['qnty_input_disabled'] = $option->getType() == 'multiple' || $option->getType() == 'hidden' ? 'disabled' : '';
             $value['image_mode'] = $option->getImageMode();
             $value['image_mode_disabled'] = $option->getGroupByType() != Mage_Catalog_Model_Product_Option::OPTION_GROUP_SELECT ? 'disabled' : '';
             $value['exclude_first_image'] = $option->getExcludeFirstImage() ? 'checked' : '';
             $value['sort_order'] = $option->getSortOrder();
             $value['image_button_label'] = $option->getImagePath() ? $helper->__('Change Image') : $helper->__('Add Image');
             $value['description'] = $this->htmlEscape($option->getDescription());
             if ($helper->isCustomerGroupsEnabled() && $option->getCustomerGroups() != null) {
                 $value['customer_groups'] = $option->getCustomerGroups();
             }
             if ($helper->isStoreViewsEnabled() && $option->getStoreViews() != null) {
                 $value['store_views'] = $option->getStoreViews();
             }
             $value['in_group_id'] = $option->getInGroupId();
             $value['in_group_id_view'] = $this->getViewIGI($option->getInGroupId());
             if ($this->getProduct()->getStoreId() != '0') {
                 $value['checkboxScopeTitle'] = $this->getCheckboxScopeHtml($option->getOptionId(), 'title', is_null($option->getStoreTitle()));
                 $value['scopeTitleDisabled'] = is_null($option->getStoreTitle()) ? 'disabled' : null;
                 $value['checkboxScopeViewMode'] = $this->getCheckboxScopeHtml($option->getOptionId(), 'view_mode', is_null($option->getStoreViewMode()));
                 $value['scopeViewModeDisabled'] = is_null($option->getStoreViewMode()) ? 'disabled' : null;
                 $value['checkboxScopeDescription'] = $this->getCheckboxScopeHtml($option->getOptionId(), 'description', is_null($option->getStoreDescription()));
                 $value['scopeDescriptionDisabled'] = is_null($option->getStoreDescription()) ? 'disabled' : null;
             }
             $connection = Mage::getSingleton('core/resource')->getConnection('core_write');
             $tablePrefix = (string) Mage::getConfig()->getTablePrefix();
             $select = $connection->select()->from($tablePrefix . 'custom_options_relation')->where('option_id = ' . $option->getOptionId());
             $relation = $connection->fetchRow($select);
             if ($option->getGroupByType() == Mage_Catalog_Model_Product_Option::OPTION_GROUP_SELECT) {
                 $i = 0;
                 $itemCount = 0;
                 foreach ($option->getValues() as $_value) {
                     /* @var $_value Mage_Catalog_Model_Product_Option_Value */
                     $dependentIds = array();
                     $dependentIdsTmp = explode(',', $_value->getDependentIds());
                     foreach ($dependentIdsTmp as $d_id) {
                         $dependentIds[] = $this->getViewIGI($d_id);
                     }
                     $priceDisabled = $_value->getIsSkuPrice();
                     list($skuClass, $viewProductBySkuHtml) = $this->getViewSkuData($_value->getSku());
                     if (!$helper->isSkuQtyLinkingEnabled() || $helper->getProductIdBySku($_value->getSku()) == 0) {
                         $customoptionsQty = $_value->getCustomoptionsQty();
                     } else {
                         list($customoptionsQty, $backorders) = $helper->getCustomoptionsQty($_value->getCustomoptionsQty(), $_value->getSku(), 0, null, null, null, true);
                     }
                     $value['optionValues'][$i] = array('item_count' => max($itemCount, $_value->getOptionTypeId()), 'option_id' => $_value->getOptionId(), 'option_type_id' => $_value->getOptionTypeId(), 'title' => $this->htmlEscape($_value->getTitle()), 'price' => $this->getPriceValue($_value->getPrice(), $_value->getPriceType()), 'price_type' => $_value->getPriceType(), 'price_disabled' => $priceDisabled, 'description' => $this->htmlEscape($_value->getDescription()), 'cost' => $this->getPriceValue($_value->getCost(), 'fixed'), 'cost_disabled' => $_value->getIsSkuCost() ? 'disabled' : '', 'customoptions_qty' => $this->getViewQty($customoptionsQty), 'customoptions_qty_disabled' => $helper->isSkuQtyLinkingEnabled() && $helper->getProductIdBySku($_value->getSku()) ? 'disabled="disabled"' : '', 'sku' => $this->htmlEscape($_value->getSku()), 'sku_class' => $skuClass, 'view_product_by_sku_html' => $viewProductBySkuHtml, 'image_button_label' => $helper->__('Add Image'), 'sort_order' => $_value->getSortOrder(), 'checked' => $_value->getDefault() != 0 ? 'checked' : '', 'default_type' => $option->getType() == 'checkbox' || $option->getType() == 'multiple' || $option->getType() == 'multiswatch' || $option->getType() == 'hidden' ? 'checkbox' : 'radio', 'in_group_id' => $_value->getInGroupId(), 'in_group_id_view' => $this->getViewIGI($_value->getInGroupId()), 'dependent_ids' => implode(',', $dependentIds), 'weight' => $_value->getWeight(), 'weight_disabled' => $_value->getIsSkuWeight() ? 'disabled' : '');
                     // getImages
                     $images = $_value->getImages();
                     if ($images) {
                         foreach ($images as $image) {
                             if ($image['source'] == 1) {
                                 // file
                                 $imgArr = $helper->getImgData($image['image_file'], $option->getId(), $_value->getOptionTypeId());
                                 if ($imgArr) {
                                     $imgArr['option_type_image_id'] = $image['option_type_image_id'];
                                     $value['optionValues'][$i]['images'][] = $imgArr;
                                 }
                             } elseif ($image['source'] == 2) {
                                 // color
                                 $colorArr = $image;
                                 $colorArr['id'] = $option->getId();
                                 $colorArr['select_id'] = $_value->getOptionTypeId();
                                 $value['optionValues'][$i]['images'][] = $colorArr;
                             }
                         }
                     } else {
                         $value['optionValues'][$i]['image_tr_style'] = 'display:none';
                     }
                     //getOptionValueSpecialPrices
                     $specialPrices = $_value->getSpecials();
                     if ($specialPrices) {
                         foreach ($specialPrices as $specialKey => $specialPrice) {
                             $specialPrices[$specialKey]['price'] = $this->getPriceValue($specialPrice['price'], $specialPrice['price_type']);
                             if ($specialPrice['date_from']) {
                                 $specialPrices[$specialKey]['date_from'] = $zendDate->setDate($specialPrice['date_from'], Varien_Date::DATE_INTERNAL_FORMAT)->toString($dateFormat);
                             }
                             if ($specialPrice['date_to']) {
                                 $specialPrices[$specialKey]['date_to'] = $zendDate->setDate($specialPrice['date_to'], Varien_Date::DATE_INTERNAL_FORMAT)->toString($dateFormat);
                             }
                         }
                         $value['optionValues'][$i]['specials'] = $specialPrices;
                     }
                     //getOptionValueTierPrices
                     $tierPrices = $_value->getTiers();
                     if ($tierPrices) {
                         foreach ($tierPrices as $tierKey => $tierPrice) {
                             $tierPrices[$tierKey]['price'] = $this->getPriceValue($tierPrice['price'], $tierPrice['price_type']);
                         }
                         $value['optionValues'][$i]['tiers'] = $tierPrices;
                     }
                     if ($this->getProduct()->getStoreId() != '0') {
                         $value['optionValues'][$i]['checkboxScopeTitle'] = $this->getCheckboxScopeHtml($_value->getOptionId(), 'title', is_null($_value->getStoreTitle()), $_value->getOptionTypeId());
                         $value['optionValues'][$i]['scopeTitleDisabled'] = is_null($_value->getStoreTitle()) ? 'disabled' : null;
                         $value['optionValues'][$i]['checkboxScopeDescription'] = $this->getCheckboxScopeHtml($_value->getOptionId(), 'description', is_null($_value->getStoreDescription()), $_value->getOptionTypeId());
                         $value['optionValues'][$i]['scopeDescriptionDisabled'] = is_null($_value->getStoreDescription()) ? 'disabled' : null;
                         //if ($scope==Mage_Core_Model_Store::PRICE_SCOPE_WEBSITE) {
                         if (!$priceDisabled) {
                             $value['optionValues'][$i]['checkboxScopePrice'] = $this->getCheckboxScopeHtml($_value->getOptionId(), 'price', is_null($_value->getStorePrice()), $_value->getOptionTypeId());
                         }
                         $value['optionValues'][$i]['scopePriceDisabled'] = is_null($_value->getStorePrice()) ? 'disabled' : null;
                         //}
                     }
                     $i++;
                 }
             } else {
                 $priceDisabled = $option->getIsSkuPrice();
                 list($skuClass, $viewProductBySkuHtml) = $this->getViewSkuData($option->getSku());
                 $value['price'] = $this->getPriceValue($option->getPrice(), $option->getPriceType());
                 $value['price_type'] = $option->getPriceType();
                 $value['price_disabled'] = $priceDisabled;
                 $value['sku'] = $this->htmlEscape($option->getSku());
                 $value['sku_class'] = $skuClass;
                 $value['view_product_by_sku_html'] = $viewProductBySkuHtml;
                 $value['max_characters'] = $option->getMaxCharacters();
                 $value['default_text'] = $this->htmlEscape($option->getDefaultText());
                 $value['file_extension'] = $option->getFileExtension();
                 $value['image_size_x'] = $option->getImageSizeX();
                 $value['image_size_y'] = $option->getImageSizeY();
                 $imgHtml = $helper->getImgHtml($helper->getImgData($option->getImagePath(), $option->getId()));
                 if ($imgHtml) {
                     $value['image'] = $imgHtml;
                 }
                 if ($this->getProduct()->getStoreId() != '0') {
                     // && $scope == Mage_Core_Model_Store::PRICE_SCOPE_WEBSITE
                     if (!$priceDisabled) {
                         $value['checkboxScopePrice'] = $this->getCheckboxScopeHtml($option->getOptionId(), 'price', is_null($option->getStorePrice()));
                     }
                     $value['scopePriceDisabled'] = is_null($option->getStorePrice()) ? 'disabled' : null;
                     $value['checkboxScopeDefaultText'] = $this->getCheckboxScopeHtml($option->getOptionId(), 'default_text', is_null($option->getStoreDefaultText()));
                     $value['scopeDefaultTextDisabled'] = is_null($option->getStoreDefaultText()) ? 'disabled' : null;
                 }
             }
             $values[] = new Varien_Object($value);
         }
         $this->_values = $values;
     }
     return $this->_values;
 }
Example #19
0
 public function insert(array $data)
 {
     $periodStaus = self::periodStatus($data['period_id'], true);
     if ('FULL' != $periodStaus['STATUS']) {
         if ('PARTIAL' == $periodStaus['STATUS']) {
             if ('ALL' === strtoupper($data['group_id'])) {
                 throw new Zend_Exception('Period status is ' . $periodStaus['STATUS'] . '. ' . $data['group_id'] . ' groups can not be placed.', Zend_Log::WARN);
             }
             //TODO More strict check can also be implemented (It is still having some holes but hard to detect, I dont want to correct that because frontend covers that problem.).
             /* self::getLogger()->log('Future partial period!! Do something.', Zend_Log::DEBUG);
                $errVar = '';
                foreach ($periodStaus['periodStatus'] as $key => $value) {
                    $errVar .= "[$key] ::".var_export($value, true);
                }
                
                self::getLogger()->log('Future partial period. Attempt: '.var_export($data, true).' Actual: '.$errVar, Zend_Log::DEBUG);
                */
         }
         //TODO Include Block and Rooms
         $data['block_id'] = 'ADM_B1';
         $data['room_id'] = '1';
         $periodsCovered = $data['period'];
         for ($i = 1; $i < $data['period_duration']; ++$i) {
             $nextPeriod = $data['period'] + $i;
             $periodsCovered .= ',' . $nextPeriod;
         }
         $data['periods_covered'] = $periodsCovered;
         $date = new Zend_Date();
         $date->setDate($data['valid_from'], 'dd/MM/YYYY');
         $data['valid_from'] = $date->toString('YYYY-MM-dd');
         $data['valid_upto'] = Acad_Model_DbTable_AcademicSession::getSessionEndDate();
         $currentPeriodStatus = self::currentPeriodStatus($data['period_id'], TRUE);
         self::getDefaultAdapter()->beginTransaction();
         if ($currentPeriodStatus['STATUS'] != 'EMPTY') {
             self::updateCurrentValidity($currentPeriodStatus, $data['group_id'], $data['valid_from'], $data['periods_covered']);
         }
         unset($data['period']);
         unset($data['degree_id']);
         unset($data['semester_id']);
         unset($data['weekday_number']);
         self::getLogger()->log('Final data for insert', Zend_Log::INFO);
         self::getLogger()->log($data, Zend_Log::DEBUG);
         //Strange but NULL values are being accepted by MySQL(at least my server even in NOT NULL condition)
         //so im crossing checking null values
         foreach ($data as $column => $value) {
             if (!$value) {
                 self::getDefaultAdapter()->rollBack();
                 throw new Zend_Exception($column . ' should have some value.', Zend_Log::ERR);
             }
         }
         $newID = parent::insert($data);
         self::getDefaultAdapter()->commit();
         return $newID;
     } else {
         $errVar = '';
         foreach ($periodStaus['periodStatus'] as $key => $value) {
             $errVar .= "[{$key}] ::" . var_export($value, true);
         }
         throw new Zend_Exception('Future period entry confliction. Attempt: ' . var_export($data, true) . ' Actual: ' . $errVar, Zend_Log::WARN);
     }
 }
Example #20
0
 /**
  * Returns the difference in days between to dates.
  * @param mixed $from The start date/time representation (one of the values accepted by toZendDate)
  * @param mixed $to The end date/time representation (one of the values accepted by toZendDate)
  * @param string $timezone The timezone to set. Special values are:<ul>
  *	<li>'system' for the current system timezone</li>
  *	<li>'user' (default) for the user's timezone</li>
  *	<li>'app' for the app's timezone</li>
  *	<li>Other values: one of the PHP supported time zones (see http://us1.php.net/manual/en/timezones.php )</li>
  * </ul>
  * @return int|null Returns the difference in days (less than zero if $dateFrom if greater than $dateTo).
  * Returns null if one of both the dates can't be parsed.
  */
 public function getDeltaDays($from, $to, $timezone = 'user')
 {
     $zendFrom = $this->toZendDate($from, $timezone);
     $zendTo = $this->toZendDate($to, $timezone);
     if (is_null($zendFrom) || is_null($zendTo)) {
         return null;
     }
     $zendFromUTC = new Zend_Date();
     $zendToUTC = new Zend_Date();
     $zendFromUTC->setTimezone('GMT');
     $zendToUTC->setTimezone('GMT');
     $zendFromUTC->setDate($zendFrom->toString('Y-m-d'), 'Y-m-d');
     $zendToUTC->setDate($zendTo->toString('Y-m-d'), 'Y-m-d');
     $zendToUTC->sub($zendFromUTC);
     return round($zendToUTC->getTimestamp() / 86400);
 }
 protected function _saveOrder($data)
 {
     $fieldNoEnc = array('customers_id', 'orders_id', 'date_purchased', 'last_modified', 'orders_date_finished', 'orders_products_id', 'osc_magento_id', 'products_id');
     $importModel = $this->getImportModel();
     $timezone = $importModel->getTimezone();
     $customerIdPair = $this->getCustomerIdPair();
     $importId = $importModel->getId();
     $websiteId = $this->getWebsiteModel()->getId();
     if ($data['customers_id'] > 0 && isset($this->_customerIdPair[$data['customers_id']])) {
         foreach ($data as $field => $value) {
             if (!in_array($field, $fieldNoEnc)) {
                 $data[$field] = $this->convert($value);
             }
         }
         if ($data['date_purchased']) {
             $preparePurchased = explode(' ', $data['date_purchased']);
             $dateFormat = 'YYYY-MM-dd HH:mm:ss';
             $datePurchased = new Zend_Date();
             $datePurchased->setTimezone($timezone);
             $datePurchased->setDate($preparePurchased[0], 'YYYY-MM-dd');
             $datePurchased->setTime($preparePurchased[1], 'HH:mm:ss');
             $datePurchased->setTimezone('GMT');
             $data['date_purchased'] = $datePurchased->toString($dateFormat);
         }
         if ($data['last_modified']) {
             $prepareModified = explode(' ', $data['last_modified']);
             $dateModified = new Zend_Date();
             $dateModified->setTimezone($timezone);
             $dateModified->setDate($prepareModified[0], 'YYYY-MM-dd');
             $dateModified->setTime($prepareModified[1], 'HH:mm:ss');
             $dateModified->setTimezone('GMT');
             $data['last_modified'] = $dateModified->toString($dateFormat);
         }
         if ($data['orders_date_finished']) {
             $prepareFinished = explode(' ', $data['orders_date_finished']);
             $dateFinished = new Zend_Date();
             $dateFinished->setTimezone($timezone);
             $dateFinished->setDate($prepareFinished[0], 'YYYY-MM-dd');
             $dateFinished->setTime($prepareFinished[1], 'HH:mm:ss');
             $dateFinished->setTimezone('GMT');
             $data['orders_date_finished'] = $dateFinished->toString($dateFormat);
         }
         $data['magento_customers_id'] = $this->_customerIdPair[$data['customers_id']];
         // get Magento CustomerId
         $data['import_id'] = $importId;
         $data['website_id'] = $websiteId;
         $data['orders_status'] = $data['orders_status_name'];
         unset($data['orders_status_name']);
         $this->_getWriteAdapter()->insert($this->getTable('oscommerce_order'), $data);
         $oscMagentoId = $this->_getWriteAdapter()->lastInsertId();
         $this->_saveRows++;
         // Get orders products
         $select = "SELECT `orders_products_id`, `orders_id`, `products_id` ";
         $select .= ", `products_model`, `products_name`, `products_price`, `final_price` ";
         $select .= ", `products_tax`, `products_quantity` ";
         $select .= " FROM `{$this->getOscTable('orders_products')}` WHERE `orders_id`={$data['orders_id']}";
         if ($orderProducts = $this->_getForeignAdapter()->fetchAll($select)) {
             foreach ($orderProducts as $orderProduct) {
                 unset($orderProduct['orders_id']);
                 unset($orderProduct['orders_products_id']);
                 $orderProduct['osc_magento_id'] = $oscMagentoId;
                 foreach ($orderProduct as $field => $value) {
                     if (!in_array($field, $fieldNoEnc)) {
                         $orderProduct[$field] = $this->convert($value);
                     }
                 }
                 $this->_getWriteAdapter()->insert($this->getTable('oscommerce_order_products'), $orderProduct);
             }
         }
         // Get orders totals
         $select = "SELECT `orders_total_id`, `orders_id`, `title`, `text`, `value`, `class`, `sort_order` ";
         $select .= " FROM `{$this->getOscTable('orders_total')}` WHERE `orders_id`={$data['orders_id']} ORDER BY `sort_order`";
         if ($orderTotals = $this->_getForeignAdapter()->fetchAll($select)) {
             foreach ($orderTotals as $orderTotal) {
                 unset($orderTotal['orders_id']);
                 unset($orderTotal['orders_total_id']);
                 $orderTotal['osc_magento_id'] = $oscMagentoId;
                 $orderTotal['title'] = $this->convert($orderTotal['title']);
                 $orderTotal['text'] = $this->convert($orderTotal['text']);
                 $this->_getWriteAdapter()->insert($this->getTable('oscommerce_order_total'), $orderTotal);
             }
         }
         $defaultLanguage = $this->getOscDefaultLanguage();
         $defaultLanguageId = $defaultLanguage['id'];
         // Get orders status history
         $select = "SELECT `osh`.`orders_status_history_id`, `osh`.`orders_id`, `osh`.`orders_status_id` ";
         $select .= ", `os`.`orders_status_name` `orders_status`, `osh`.`date_added`, `osh`.`customer_notified`, `osh`.`comments` ";
         $select .= " FROM `{$this->getOscTable('orders_status_history')}` osh ";
         $select .= " LEFT JOIN `{$this->getOscTable('orders_status')}` os ON `os`.`orders_status_id`=`osh`.`orders_status_id` ";
         $select .= " AND `os`.`language_id`={$defaultLanguageId}";
         $select .= " WHERE `osh`.`orders_id`={$data['orders_id']}";
         if ($orderHistories = $this->_getForeignAdapter()->fetchAll($select)) {
             foreach ($orderHistories as $orderHistory) {
                 unset($orderHistory['orders_id']);
                 unset($orderHistory['orders_status_history_id']);
                 $orderHistory['osc_magento_id'] = $oscMagentoId;
                 $prepareAdded = explode(' ', $orderHistory['date_added']);
                 $dateFormat = 'YYYY-MM-dd HH:mm:ss';
                 $dateAdded = new Zend_Date();
                 $dateAdded->setTimezone($timezone);
                 $dateAdded->setDate($prepareAdded[0], 'YYYY-MM-dd');
                 $dateAdded->setTime($prepareAdded[1], 'HH:mm:ss');
                 $dateAdded->setTimezone('GMT');
                 $orderHistory['date_added'] = $dateAdded->toString($dateFormat);
                 $orderHistory['orders_status'] = $this->convert($orderHistory['orders_status']);
                 $orderHistory['comments'] = $this->convert($orderHistory['comments']);
                 $orderHistory['customer_notified'] = $this->convert($orderHistory['customer_notified']);
                 $this->_getWriteAdapter()->insert($this->getTable('oscommerce_order_history'), $orderHistory);
             }
         }
     } else {
         $this->_addErrors(Mage::helper('oscommerce')->__('Order #%s failed to import because the customer ID #%s associated with this order could not be found.', $data['orders_id'], $data['customers_id']));
     }
 }
 /**
  * @param $product
  * @param $special_price
  * @param $rules
  * @return bool
  */
 public function hasSpecialPrice($product, $special_price, $rules = true)
 {
     if ($rules && $this->hasPriceByCatalogRules($product)) {
         return true;
     }
     if ($special_price <= 0) {
         return false;
     }
     $cDate = Mage::app()->getLocale()->date(null, null, Mage::app()->getLocale()->getDefaultLocale());
     $timezone = Mage::app()->getStore($this->getStoreId())->getConfig(Mage_Core_Model_Locale::XML_PATH_DEFAULT_TIMEZONE);
     // From Date
     $fromDate = new Zend_Date(null, null, Mage::app()->getLocale()->getDefaultLocale());
     if ($timezone) {
         $fromDate->setTimezone($timezone);
     }
     $special_from_date = $product->getSpecialFromDate();
     if (is_empty_date($special_from_date)) {
         $special_from_date = $cDate->toString('yyyy-MM-dd HH:mm:ss');
     }
     $fromDate->setDate(substr($special_from_date, 0, 10), 'yyyy-MM-dd');
     $fromDate->setTime(substr($special_from_date, 11, 8), 'HH:mm:ss');
     // To Date
     $toDate = new Zend_Date(null, null, Mage::app()->getLocale()->getDefaultLocale());
     if ($timezone) {
         $toDate->setTimezone($timezone);
     }
     $special_to_date = $product->getSpecialToDate();
     if (is_empty_date($special_to_date)) {
         $special_to_date = $cDate->toString('yyyy-MM-dd HH:mm:ss');
     }
     if (is_empty_date($special_to_date)) {
         $toDate->add(365, Zend_Date::DAY);
     }
     $toDate->setDate(substr($special_to_date, 0, 10), 'yyyy-MM-dd');
     $toDate->setTime(substr($special_to_date, 11, 8), 'HH:mm:ss');
     if (($fromDate->compare($cDate) == -1 || $fromDate->compare($cDate) == 0) && ($toDate->compare($cDate) == 1 || $toDate->compare($cDate) == 0)) {
         return true;
     }
     return false;
 }
Example #23
0
 public function baseInit()
 {
     $dict = new Base_Dictionary();
     $date = new Zend_Date();
     $user = Zend_Auth::getInstance()->getIdentity();
     $client = Logic_Client::getInstance();
     $wsServiceSet = $client->getGroupListAsDict(Wsclient::GROUP_SERVICE_SET);
     $config = Zend_Registry::get('config');
     $this->addElement('text', 'name', array('required' => true, 'label' => 'Nazwa wysyłki'));
     $this->datee(false, "send_start", "Początek wysyłki");
     $this->send_start->setValue($date->getDate()->toString('YYYY-MM-dd'))->addValidator('Callback', false, array('callback' => function ($value) {
         $date = new Zend_Date();
         $date2 = clone $date;
         return $date->getTimestamp() <= $date2->setDate($value, 'YYYY-MM-dd')->getTimestamp();
     }));
     $this->timee(false, "time_send_start", "Okno czasowe od");
     $this->time_send_start->setValue('8:00');
     $this->timee(false, "time_send_end", "Okno czasowe do");
     $this->time_send_end->setValue('20:00');
     $this->time_send_end->addValidator('Callback', false, array('callback' => function ($value) {
         return strtotime($value) > strtotime($this->time_send_start->getValue());
     }));
     $this->datetimee(false, 'expiry_date', "Ważność wiadomości", false, array('value' => ''));
     $this->expiry_date->addValidator('Callback', false, array('callback' => function ($value) {
         $date = new Zend_Date();
         $date2 = clone $date;
         $date2->setDate($value, 'YYYY-MM-dd HH:mm');
         $date->setDate($this->send_start->getValue(), 'YYYY-MM-dd HH:mm');
         return $date->getTimestamp() <= $date2->getTimestamp() && $date->addHour(72)->getTimestamp() >= $date2->getTimestamp();
     }));
     $this->expiry_date->getValidator('Callback')->setMessages(array(Zend_Validate_Callback::INVALID_VALUE => "Data ważności wiadmości może wynosić maksymalnie 72 godziny"));
     $this->addElement('checkbox', 'repeat_message', array('label' => 'Powtarzaj tą wiadomość', 'attribs' => array('onchange' => 'checkPackageOptions();')));
     $this->repeat_message->addValidator('Callback', false, array('callback' => function ($value) {
         if ($value) {
             $this->repeat_interval->setRequired(true);
             $this->repeat_count->setRequired(true);
             $this->repeat_end->setRequired(true);
         }
         return true;
     }));
     $this->addElement('radio', 'repeat_interval', array('MultiOptions' => $dict->setSource('package_repeat')->getDictionary(), 'attribs' => array('disable' => 'disable'), 'attribs' => array('onchange' => 'checkPackageOptions();')));
     $this->repeat_interval->addValidator('Callback', false, array('callback' => function ($value) {
         if ($value == 5) {
             $this->repeat_days->setRequired(true);
         } elseif ($value == 4) {
             $this->repeat_day_interval->setRequired(true);
         }
         return true;
     }));
     $this->addElement('multiselect', 'repeat_days', array('MultiOptions' => $dict->setSource('day_of_week')->getDictionary(), 'attribs' => array('disable' => 'disable')));
     $this->addElement('text', 'repeat_day_interval', array('label' => 'Powtarzań wiadomość co (liczba dni)', 'attribs' => array('disable' => 'disable')));
     $this->addElement('text', 'repeat_count', array('label' => 'Ilość powtórzeń wiadomości', 'attribs' => array('disable' => 'disable')));
     $this->datetimee(false, "repeat_end", "Powtarzań do", false, array('value' => '', 'attribs' => array('disabled' => 'disabled')));
     $this->repeat_end->addValidator('Callback', false, array('callback' => function ($value) {
         $date = new Zend_Date();
         $date2 = clone $date;
         $date->setDate($value, 'YYYY-MM-dd HH:mm');
         $date2->setDate($this->send_start->getValue(), 'YYYY-MM-dd HH:mm');
         return $date->getTimestamp() <= $date2->setDate($value, 'YYYY-MM-dd HH:mm')->getTimestamp();
     }));
     $this->addElement('select', 'ws_service_set_id', array('label' => 'Wysyłka', 'required' => true, 'MultiOptions' => $this->addClearStart($wsServiceSet), 'attribs' => array('onchange' => 'getServiceSetOptions();')));
     $this->addElement('select', 'file_type', array('required' => true, 'label' => 'Typ wysyłki:', 'multioptions' => $this->addClearStart($dict->setSource('service_import_file_type')->getDictionary())));
     $this->addElement('file', 'addressbook_import_csv', array('label' => 'CSV z listą kontaktów do zaimportowania', 'decorators' => $this->_fileDecorator, 'validators' => array(array('Extension', false, 'csv'), array('Size', false, $config['uploads']['maxfilesize']))));
     $this->addElement('select', 'delimeter', array('label' => "Separator pola", 'MultiOptions' => $this->addClearStart($dict->setSource('csv_delimeter')->getDictionary())));
     $this->addElement('select', 'phone_heders', array('label' => "Kolumna z kontaktami"));
     $this->addElement('select', 'ws_addressbook_id', array('label' => 'Adresy', 'MultiOptions' => $this->addClearStart($dict->setSource(new Addressbook(), array('created_by =' . (int) $user->id, 'ghost=false'), 'id', 'id', array('addressbook_name'))->getDictionary())));
     $this->addDisplayGroup(array($this->addressbook_import_csv, $this->delimeter, $this->phone_heders), 'tags_import');
     $this->addElement('select', 'message_heders', array('label' => "Kolumna z wiadomością"));
     $this->submit(false, 'save_send', 'Wyślij');
     $this->submit();
     $this->cancel();
 }
 public function getOptionValues()
 {
     $data = array();
     $optionsArr = '';
     $data = $this->getTemplateData();
     if (isset($data['hash_options'])) {
         $optionsArr = $data['hash_options'];
     }
     $zendDate = new Zend_Date();
     $dateFormat = Mage::app()->getLocale()->getDateFormat(Mage_Core_Model_Locale::FORMAT_TYPE_SHORT);
     $helper = Mage::helper('customoptions');
     $helper->getCustomerGroups();
     // init customer_groups for sort prices
     $groupId = (int) $this->getRequest()->getParam('group_id');
     if ($optionsArr) {
         $optionsArr = unserialize($optionsArr);
     }
     $store = Mage::app()->getStore($this->getStoreId());
     $storeOptionsArr = array();
     $groupStore = Mage::getSingleton('customoptions/group_store')->loadByGroupAndStore($groupId, $this->getStoreId());
     if ($groupStore->getHashOptions()) {
         $storeOptionsArr = unserialize($groupStore->getHashOptions());
     }
     //print_r($storeOptionsArr); exit;
     $optionModel = Mage::getSingleton('catalog/product_option');
     if (!$this->_values && $optionsArr) {
         $values = array();
         $sortOrder = array();
         $scope = (int) Mage::app()->getStore()->getConfig(Mage_Core_Model_Store::XML_PATH_PRICE_SCOPE);
         $optionItemCount = count($optionsArr);
         foreach ($optionsArr as $optionId => $option) {
             $option = new Varien_Object($option);
             $value = array();
             if ($option->getIsDelete() != '1') {
                 $value['id'] = $option->getOptionId();
                 $value['item_count'] = $optionItemCount;
                 $value['option_id'] = $option->getOptionId();
                 $value['title'] = $this->htmlEscape(isset($storeOptionsArr[$optionId]['title']) ? $storeOptionsArr[$optionId]['title'] : $option->getTitle());
                 // old view_mode = hidden => to new type = 'hidden';
                 if ($optionModel->getGroupByType($option->getType()) == Mage_Catalog_Model_Product_Option::OPTION_GROUP_SELECT && $option->getViewMode() == 2) {
                     $option->setType('hidden');
                     $option->setViewMode(1);
                 }
                 $value['type'] = $option->getType();
                 $value['is_require'] = $option->getIsRequire();
                 $value['view_mode'] = isset($storeOptionsArr[$optionId]['view_mode']) ? $storeOptionsArr[$optionId]['view_mode'] : $option->getViewMode();
                 $value['is_dependent'] = $option->getIsDependent();
                 $value['div_class'] = $option->getDivClass();
                 $value['sku_policy'] = $option->getSkuPolicy();
                 $value['customoptions_is_onetime'] = $option->getCustomoptionsIsOnetime();
                 $value['qnty_input'] = $option->getQntyInput() ? 'checked' : '';
                 $value['qnty_input_disabled'] = $option->getType() == 'multiple' || $option->getType() == 'hidden' ? 'disabled' : '';
                 $value['image_mode'] = $option->getImageMode();
                 $value['image_mode_disabled'] = $optionModel->getGroupByType($option->getType()) != Mage_Catalog_Model_Product_Option::OPTION_GROUP_SELECT ? 'disabled' : '';
                 $value['exclude_first_image'] = $option->getExcludeFirstImage() ? 'checked' : '';
                 $value['description'] = $this->htmlEscape(isset($storeOptionsArr[$optionId]['description']) ? $storeOptionsArr[$optionId]['description'] : $option->getDescription());
                 if ($helper->isCustomerGroupsEnabled() && $option->getCustomerGroups() != null) {
                     $value['customer_groups'] = implode(',', $option->getCustomerGroups());
                 }
                 if ($helper->isStoreViewsEnabled() && $option->getStoreViews() != null) {
                     $value['store_views'] = implode(',', $option->getStoreViews());
                 }
                 $value['in_group_id'] = $option->getInGroupId();
                 $value['in_group_id_view'] = $option->getInGroupId();
                 $value['sort_order'] = $this->_getSortOrder($option);
                 if ($this->getStoreId() != '0') {
                     $value['checkboxScopeTitle'] = $this->getCheckboxScopeHtml($option->getOptionId(), 'title', !isset($storeOptionsArr[$optionId]['title']));
                     $value['scopeTitleDisabled'] = !isset($storeOptionsArr[$optionId]['title']) ? 'disabled' : null;
                     $value['checkboxScopeViewMode'] = $this->getCheckboxScopeHtml($option->getOptionId(), 'view_mode', !isset($storeOptionsArr[$optionId]['view_mode']));
                     $value['scopeViewModeDisabled'] = !isset($storeOptionsArr[$optionId]['view_mode']) ? 'disabled' : null;
                     $value['checkboxScopeDescription'] = $this->getCheckboxScopeHtml($option->getOptionId(), 'description', !isset($storeOptionsArr[$optionId]['description']));
                     $value['scopeDescriptionDisabled'] = !isset($storeOptionsArr[$optionId]['description']) ? 'disabled' : null;
                 }
                 if ($optionModel->getGroupByType($option->getType()) == Mage_Catalog_Model_Product_Option::OPTION_GROUP_SELECT) {
                     $countValues = count($option->getValues());
                     if ($countValues > 0) {
                         foreach ($option->getValues() as $key => $_value) {
                             $_value = new Varien_Object($_value);
                             $_value->setOptionTypeId($key);
                             if ($_value->getIsDelete() != '1') {
                                 $defaultArray = $option->getDefault() !== null ? $option->getDefault() : array();
                                 if (isset($storeOptionsArr[$optionId]['values'][$_value->getOptionTypeId()]['price'])) {
                                     $_value->setPrice(floatval($storeOptionsArr[$optionId]['values'][$_value->getOptionTypeId()]['price']));
                                 }
                                 if (isset($storeOptionsArr[$optionId]['values'][$_value->getOptionTypeId()]['price_type'])) {
                                     $_value->setPriceType($storeOptionsArr[$optionId]['values'][$_value->getOptionTypeId()]['price_type']);
                                 }
                                 // for support old format:
                                 if (isset($storeOptionsArr[$optionId]['values'][$_value->getOptionTypeId()]['special_price'])) {
                                     $_value->setSpecialPrice(floatval($storeOptionsArr[$optionId]['values'][$_value->getOptionTypeId()]['special_price']));
                                 }
                                 if (isset($storeOptionsArr[$optionId]['values'][$_value->getOptionTypeId()]['special_comment'])) {
                                     $_value->setSpecialComment($storeOptionsArr[$optionId]['values'][$_value->getOptionTypeId()]['special_comment']);
                                 }
                                 if ($_value->getSpecialPrice()) {
                                     $_value->setSpecials(array(array('customer_group_id' => 32000, 'price' => $_value->getSpecialPrice(), 'price_type' => 'fixed', 'comment' => $_value->getSpecialComment(), 'date_from' => '', 'date_to' => '')));
                                 }
                                 $helper->applyLinkedBySkuDataToOption($_value, $_value->getSku(), $store, 0);
                                 $helper->calculateOptionSpecialPrice($_value, null, $helper->isSpecialPriceEnabled());
                                 $priceDisabled = $_value->getIsSkuPrice();
                                 list($skuClass, $viewProductBySkuHtml) = $this->getViewSkuData($_value->getSku());
                                 if (!$helper->isSkuQtyLinkingEnabled() || $helper->getProductIdBySku($_value->getSku()) == 0) {
                                     $customoptionsQty = $_value->getCustomoptionsQty();
                                 } else {
                                     list($customoptionsQty, $backorders) = $helper->getCustomoptionsQty($_value->getCustomoptionsQty(), $_value->getSku(), 0, null, null, null, true);
                                 }
                                 $value['optionValues'][$key] = array('item_count' => $countValues, 'option_id' => $option->getOptionId(), 'option_type_id' => $_value->getOptionTypeId(), 'title' => $this->htmlEscape(isset($storeOptionsArr[$optionId]['values'][$_value->getOptionTypeId()]['title']) ? $storeOptionsArr[$optionId]['values'][$_value->getOptionTypeId()]['title'] : $_value->getTitle()), 'price' => $this->getPriceValue($_value->getPrice(), $_value->getPriceType()), 'price_type' => $_value->getPriceType(), 'price_disabled' => $priceDisabled, 'description' => $this->htmlEscape(isset($storeOptionsArr[$optionId]['values'][$_value->getOptionTypeId()]['description']) ? $storeOptionsArr[$optionId]['values'][$_value->getOptionTypeId()]['description'] : $_value->getDescription()), 'cost' => $this->getPriceValue($_value->getCost(), 'fixed'), 'cost_disabled' => $_value->getIsSkuCost() ? 'disabled' : '', 'customoptions_qty' => $customoptionsQty, 'customoptions_qty_disabled' => $helper->isSkuQtyLinkingEnabled() && $helper->getProductIdBySku($_value->getSku()) ? 'disabled="disabled"' : '', 'sku' => $this->htmlEscape($_value->getSku()), 'sku_class' => $skuClass, 'view_product_by_sku_html' => $viewProductBySkuHtml, 'image_button_label' => $helper->__('Add Image'), 'sort_order' => $this->_getSortOrder($_value), 'checked' => array_search($_value->getOptionTypeId(), $defaultArray) !== false ? 'checked' : '', 'default_type' => $option->getType() == 'checkbox' || $option->getType() == 'multiple' || $option->getType() == 'multiswatch' || $option->getType() == 'hidden' ? 'checkbox' : 'radio', 'in_group_id' => $_value->getInGroupId(), 'in_group_id_view' => $_value->getInGroupId(), 'dependent_ids' => $_value->getDependentIds(), 'weight' => number_format(floatval($_value->getWeight()), 4, null, ''), 'weight_disabled' => $_value->getIsSkuWeight() ? 'disabled' : '');
                                 // getImages
                                 $images = $_value->getImages();
                                 if ($images) {
                                     $imagePath = $groupId . DS . $option->getId() . DS . $_value->getOptionTypeId() . DS;
                                     foreach ($images as $fileName) {
                                         if (substr($fileName, 0, 1) == '#') {
                                             // color
                                             $colorArr = array('id' => $option->getId(), 'select_id' => $_value->getOptionTypeId(), 'image_file' => $fileName, 'option_type_image_id' => $fileName, 'source' => 2);
                                             $value['optionValues'][$key]['images'][] = $colorArr;
                                         } else {
                                             // file
                                             $imgArr = $helper->getImgData($imagePath . $fileName, $option->getId(), $_value->getOptionTypeId());
                                             if ($imgArr) {
                                                 $imgArr['option_type_image_id'] = $imgArr['file_name'];
                                                 $value['optionValues'][$key]['images'][] = $imgArr;
                                             }
                                         }
                                     }
                                 } elseif ($_value->getImagePath()) {
                                     // old format
                                     $imgArr = $helper->getImgData($_value->getImagePath(), $option->getId(), $_value->getOptionTypeId());
                                     if ($imgArr) {
                                         $imgArr['option_type_image_id'] = $imgArr['file_name'];
                                         $value['optionValues'][$key]['images'][] = $imgArr;
                                     }
                                 } else {
                                     $value['optionValues'][$key]['image_tr_style'] = 'display:none';
                                 }
                                 //getOptionValueSpecialPrices
                                 $specialPrices = isset($storeOptionsArr[$optionId]['values'][$_value->getOptionTypeId()]['specials']) ? $storeOptionsArr[$optionId]['values'][$_value->getOptionTypeId()]['specials'] : $_value->getSpecials();
                                 if ($specialPrices) {
                                     foreach ($specialPrices as $specialKey => $specialPrice) {
                                         $specialPrices[$specialKey]['price'] = $this->getPriceValue($specialPrice['price'], $specialPrice['price_type']);
                                         if (isset($specialPrice['date_from']) && $specialPrice['date_from']) {
                                             $specialPrices[$specialKey]['date_from'] = $zendDate->setDate($specialPrice['date_from'], Varien_Date::DATE_INTERNAL_FORMAT)->toString($dateFormat);
                                         } else {
                                             $specialPrices[$specialKey]['date_from'] = '';
                                         }
                                         if (isset($specialPrice['date_to']) && $specialPrice['date_to']) {
                                             $specialPrices[$specialKey]['date_to'] = $zendDate->setDate($specialPrice['date_to'], Varien_Date::DATE_INTERNAL_FORMAT)->toString($dateFormat);
                                         } else {
                                             $specialPrices[$specialKey]['date_to'] = '';
                                         }
                                     }
                                     usort($specialPrices, array($helper, '_sortPrices'));
                                     $value['optionValues'][$key]['specials'] = $specialPrices;
                                 }
                                 //getOptionValueTierPrices
                                 $tierPrices = isset($storeOptionsArr[$optionId]['values'][$_value->getOptionTypeId()]['tiers']) ? $storeOptionsArr[$optionId]['values'][$_value->getOptionTypeId()]['tiers'] : $_value->getTiers();
                                 if ($tierPrices) {
                                     foreach ($tierPrices as $tierKey => $tierPrice) {
                                         $tierPrices[$tierKey]['price'] = $this->getPriceValue($tierPrice['price'], $tierPrice['price_type']);
                                     }
                                     usort($tierPrices, array($helper, '_sortPrices'));
                                     $value['optionValues'][$key]['tiers'] = $tierPrices;
                                 }
                                 if ($this->getStoreId() != '0') {
                                     $value['optionValues'][$key]['checkboxScopeTitle'] = $this->getCheckboxScopeHtml($option->getOptionId(), 'title', !isset($storeOptionsArr[$optionId]['values'][$_value->getOptionTypeId()]['title']), $_value->getOptionTypeId());
                                     $value['optionValues'][$key]['scopeTitleDisabled'] = !isset($storeOptionsArr[$optionId]['values'][$_value->getOptionTypeId()]['title']) ? 'disabled' : null;
                                     $value['optionValues'][$key]['checkboxScopeDescription'] = $this->getCheckboxScopeHtml($option->getOptionId(), 'description', !isset($storeOptionsArr[$optionId]['values'][$_value->getOptionTypeId()]['description']), $_value->getOptionTypeId());
                                     $value['optionValues'][$key]['scopeDescriptionDisabled'] = !isset($storeOptionsArr[$optionId]['values'][$_value->getOptionTypeId()]['description']) ? 'disabled' : null;
                                     //if ($scope == Mage_Core_Model_Store::PRICE_SCOPE_WEBSITE) {
                                     if (isset($storeOptionsArr[$optionId]['values'][$_value->getOptionTypeId()]['price'])) {
                                         $scopePrice = true;
                                     } else {
                                         $scopePrice = false;
                                     }
                                     if (!$priceDisabled) {
                                         $value['optionValues'][$key]['checkboxScopePrice'] = $this->getCheckboxScopeHtml($option->getOptionId(), 'price', !$scopePrice, $_value->getOptionTypeId());
                                     }
                                     $value['optionValues'][$key]['scopePriceDisabled'] = !$scopePrice ? 'disabled' : null;
                                     //}
                                 }
                             }
                         }
                         $value['optionValues'] = array_values($value['optionValues']);
                     }
                 } else {
                     if (isset($storeOptionsArr[$optionId]['price'])) {
                         $option->setPrice(floatval($storeOptionsArr[$optionId]['price']));
                     }
                     if (isset($storeOptionsArr[$optionId]['price_type'])) {
                         $option->setPriceType($storeOptionsArr[$optionId]['price_type']);
                     }
                     $helper->applyLinkedBySkuDataToOption($option, $option->getSku(), $store, 0);
                     $helper->calculateOptionSpecialPrice($option, null, false);
                     $priceDisabled = $option->getIsSkuPrice();
                     list($skuClass, $viewProductBySkuHtml) = $this->getViewSkuData($option->getSku());
                     $value['price'] = $this->getPriceValue($option->getPrice(), $option->getPriceType());
                     $value['price_type'] = $option->getPriceType();
                     $value['price_disabled'] = $priceDisabled;
                     $value['sku'] = $this->htmlEscape($option->getSku());
                     $value['sku_class'] = $skuClass;
                     $value['view_product_by_sku_html'] = $viewProductBySkuHtml;
                     $value['max_characters'] = $option->getMaxCharacters();
                     $value['default_text'] = $this->htmlEscape(isset($storeOptionsArr[$optionId]['default_text']) ? $storeOptionsArr[$optionId]['default_text'] : $option->getDefaultText());
                     $value['file_extension'] = $option->getFileExtension();
                     $value['image_size_x'] = $option->getImageSizeX();
                     $value['image_size_y'] = $option->getImageSizeY();
                     $value['image_button_label'] = $helper->__('Add Image');
                     $imgHtml = $helper->getImgHtml($helper->getImgData($option->getImagePath(), $option->getId()));
                     if ($imgHtml) {
                         $value['image'] = $imgHtml;
                         $value['image_button_label'] = $helper->__('Change Image');
                     }
                     if ($this->getStoreId() != '0') {
                         //&& $scope == Mage_Core_Model_Store::PRICE_SCOPE_WEBSITE
                         if (!$priceDisabled) {
                             $value['checkboxScopePrice'] = $this->getCheckboxScopeHtml($option->getOptionId(), 'price', !isset($storeOptionsArr[$optionId]['price']));
                         }
                         $value['scopePriceDisabled'] = !isset($storeOptionsArr[$optionId]['price']) ? 'disabled' : null;
                         $value['checkboxScopeDefaultText'] = $this->getCheckboxScopeHtml($option->getOptionId(), 'default_text', !isset($storeOptionsArr[$optionId]['default_text']));
                         $value['scopeDefaultTextDisabled'] = !isset($storeOptionsArr[$optionId]['default_text']) ? 'disabled' : null;
                     }
                 }
                 $values[] = new Varien_Object($value);
             }
         }
         $this->_values = $values;
     }
     return $this->_values ? $this->_values : array();
 }
Example #25
0
 public function toTimestamp($date, $format = Mage_Core_Model_Locale::FORMAT_TYPE_SHORT)
 {
     $dateFormat = Mage::app()->getLocale()->getDateFormat($format);
     $dateObj = new Zend_Date();
     if ($date) {
         try {
             $dateObj->setDate($date, $dateFormat);
         } catch (Exception $ex) {
             try {
                 $dateObj->setDate($date);
             } catch (Exception $ex) {
                 if ($timestamp = @strtotime($date)) {
                     $dateObj->setTimestamp($timestamp);
                 }
             }
         }
         $dateObj->setTime(0);
     }
     return $dateObj->getTimestamp();
 }
 public function saveAction()
 {
     @ini_set('max_execution_time', 1800);
     @ini_set('memory_limit', 534003200);
     $helper = Mage::helper('customoptions');
     $productOptionModel = Mage::getModel('catalog/product_option');
     $zendDate = new Zend_Date();
     $dateFormat = Mage::app()->getLocale()->getDateFormat(Mage_Core_Model_Locale::FORMAT_TYPE_SHORT);
     $data = $this->getRequest()->getPost();
     $id = (int) $this->getRequest()->getParam('group_id');
     $storeId = (int) $this->getRequest()->getParam('store', 0);
     $redirectParams = array('group_id' => $id);
     if ($storeId > 0) {
         $redirectParams['store'] = $storeId;
     }
     $error = false;
     if ($data) {
         $data = $helper->getFilter($data);
         try {
             // prepare Assign by -> $data['in_products']
             if (isset($data['products_area_type']) && $data['products_area_type'] > 1 && isset($data['products_area'])) {
                 if ($data['in_products']) {
                     $productIds = explode(',', $data['in_products']);
                 } else {
                     $productIds = array();
                 }
                 switch ($data['products_area_type']) {
                     case 2:
                         // by product ids
                         $productArea = explode(',', $data['products_area']);
                         foreach ($productArea as $productId) {
                             $productId = intval($productId);
                             if ($productId && !in_array($productId, $productIds)) {
                                 $product = Mage::getSingleton('catalog/product')->load($productId);
                                 if ($product && $product->getId() > 0) {
                                     $productIds[] = $productId;
                                 }
                             }
                         }
                         $data['in_products'] = implode(',', $productIds);
                         break;
                     case 3:
                         // by SKUs
                         $productArea = explode(',', $data['products_area']);
                         foreach ($productArea as $sku) {
                             $sku = trim($sku);
                             $productId = $helper->getProductIdBySku($sku);
                             if ($productId && !in_array($productId, $productIds)) {
                                 $productIds[] = $productId;
                             }
                         }
                         $data['in_products'] = implode(',', $productIds);
                         break;
                 }
             }
             $productOptions = array();
             if (!isset($data['product']['options']) || $this->_isEmptyOptions($data['product']['options'])) {
                 Mage::getSingleton('adminhtml/session')->addError($this->__('There are no Options'));
                 $error = true;
             } else {
                 // first prepare options: id=-1 -> id=$key
                 $productOptions = $data['product']['options'];
                 foreach ($productOptions as $i => $option) {
                     if (isset($option['values'])) {
                         if (count($option['values']) > 0) {
                             foreach ($option['values'] as $key => $value) {
                                 if ($value['option_type_id'] == '-1') {
                                     $option['values'][$key]['option_type_id'] = (string) $key;
                                 }
                                 if (!isset($value['scope']['price'])) {
                                     if (!isset($value['price'])) {
                                         $option['values'][$key]['price'] = '0.00';
                                     }
                                     if (!isset($value['price_type'])) {
                                         $option['values'][$key]['price_type'] = 'fixed';
                                     }
                                 }
                                 if (isset($value['specials'])) {
                                     if (count($value['specials']) > 0) {
                                         // uniq by group
                                         $specials = array();
                                         foreach ($value['specials'] as $sKey => $sValue) {
                                             if ($sValue['is_delete'] == '1') {
                                                 continue;
                                             }
                                             if ($sValue['special_price_id'] == '-1') {
                                                 $sValue['special_price_id'] = (string) $sKey;
                                             }
                                             $sValue['comment'] = trim($sValue['comment']);
                                             if (isset($sValue['date_from']) && $sValue['date_from']) {
                                                 $sValue['date_from'] = $zendDate->setDate($sValue['date_from'], $dateFormat)->toString(Varien_Date::DATE_INTERNAL_FORMAT);
                                             } else {
                                                 $sValue['date_from'] = '';
                                             }
                                             if (isset($sValue['date_to']) && $sValue['date_to']) {
                                                 $sValue['date_to'] = $zendDate->setDate($sValue['date_to'], $dateFormat)->toString(Varien_Date::DATE_INTERNAL_FORMAT);
                                             } else {
                                                 $sValue['date_to'] = '';
                                             }
                                             if (!isset($specials[$sValue['customer_group_id']])) {
                                                 $specials[$sValue['customer_group_id']] = $sValue;
                                             }
                                         }
                                         $option['values'][$key]['specials'] = array();
                                         foreach ($specials as $sValue) {
                                             $option['values'][$key]['specials'][$sValue['special_price_id']] = $sValue;
                                         }
                                     } else {
                                         unset($option['values'][$key]['specials']);
                                     }
                                 }
                                 if (isset($value['tiers'])) {
                                     if (count($value['tiers']) > 0) {
                                         // uniq by group and qty
                                         $tiers = array();
                                         foreach ($value['tiers'] as $tkey => $tValue) {
                                             if ($tValue['is_delete'] == '1') {
                                                 continue;
                                             }
                                             $tValue['qty'] = intval($tValue['qty']);
                                             if ($tValue['qty'] == 0) {
                                                 continue;
                                             }
                                             if ($tValue['tier_price_id'] == '-1') {
                                                 $tValue['tier_price_id'] = (string) $tkey;
                                             }
                                             if (!isset($tiers[$tValue['customer_group_id'] . '+' . $tValue['qty']])) {
                                                 $tiers[$tValue['customer_group_id'] . '+' . $tValue['qty']] = $tValue;
                                             }
                                         }
                                         $option['values'][$key]['tiers'] = array();
                                         foreach ($tiers as $tValue) {
                                             $option['values'][$key]['tiers'][$tValue['tier_price_id']] = $tValue;
                                         }
                                     } else {
                                         unset($option['values'][$key]['tiers']);
                                     }
                                 }
                                 if ($helper->isSkuNameLinkingEnabled() && (!isset($value['title']) || $value['title'] == '') && $value['sku']) {
                                     $option['values'][$key]['title'] = $helper->getProductNameBySku($value['sku'], $storeId);
                                 }
                             }
                         } else {
                             unset($option['values']);
                         }
                     } else {
                         if (!isset($option['scope']['price'])) {
                             if (!isset($option['price'])) {
                                 $option['price'] = '0.00';
                             }
                             if (!isset($option['price_type'])) {
                                 $option['price_type'] = 'fixed';
                             }
                         }
                         if ($helper->isSkuNameLinkingEnabled() && (!isset($option['title']) || $option['title'] == '') && $productOptionModel->getGroupByType($option['type']) != Mage_Catalog_Model_Product_Option::OPTION_GROUP_SELECT && $option['sku']) {
                             $option['title'] = $helper->getProductNameBySku($option['sku'], $storeId);
                         }
                     }
                     $option['option_id'] = $i;
                     // qnty_input
                     if (!isset($option['qnty_input']) || $productOptionModel->getGroupByType($option['type']) != Mage_Catalog_Model_Product_Option::OPTION_GROUP_SELECT || $option['type'] == 'multiple' || $option['type'] == 'hidden') {
                         $option['qnty_input'] = 0;
                     }
                     // exclude_first_image
                     if (!isset($option['exclude_first_image']) || $productOptionModel->getGroupByType($option['type']) != Mage_Catalog_Model_Product_Option::OPTION_GROUP_SELECT) {
                         $option['exclude_first_image'] = 0;
                     }
                     $productOptions[$i] = $option;
                 }
                 $data['general']['hash_options'] = serialize(array());
             }
             if ($error) {
                 if (isset($data['in_products']) && is_array($data['in_products']) && count($data['in_products']) > 0) {
                     $data['in_products'] = implode(',', $data['in_products']);
                 }
                 throw new Exception();
             }
             $optionsPrev = array();
             $prevGroupIsActive = 1;
             if ($id) {
                 $group = Mage::getSingleton('customoptions/group')->load($id);
                 $prevGroupIsActive = $group->getIsActive();
                 if ($group->getHashOptions() != '') {
                     $optionsPrev = unserialize($group->getHashOptions());
                 }
             } else {
                 $group = Mage::getSingleton('customoptions/group');
             }
             // insert
             if (!$id) {
                 $group->setData($data['general']);
                 $group->save();
                 $id = $group->getId();
             }
             $productIds = array();
             if (isset($data['in_products']) && $data['in_products']) {
                 $productIds = explode(',', $data['in_products']);
             }
             //remove files
             if (isset($data['image_delete'])) {
                 foreach ($data['image_delete'] as $optionId) {
                     if ($optionId) {
                         $helper->deleteOptionFile($group->getId(), $optionId);
                     }
                 }
             }
             //upload files
             foreach ($productOptions as $key => $option) {
                 if ($option['option_id'] == 0) {
                     $option['option_id'] = 1;
                 }
                 switch ($option['type']) {
                     case 'field':
                     case 'area':
                         $this->_uploadImage('file_' . $option['option_id'], $id, $option['option_id']);
                         if (isset($option['id'])) {
                             if ($helper->isCustomOptionsFile($id, $option['id'])) {
                                 $option['image_path'] = $id . DS . $option['id'] . DS;
                             } else {
                                 $option['image_path'] = '';
                             }
                         }
                         $productOptions[$key] = $option;
                         break;
                     case 'drop_down':
                     case 'radio':
                     case 'checkbox':
                     case 'multiple':
                     case 'swatch':
                     case 'multiswatch':
                     case 'hidden':
                         if (isset($option['values']) && is_array($option['values']) && !empty($option['values'])) {
                             foreach ($option['values'] as $k => $value) {
                                 $counter = $value['option_type_id'] == '-1' ? $k : $value['option_type_id'];
                                 $value['images'] = $this->_uploadImage('file_' . $option['option_id'] . '_' . $counter, $id, $option['option_id'], $counter, $value);
                                 $productOptions[$key]['values'][$k] = $value;
                             }
                         }
                         break;
                     case 'file':
                     case 'date':
                     case 'date_time':
                     case 'time':
                         // no image
                         if (isset($option['option_id'])) {
                             $helper->deleteOptionFile($id, $option['option_id']);
                         }
                         break;
                 }
             }
             $prevStoreOptionsData = array();
             if ($storeId > 0) {
                 // if no default store
                 $defaultOptions = $optionsPrev;
                 // add to store defoult values + add new options to defoult or mark is_delete flag
                 foreach ($productOptions as $key => $option) {
                     if (isset($optionsPrev[$key])) {
                         if (isset($option['scope'])) {
                             foreach ($option['scope'] as $field => $value) {
                                 if ($value && isset($optionsPrev[$key][$field])) {
                                     $productOptions[$key][$field] = $optionsPrev[$key][$field];
                                 }
                             }
                             unset($productOptions[$key]['scope']);
                         }
                         $defaultOptions[$key]['is_delete'] = $option['is_delete'];
                         if (isset($option['values'])) {
                             foreach ($option['values'] as $valueId => $optionValue) {
                                 if (isset($optionsPrev[$key]['values'][$valueId])) {
                                     if (isset($optionValue['scope'])) {
                                         foreach ($optionValue['scope'] as $field => $value) {
                                             if ($value && isset($optionsPrev[$key]['values'][$valueId][$field])) {
                                                 $productOptions[$key]['values'][$valueId][$field] = $optionsPrev[$key]['values'][$valueId][$field];
                                             }
                                         }
                                         unset($productOptions[$key]['values'][$valueId]['scope']);
                                     }
                                     $defaultOptions[$key]['values'][$valueId]['is_delete'] = $optionValue['is_delete'];
                                 } else {
                                     // found new option value
                                     $defaultOptions[$key]['values'][$valueId] = $optionValue;
                                 }
                             }
                         }
                     } else {
                         // found new option
                         $defaultOptions[$key] = $option;
                     }
                 }
                 // difference default and store - quadruple nesting
                 //$storeOptions = $this->comparisonArrays4($productOptions, $defaultOptions);
                 // difference default and store
                 $storeOptions = Mage::getSingleton('catalog/product_option')->comparisonArrays($productOptions, $defaultOptions);
                 // add option_id/option_type_id/type to $storeOptions
                 foreach ($storeOptions as $optionId => $option) {
                     $storeOptions[$optionId]['option_id'] = $optionId;
                     $storeOptions[$optionId]['type'] = $productOptions[$optionId]['type'];
                     if (isset($option['price']) && !isset($option['price_type'])) {
                         $storeOptions[$optionId]['price_type'] = $productOptions[$optionId]['price_type'];
                     }
                     if (!isset($option['price']) && isset($option['price_type'])) {
                         $storeOptions[$optionId]['price'] = $productOptions[$optionId]['price'];
                     }
                     if (isset($option['values'])) {
                         foreach ($option['values'] as $valueId => $optionValue) {
                             $storeOptions[$optionId]['values'][$valueId]['option_type_id'] = $valueId;
                             if (isset($optionValue['price']) || isset($optionValue['price_type']) || isset($optionValue['tiers']) || isset($optionValue['specials'])) {
                                 $storeOptions[$optionId]['values'][$valueId]['price'] = $productOptions[$optionId]['values'][$valueId]['price'];
                                 $storeOptions[$optionId]['values'][$valueId]['price_type'] = $productOptions[$optionId]['values'][$valueId]['price_type'];
                                 if (isset($productOptions[$optionId]['values'][$valueId]['specials'])) {
                                     $storeOptions[$optionId]['values'][$valueId]['specials'] = $productOptions[$optionId]['values'][$valueId]['specials'];
                                 }
                                 if (isset($productOptions[$optionId]['values'][$valueId]['tiers'])) {
                                     $storeOptions[$optionId]['values'][$valueId]['tiers'] = $productOptions[$optionId]['values'][$valueId]['tiers'];
                                 }
                             }
                         }
                     }
                 }
                 // save store options
                 $groupStore = Mage::getSingleton('customoptions/group_store')->loadByGroupAndStore($id, $storeId);
                 $prevStoreOptionsData = $groupStore->getData();
                 $groupStore->setGroupId($id)->setStoreId($storeId)->setHashOptions(serialize($this->_prepareOptions($storeOptions, $id)))->save();
                 //                    print_r($optionsPrev);
                 //                    print_r($defaultOptions);
                 //                    print_r($storeOptions);
                 //                    exit;
             } else {
                 // default store
                 $defaultOptions = $productOptions;
                 // foreach all no default store and mark is_delete flag or no option
                 $groupStoreCollection = Mage::getResourceModel('customoptions/group_store_collection')->addFieldToFilter('group_id', $id);
                 if (count($groupStoreCollection) > 0) {
                     foreach ($groupStoreCollection as $groupStore) {
                         $groupStoreOptions = $groupStore->getHashOptions();
                         if ($groupStoreOptions) {
                             $groupStoreOptions = unserialize($groupStoreOptions);
                         }
                         $changeFlag = false;
                         foreach ($groupStoreOptions as $optionId => $option) {
                             if (!isset($defaultOptions[$optionId]) || isset($defaultOptions[$optionId]['is_delete']) && $defaultOptions[$optionId]['is_delete']) {
                                 unset($groupStoreOptions[$optionId]);
                                 $changeFlag = true;
                             } else {
                                 if (isset($option['values']) && count($option['values']) > 0) {
                                     foreach ($option['values'] as $valueId => $value) {
                                         if (!isset($defaultOptions[$optionId]['values'][$valueId]) || isset($defaultOptions[$optionId]['values'][$valueId]['is_delete']) && $defaultOptions[$optionId]['values'][$valueId]['is_delete']) {
                                             unset($groupStoreOptions[$optionId]['values'][$valueId]);
                                             if (count($groupStoreOptions[$optionId]['values']) == 0) {
                                                 unset($groupStoreOptions[$optionId]['values']);
                                             }
                                             $changeFlag = true;
                                         } else {
                                             if (isset($value['specials']) && count($value['specials']) > 0) {
                                                 if (!isset($defaultOptions[$optionId]['values'][$valueId]['specials'])) {
                                                     unset($groupStoreOptions[$optionId]['values'][$valueId]['specials']);
                                                     $changeFlag = true;
                                                 } else {
                                                     foreach ($value['specials'] as $specialId => $sValue) {
                                                         if (!isset($defaultOptions[$optionId]['values'][$valueId]['specials'][$specialId])) {
                                                             unset($groupStoreOptions[$optionId]['values'][$valueId]['specials'][$specialId]);
                                                             $changeFlag = true;
                                                         }
                                                     }
                                                 }
                                             }
                                             if (isset($value['tiers']) && count($value['tiers']) > 0) {
                                                 if (!isset($defaultOptions[$optionId]['values'][$valueId]['tiers'])) {
                                                     unset($groupStoreOptions[$optionId]['values'][$valueId]['tiers']);
                                                     $changeFlag = true;
                                                 } else {
                                                     foreach ($value['tiers'] as $tierId => $tValue) {
                                                         if (!isset($defaultOptions[$optionId]['values'][$valueId]['tiers'][$tierId])) {
                                                             unset($groupStoreOptions[$optionId]['values'][$valueId]['tiers'][$tierId]);
                                                             $changeFlag = true;
                                                         }
                                                     }
                                                 }
                                             }
                                         }
                                     }
                                 }
                             }
                         }
                         if ($changeFlag) {
                             if (count($groupStoreOptions) > 0) {
                                 $groupStore->setHashOptions(serialize($groupStoreOptions))->save();
                             } else {
                                 $groupStore->delete();
                             }
                         }
                     }
                 }
             }
             //print_r($defaultOptions); exit;
             // save default options
             if (!isset($data['general']['absolute_price'])) {
                 $data['general']['absolute_price'] = 0;
             }
             if (!isset($data['general']['absolute_weight'])) {
                 $data['general']['absolute_weight'] = 0;
             }
             if (!isset($data['general']['sku_policy'])) {
                 $data['general']['sku_policy'] = 0;
             }
             if (!isset($data['general']['update_inventory'])) {
                 $data['general']['update_inventory'] = 0;
             }
             if (!isset($data['general']['only_update'])) {
                 $data['general']['only_update'] = 0;
             }
             $data['general']['hash_options'] = serialize($this->_prepareOptions($defaultOptions, $id));
             $approximateOptionCount = ceil((strlen($data['general']['hash_options']) + 1) / 500);
             // 500 byte = ~1 option
             $group->setData($data['general']);
             $group->setId($id);
             $group->save();
             Mage::getSingleton('adminhtml/session')->setCustomoptionsData(null);
             if ($this->getRequest()->getParam('back')) {
                 $redirectParams['group_id'] = $group->getId();
                 $redirectData = array('*/*/edit', $redirectParams);
             } else {
                 $redirectData = array('*/*/', array());
             }
             // apply options to products
             if ($productOptions && isset($productIds) && is_array($productIds)) {
                 if (count($productIds) > 0) {
                     if (count($productIds) * $approximateOptionCount < 250) {
                         // apply default and store
                         $productOptionModel->saveProductOptions($defaultOptions, $optionsPrev, $productIds, $group, $prevGroupIsActive, 'apo', $prevStoreOptionsData);
                         // make reindex
                         $productIndexerPrice = Mage::getResourceModel('catalog/product_indexer_price');
                         if (method_exists($productIndexerPrice, 'reindexProductIds')) {
                             $productIndexerPrice->reindexProductIds($productIds);
                         } else {
                             Mage::getModel('catalog/product_indexer_price')->reindexAll();
                         }
                     } else {
                         // start multi-step apply
                         $limit = ceil(250 / $approximateOptionCount);
                         Mage::getSingleton('adminhtml/session')->setCustomoptionsApplyData(array($defaultOptions, $optionsPrev, $productIds, $group, $prevGroupIsActive, $prevStoreOptionsData, $redirectData, $limit));
                         return $this->_redirect('*/*/apply');
                     }
                 } else {
                     if ($productOptionModel->removeProductOptionsAndRelationByGroup($group->getId())) {
                         Mage::getModel('catalog/product_indexer_price')->reindexAll();
                         // make reindex
                     }
                 }
             }
             Mage::getSingleton('adminhtml/session')->addSuccess($this->__('Options were successfully saved'));
             return $this->_redirect($redirectData[0], $redirectData[1]);
         } catch (Exception $e) {
             if ($e->getMessage()) {
                 Mage::getSingleton('adminhtml/session')->addError($e->getMessage());
             }
             Mage::getSingleton('adminhtml/session')->setData('customoptions_data', $data);
             $this->_redirect('*/*/edit', $redirectParams);
             return;
         }
     }
     Mage::getSingleton('adminhtml/session')->addError($this->__('Unable to find Options to save'));
     $this->_redirect('*/*/');
 }
Example #27
0
 /**
  * 
  * @return int|bool
  */
 public function saveClient()
 {
     $dbAdapter = Zend_Db_Table_Abstract::getDefaultAdapter();
     $dbAdapter->beginTransaction();
     try {
         $dbStudentClassPerData = App_Model_DbTable_Factory::get('FEFEPStudentClass_has_PerData');
         $date = new Zend_Date();
         foreach ($this->_data['status'] as $client => $status) {
             $dataUpdate = array('status' => $status);
             $where = array('fk_id_perdata = ?' => $client, 'fk_id_fefpstudentclass = ?' => $this->_data['fk_id_fefpstudentclass']);
             if (!empty($this->_data['date_drop'][$client])) {
                 $dataUpdate['date_drop_out'] = $date->setDate($this->_data['date_drop'][$client], 'dd/MM/yyyy')->toString('yyyy-MM-dd');
             } else {
                 $dataUpdate['date_drop_out'] = null;
             }
             $dbStudentClassPerData->update($dataUpdate, $where);
         }
         // Save the auditing
         $history = 'ATUALIZA ALUNO SIRA: BA KLASE %s';
         $history = sprintf($history, $this->_data['fk_id_fefpstudentclass']);
         $this->_sysAudit($history, StudentClass_Form_RegisterClient::ID);
         $dbAdapter->commit();
         return $this->_data['fk_id_fefpstudentclass'];
     } catch (Exception $e) {
         $dbAdapter->rollBack();
         $this->_message->addMessage($this->_config->messages->error, App_Message::ERROR);
         return false;
     }
 }
 /**
  * 
  * @param type $event
  * @return type
  */
 protected function _treatEvent($event)
 {
     $date = new Zend_Date();
     $title = (empty($event->external_code) ? '' : $event->external_code . ' - ') . $event->scholarity;
     $title .= ' - Partisipants: ' . $event->students_course;
     $row = array('id' => $event->id_planning_course, 'title' => $title, 'start' => (int) $date->setDate($event->date_start, 'yyyy-MM-dd')->get(Zend_Date::TIMESTAMP), 'end' => (int) $date->setDate($event->date_finish, 'yyyy-MM-dd')->get(Zend_Date::TIMESTAMP), 'scholarity' => $event->id_perscholarity);
     return $row;
 }
Example #29
0
 protected function mapDirectiveSalePriceEffectiveDate($params = array())
 {
     /** @var $product Mage_Catalog_Model_Product */
     $product = $this->getProduct();
     $assocMapArr = $this->getAssocMaps();
     $cDate = Mage::app()->getLocale()->date(null, null, Mage::app()->getLocale()->getDefaultLocale());
     $timezone = Mage::app()->getStore($this->getStoreId())->getConfig(Mage_Core_Model_Locale::XML_PATH_DEFAULT_TIMEZONE);
     $cell = "";
     if (!$this->hasSpecialPrice($product, $this->getSpecialPrice($product))) {
         return $cell;
     }
     $has_default_qty = $this->_hasDefaultQty($assocMapArr);
     $display_min = $this->getConfigVar('grouped_price_display_mode', 'columns');
     if ($has_default_qty) {
         if ($display_min == RocketWeb_GoogleBaseFeedGenerator_Model_Source_Pricegroupedmode::PRICE_SUM_DEFAULT_QTY) {
             $product_from_date = $product_to_date = null;
             $from_time = -1;
             $to_time = PHP_INT_MAX;
             foreach ($assocMapArr as $assocMap) {
                 $associatedProduct = $assocMap->getProduct();
                 if ($associatedProduct->getQty() > 0) {
                     if ($assocMap->hasSpecialPrice($associatedProduct, $assocMap->getSpecialPrice($associatedProduct))) {
                         if ($assocMap->hasPriceByCatalogRules($associatedProduct)) {
                             // Current date to cdate + ttl
                             $fromDate = clone $cDate;
                             $fromDate->setTime('00:00:00', 'HH:mm:ss');
                             $toDate = new Zend_Date(null, null, Mage::app()->getLocale()->getDefaultLocale());
                             if ($timezone) {
                                 $toDate->setTimezone($timezone);
                             }
                             $toDate->setDate($cDate->toString('yyyy-MM-dd'), 'yyyy-MM-dd');
                             $toDate->setTime('23:59:59', 'HH:mm:ss');
                             $toDate->add((int) $this->getConfigVar('ttl', 'columns'), Zend_Date::DAY);
                             $compare_from_date = $fromDate->toString('yyyy-MM-dd 00:00:00');
                             $compare_to_date = $toDate->toString('yyyy-MM-dd 23:59:59');
                         } else {
                             $compare_from_date = $associatedProduct->getSpecialFromDate();
                             $compare_to_date = $associatedProduct->getSpecialToDate();
                         }
                         if ($from_time < $this->dateToTime($compare_from_date)) {
                             $product_from_date = $compare_from_date;
                             $from_time = $this->dateToTime($product_from_date);
                         }
                         if (!is_empty_date($compare_to_date) && $to_time > $this->dateToTime($compare_to_date)) {
                             $product_to_date = $compare_to_date;
                             $to_time = $this->dateToTime($product_to_date);
                         }
                     }
                 }
             }
         } else {
             // RocketWeb_GoogleBaseFeedGenerator_Model_Source_Pricegroupedmode::PRICE_START_AT
             $minAssocMap = $this->findMinimalPriceProduct($assocMapArr);
             if ($minAssocMap === false) {
                 return $cell;
             }
             $associatedProduct = $minAssocMap->getProduct();
             if ($minAssocMap->hasPriceByCatalogRules($associatedProduct)) {
                 // Current date to cdate + ttl
                 $fromDate = clone $cDate;
                 $fromDate->setTime('00:00:00', 'HH:mm:ss');
                 $toDate = new Zend_Date(null, null, Mage::app()->getLocale()->getDefaultLocale());
                 if ($timezone) {
                     $toDate->setTimezone($timezone);
                 }
                 $toDate->setDate($cDate->toString('yyyy-MM-dd'), 'yyyy-MM-dd');
                 $toDate->setTime('23:59:59', 'HH:mm:ss');
                 $toDate->add((int) $this->getConfigVar('ttl', 'columns'), Zend_Date::DAY);
                 $compare_from_date = $fromDate->toString('yyyy-MM-dd 00:00:00');
                 $compare_to_date = $toDate->toString('yyyy-MM-dd 23:59:59');
             } else {
                 $compare_from_date = $associatedProduct->getSpecialFromDate();
                 $compare_to_date = $associatedProduct->getSpecialToDate();
             }
             $product_from_date = $compare_from_date;
             $product_to_date = $compare_to_date;
         }
     } else {
         // RocketWeb_GoogleBaseFeedGenerator_Model_Source_Pricegroupedmode::PRICE_START_AT
         $minAssocMap = $this->findMinimalPriceProduct($assocMapArr);
         if ($minAssocMap === false) {
             return $cell;
         }
         $associatedProduct = $minAssocMap->getProduct();
         $product_from_date = $associatedProduct->getSpecialFromDate();
         $product_to_date = $associatedProduct->getSpecialToDate();
     }
     $fromDate = new Zend_Date(null, null, Mage::app()->getLocale()->getDefaultLocale());
     if ($timezone) {
         $fromDate->setTimezone($timezone);
     }
     if ($product_from_date) {
         $fromDate->setDate(substr($product_from_date, 0, 10), 'yyyy-MM-dd');
         $fromDate->setTime(substr($product_from_date, 11, 8), 'HH:mm:ss');
     }
     $toDate = new Zend_Date(null, null, Mage::app()->getLocale()->getDefaultLocale());
     if (!is_empty_date($product_to_date)) {
         if ($timezone) {
             $toDate->setTimezone($timezone);
         }
         $toDate->setDate(substr($product_to_date, 0, 10), 'yyyy-MM-dd');
         $toDate->setTime('23:59:59', 'HH:mm:ss');
     } else {
         if ($timezone) {
             $toDate->setTimezone($timezone);
         }
         $toDate->setDate($cDate->toString('yyyy-MM-dd'), 'yyyy-MM-dd');
         $toDate->setTime('23:59:59', 'HH:mm:ss');
         $toDate->add((int) $this->getConfigVar('ttl', 'columns'), Zend_Date::DAY);
     }
     $cell = $fromDate->toString(Zend_Date::ISO_8601) . "/" . $toDate->toString(Zend_Date::ISO_8601);
     return $cell;
 }
Example #30
0
 /**
  * Returns ready-to-use calendar field HTML
  * @return string
  */
 public function getCalendarHtml()
 {
     $_editableOptions = $this->getProduct()->getPreconfiguredValues();
     if (!isset($_editableOptions['aw_sarp_subscription_start'])) {
         $zDate = new Zend_Date($this->getProductBlock()->formatDate($this->getDefaultPeriod()->getNearestAvailableDay(), Mage_Core_Model_Locale::FORMAT_TYPE_SHORT), null, Mage::app()->getLocale()->getLocaleCode());
         $date = $zDate->toString(preg_replace(array('/M+/', '/d+/'), array('MM', 'dd'), Mage::app()->getLocale()->getDateFormat(Mage_Core_Model_Locale::FORMAT_TYPE_SHORT)));
     } else {
         $date = $_editableOptions['aw_sarp_subscription_start'];
         $zDate = new Zend_Date();
         $zDate->setDate($date);
         $today = new Zend_Date();
         $period = Mage::getModel('sarp/period')->load($_editableOptions['aw_sarp_subscription_type']);
         if ($zDate->compare($today, Zend_Date::DATE_SHORT) < 0 || !$period->isAllowedDate($zDate, $this->getProduct())) {
             $zDate = $period->getNearestAvailableDay();
         }
         $date = $zDate->toString(preg_replace(array('/M+/', '/d+/'), array('MM', 'dd'), Mage::app()->getLocale()->getDateFormat(Mage_Core_Model_Locale::FORMAT_TYPE_SHORT)));
     }
     $calendar = $this->getProductBlock()->getLayout()->createBlock('sarp/html_date')->setId(self::DATE_FIELD_NAME)->setName(self::DATE_FIELD_NAME)->setPeriod($this->getDefaultPeriod())->setClass('product-custom-option datetime-picker input-text')->setImage(Mage::getDesign()->getSkinUrl('aw_sarp/images/grid-cal.gif'))->setValue($date)->setFormat(Mage::app()->getLocale()->getDateStrFormat(Mage_Core_Model_Locale::FORMAT_TYPE_SHORT));
     return $calendar->getHtml();
 }