/** * Apply filter by card expiration date (extract valid cards only) * * @return CLS_Paypal_Model_Resource_Customerstored_Collection */ public function filterByExpirationDate() { $now = new Zend_Date(null); $dateArray = $now->toArray(); $this->getSelect()->where("\n (cc_exp_year > '{$dateArray['year']}') OR\n (cc_exp_year = '{$dateArray['year']}' AND cc_exp_month >= {$dateArray['month']})\n "); return $this; }
/** * Sets the internal value to ISO date format. * * @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 (empty($val)) { $this->dateField->setValue(null); $this->timeField->setValue(null); } else { // String setting is only possible from the database, so we don't allow anything but ISO format if (is_string($val) && Zend_Date::isDate($val, $this->getConfig('datavalueformat'), $this->locale)) { // split up in date and time string values. $valueObj = new Zend_Date($val, $this->getConfig('datavalueformat'), $this->locale); // set date either as array, or as string if ($this->dateField->getConfig('dmyfields')) { $this->dateField->setValue($valueObj->toArray()); } else { $this->dateField->setValue($valueObj->get($this->dateField->getConfig('dateformat'))); } // set time $this->timeField->setValue($valueObj->get($this->timeField->getConfig('timeformat'))); } elseif (is_array($val) && array_key_exists('date', $val) && array_key_exists('time', $val)) { $this->dateField->setValue($val['date']); $this->timeField->setValue($val['time']); } else { $this->dateField->setValue($val); $this->timeField->setValue($val); } } }
/** * Converte um timestamp para array * * @param int $timeStamp * @return ARRAY */ public function unixToArray($timeStamp) { if (!$timeStamp) return null; $date = new Zend_Date(); $date->set($timeStamp, Zend_Date::TIMESTAMP); return $date->toArray(); }
public function indexAction() { // action body $service = new Application_Model_DbTable_Service(); if ($this->getRequest()->isPost('select_date')) { $year = $this->getRequest()->getPost('select_year'); $month = $this->getRequest()->getPost('select_month'); $_SESSION['year'] = $year; $_SESSION['month'] = $month; } else { $currend_date = new Zend_Date(); $ss = $currend_date->toArray(); $year = $ss['year']; $month = (int) $ss['month']; if ($month < 10) { $month = "0{$month}"; } $_SESSION['year'] = $year; $_SESSION['month'] = $month; } $date = "{$year}-{$month}"; //обработка параметров поиска if ($this->getRequest()->isPost('search_catalog')) { $search = $this->getRequest()->getPost('search_catalog'); } elseif ($this->getRequest()->getParam('search_catalog')) { $search = $this->getRequest()->getParam('search_catalog'); } //c поиском if ($search != '') { $this->view->service = $service->searchService($search); $dd = $service->getcountsearchService($search); $this->view->countshow = $dd[0]['count']; //без поиска } else { $this->view->service = $service->showService($date); $dd = $service->getcountService($date); $this->view->countshow = $dd[0]['count']; } $dd = $service->getcountService($date); $this->view->count = $dd[0]['count']; $dd = $service->getcountService(); $this->view->allcount = $dd[0]['count']; $this->view->search = $search; }
/** * 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)); } } }
public function testToArray() { $date = new Zend_Date('2006-01-02 23:58:59', Zend_Date::ISO_8601, 'en_US'); $return = $date->toArray(); $orig = array('day' => 02, 'month' => 01, 'year' => 2006, 'hour' => 23, 'minute' => 58, 'second' => 59, 'timezone' => 'MVT', 'timestamp' => 1136228339, 'weekday' => 1, 'dayofyear' => 1, 'week' => '01', 'gmtsecs' => 18000); $this->assertEquals($orig, $return); }
public function saveAction() { if ($data = $this->getRequest()->getPost()) { $_mcenterItem = Mage::getModel('clmcenter/mcenter')->getCollection()->addFieldToFilter('url_key', $data['url_key'])->setPageSize(1)->getFirstItem(); /* $arr = array(); $arr = $mcenterCollection->getData(); if (isset($arr[0]) && $this->getRequest()->getParam('id') == $arr[0]['mcenter_id'] && $data['url_key'] == $arr[0]['url_key']) { $sameUrl = null; } else { $sameUrl = $mcenterCollection->getData(); } if ($sameUrl != null) {*/ if ($_mcenterItem->getId() && $this->getRequest()->getParam('id') == $_mcenterItem->getId() && $data['url_key'] == $_mcenterItem->getUrlKey() && count(array_diff($_mcenterItem->getStoreId(), $data['stores'])) == 0 && count(array_diff($data['stores'], $_mcenterItem->getStoreId())) == 0) { $sameUrl = false; } else { $sameUrl = false; $_mcenterItemCollection = Mage::getModel('clmcenter/mcenter')->getCollection()->addFieldToFilter('mcenter_id', array('neq' => $this->getRequest()->getParam('id')))->addFieldToFilter('url_key', $data['url_key']); foreach ($_mcenterItemCollection as $_mcenterItem) { if (count(array_intersect($_mcenterItem->getStoreId(), $data['stores'])) != 0 || in_array(0, $data['stores']) || in_array(0, $_mcenterItem->getStoreId())) { $sameUrl = true; } } } if ($sameUrl) { Mage::getSingleton('adminhtml/session')->addError(Mage::helper('clmcenter')->__('Статьи не найдено')); $this->_redirect('*/*/edit', array('id' => $this->getRequest()->getParam('id'))); } else { if (isset($data['is_delete'])) { $isDeleteFile = true; } else { $isDeleteFile = false; } if (isset($_FILES['document_save']['name']) && $_FILES['document_save']['name'] != '' && $_FILES['document_save']['size'] != 0) { try { $uploader = new Varien_File_Uploader('document_save'); $uploader->setAllowRenameFiles(false); // Set the file upload mode // false -> get the file directly in the specified folder // true -> get the file in folders like /media/a/b/ $uploader->setFilesDispersion(false); $path = Mage::getBaseDir('media') . DS . 'clmcenter' . DS; //saved the name in DB $prefix = time() . rand(); $fileName = $prefix . '.' . pathinfo($_FILES['document_save']['name'], PATHINFO_EXTENSION); $uploader->save($path, $fileName); $filepath = 'clmcenter' . DS . $fileName; $data['full_path_document'] = $path . $fileName; $data['document'] = $fileName; $data['document'] = str_replace('\\', '/', $data['document']); } catch (Exception $e) { Mage::getSingleton('adminhtml/session')->addError($e->getMessage()); $this->_redirect('*/*/edit', array('id' => $this->getRequest()->getParam('id'))); } } elseif ($isDeleteFile === true) { unlink($data['full_path_document']); $data['document'] = ''; } else { /// to insert a code for deleting image /// .... if (isset($data['document'])) { $data['document'] = $data['document']; } } if (isset($_FILES['image_short_content']['name']) && $_FILES['image_short_content']['name'] != '' && $_FILES['image_short_content']['size'] != 0) { try { $uploader = new Varien_File_Uploader('image_short_content'); $uploader->setAllowedExtensions(array('jpg', 'jpeg', 'gif', 'png')); $uploader->setAllowRenameFiles(false); // Set the file upload mode // false -> get the file directly in the specified folder // true -> get the file in folders like /media/a/b/ $uploader->setFilesDispersion(false); $path = Mage::getBaseDir('media') . DS . 'clmcenter' . DS; //saved the name in DB $prefix = time() . rand(); $fileName = $prefix . '.' . pathinfo($_FILES['image_short_content']['name'], PATHINFO_EXTENSION); $uploader->save($path, $fileName); $filepath = 'clmcenter' . DS . $fileName; /* if (!getimagesize($filepath)) { Mage::throwException($this->__('Disallowed file type.')); }*/ $data['image_short_content'] = $filepath; $data['image_short_content'] = str_replace('\\', '/', $data['image_short_content']); } catch (Exception $e) { Mage::getSingleton('adminhtml/session')->addError($e->getMessage()); $this->_redirect('*/*/edit', array('id' => $this->getRequest()->getParam('id'))); return; } } elseif (isset($data['image_short_content']['delete'])) { $path = Mage::getBaseDir('media') . DS; $result = unlink($path . $data['image_short_content']['value']); if ($data['short_height_resize'] && $data['short_width_resize']) { $resizePath = Mage::getBaseDir('media') . DS . 'clmcenter' . DS . $data['short_width_resize'] . 'x' . $data['short_height_resize'] . DS; } $result = unlink($resizePath . str_replace('clmcenter/', '', $data['image_short_content']['value'])); $data['image_short_content'] = ''; } else { if (isset($data['image_short_content']['value'])) { $data['image_short_content'] = $data['image_short_content']['value']; } } if (isset($_FILES['image_full_content']['name']) && $_FILES['image_full_content']['name'] != '' && $_FILES['image_full_content']['size'] != 0) { try { $uploader = new Varien_File_Uploader('image_full_content'); $uploader->setAllowedExtensions(array('jpg', 'jpeg', 'gif', 'png')); $uploader->setAllowRenameFiles(false); // Set the file upload mode // false -> get the file directly in the specified folder // true -> get the file in folders like /media/a/b/ $uploader->setFilesDispersion(false); $path = Mage::getBaseDir('media') . DS . 'clmcenter' . DS; //saved the name in DB $prefix = time() . rand(); $fileName = $prefix . '.' . pathinfo($_FILES['image_full_content']['name'], PATHINFO_EXTENSION); $uploader->save($path, $fileName); $filepath = 'clmcenter' . DS . $fileName; $data['image_full_content'] = $filepath; $data['image_full_content'] = str_replace('\\', '/', $data['image_full_content']); } catch (Exception $e) { Mage::getSingleton('adminhtml/session')->addError($e->getMessage()); $this->_redirect('*/*/edit', array('id' => $this->getRequest()->getParam('id'))); return; } } elseif (isset($data['image_full_content']['delete'])) { $path = Mage::getBaseDir('media') . DS; $result = unlink($path . $data['image_full_content']['value']); if ($data['full_height_resize'] && $data['full_width_resize']) { $resizePath = Mage::getBaseDir('media') . DS . 'clmcenter' . DS . $data['full_width_resize'] . 'x' . $data['full_height_resize'] . DS; } $result = unlink($resizePath . str_replace('clmcenter/', '', $data['image_full_content']['value'])); $data['image_full_content'] = ''; } else { if (isset($data['image_full_content']['value'])) { $data['image_full_content'] = $data['image_full_content']['value']; } } if (isset($data['use_full_img'])) { if (isset($data['image_full_content'])) { $data['image_short_content'] = $data['image_full_content']; } } $model = Mage::getModel('clmcenter/mcenter'); $hoursFrom = $this->getRequest()->getParam('publicate_from_hours'); $minutesFrom = $this->getRequest()->getParam('publicate_from_minutes'); $hoursTo = $this->getRequest()->getParam('publicate_to_hours'); $minutesTo = $this->getRequest()->getParam('publicate_to_minutes'); $data['publicate_from_hours'] = $hoursFrom; $data['publicate_from_minutes'] = $minutesFrom; $data['publicate_to_hours'] = $hoursTo; $data['publicate_to_minutes'] = $minutesTo; $data['link'] = $this->getRequest()->getParam('link'); $data['tags'] = $this->getRequest()->getParam('tags'); // prepare dates if ($this->getRequest()->getParam('mcenter_time') != '') { $dateFormatIso = Mage::app()->getLocale()->getDateTimeFormat(Mage_Core_Model_Locale::FORMAT_TYPE_SHORT); if (!Zend_Date::isDate($this->getRequest()->getParam('mcenter_time') . ' ' . date("H:i:s"), $dateFormatIso)) { throw new Exception($this->__('Mcenter date field is required')); } $date = new Zend_Date($this->getRequest()->getParam('mcenter_time') . ' ' . date("H:i:s"), $dateFormatIso); $dateInfo = $date->toArray(); $data['mcenter_time'] = preg_replace('/([0-9]{4})\\-(.*)/', $dateInfo['year'] . '-$2', $date->toString('YYYY-MM-dd HH:mm:ss')); } else { $data['mcenter_time'] = new Zend_Db_Expr('null'); } if ($this->getRequest()->getParam('publicate_from_time') != '') { if (!Zend_Date::isDate($this->getRequest()->getParam('publicate_from_time') . ' ' . $hoursFrom . ':' . $minutesFrom . ':00', $dateFormatIso)) { throw new Exception($this->__('Mcenter date field is required')); } $date = new Zend_Date($this->getRequest()->getParam('publicate_from_time') . ' ' . $hoursFrom . ':' . $minutesFrom . ':00', $dateFormatIso); $dateInfo = $date->toArray(); $data['publicate_from_time'] = preg_replace('/([0-9]{4})\\-(.*)/', $dateInfo['year'] . '-$2', $date->toString('YYYY-MM-dd HH:mm:ss')); } else { $data['publicate_from_time'] = new Zend_Db_Expr('null'); } if ($this->getRequest()->getParam('publicate_to_time') != '') { if (!Zend_Date::isDate($this->getRequest()->getParam('publicate_to_time') . ' ' . $hoursTo . ':' . $minutesTo . ':00', $dateFormatIso)) { throw new Exception($this->__('Mcenter date field is required')); } $date = new Zend_Date($this->getRequest()->getParam('publicate_to_time') . ' ' . $hoursTo . ':' . $minutesTo . ':00', $dateFormatIso); $dateInfo = $date->toArray(); $data['publicate_to_time'] = preg_replace('/([0-9]{4})\\-(.*)/', $dateInfo['year'] . '-$2', $date->toString('YYYY-MM-dd HH:mm:ss')); } else { $data['publicate_to_time'] = new Zend_Db_Expr('null'); } $model->setData($data)->setId($this->getRequest()->getParam('id')); try { if ($this->getRequest()->getParam('mcenter_time') == NULL) { $model->setMcenterTime(now()); $model->setCreatedTime(now()); } else { if (isset($arr[0]) && !($mcenterItemId = $arr[0]['mcenter_id'])) { $model->setCreatedTime(now()); } } $model->setUpdateTime(now()); if ($this->getRequest()->getParam('author') == NULL) { $model->setUpdateAuthor(NULL); /*$model->setAuthor(Mage::getSingleton('admin/session')->getUser()->getFirstname() . " " . Mage::getSingleton('admin/session')->getUser()->getLastname()) ->setUpdateAuthor(Mage::getSingleton('admin/session')->getUser()->getFirstname() . " " . Mage::getSingleton('admin/session')->getUser()->getLastname());*/ } else { $model->setUpdateAuthor(Mage::getSingleton('admin/session')->getUser()->getFirstname() . " " . Mage::getSingleton('admin/session')->getUser()->getLastname()); } $model->save(); Mage::getSingleton('adminhtml/session')->addSuccess(Mage::helper('clmcenter')->__('Сохранено успешно!')); Mage::getSingleton('adminhtml/session')->setFormData(false); if ($this->getRequest()->getParam('back')) { $this->_redirect('*/*/edit', array('id' => $model->getId())); return; } $this->_redirect('*/*/'); return; } catch (Exception $e) { Mage::getSingleton('adminhtml/session')->addError($e->getMessage()); Mage::getSingleton('adminhtml/session')->setFormData($data); $this->_redirect('*/*/edit', array('id' => $this->getRequest()->getParam('id'))); return; } Mage::getSingleton('adminhtml/session')->addError(Mage::helper('clmcenter')->__('Нет данных для сохранения')); $this->_redirect('*/*/'); } } }
/** * ZF-6457 */ public function testArrayVerification() { $date = new Zend_Date(); $array = $date->toArray(); $this->assertTrue($this->_validator->isValid($array), "array expected to be valid"); }
/** * Set date values from Zend_Date instance. * * @param Zend_Date $date Zend_Date instance to use. * @return void */ public function setZendDate(Zend_Date $date) { $datearray = $date->toArray(); $this->setYear($datearray['year']); $this->setMonth($datearray['month']); $this->setDay($datearray['day']); $this->setHour($datearray['hour']); $this->setMinute($datearray['minute']); $this->setSecond($datearray['second']); $this->setTimezone($datearray['timezone']); $this->setUnixTimestamp($date->getTimestamp()); }
/** * Checks if date is allowed * @param Zend_Date $Date * @return bool */ public function isAllowedDate(Zend_Date $Date, $Product = null) { if ($Product && !$Product->getAwSarpHasShipping()) { return true; } if (!$Product || $Product->getAwSarpHasShipping()) { $arr = $Date->toArray(); $weekday = $arr['weekday'] == 7 ? 0 : $arr['weekday']; return array_search($weekday, $this->getExcludedWeekdays()) === false; } else { return true; } }
public function toexcelmonthAction() { global $settings; // Подключаем класс для работы с excel require_once 'PHPExcel.php'; // Подключаем класс для вывода данных в формате excel require_once 'PHPExcel/Writer/Excel5.php'; // Создаем объект класса PHPExcel $xls = new PHPExcel(); // Устанавливаем индекс активного листа $xls->setActiveSheetIndex(0); // Получаем активный лист $sheet = $xls->getActiveSheet(); // Подписываем лист $sheet->setCellValue("A1", '№'); $sheet->setCellValue("B1", 'Дата'); $sheet->setCellValue("C1", 'Номер'); $sheet->setCellValue("D1", 'Жалоба'); $sheet->setCellValue("E1", 'Диагноз'); $sheet->setCellValue("F1", 'Работа'); $sheet->setCellValue("G1", 'Запчасти'); $sheet->setCellValue("H1", 'Коментарии'); //меняем цвет заголовка $sheet->getStyle('A1')->getFill()->setFillType(PHPExcel_Style_Fill::FILL_SOLID); $sheet->getStyle('A1')->getFill()->getStartColor()->setRGB('EEEEEE'); $sheet->getStyle('B1')->getFill()->setFillType(PHPExcel_Style_Fill::FILL_SOLID); $sheet->getStyle('B1')->getFill()->getStartColor()->setRGB('EEEEEE'); $sheet->getStyle('C1')->getFill()->setFillType(PHPExcel_Style_Fill::FILL_SOLID); $sheet->getStyle('C1')->getFill()->getStartColor()->setRGB('EEEEEE'); $sheet->getStyle('D1')->getFill()->setFillType(PHPExcel_Style_Fill::FILL_SOLID); $sheet->getStyle('D1')->getFill()->getStartColor()->setRGB('EEEEEE'); $sheet->getStyle('E1')->getFill()->setFillType(PHPExcel_Style_Fill::FILL_SOLID); $sheet->getStyle('E1')->getFill()->getStartColor()->setRGB('EEEEEE'); $sheet->getStyle('F1')->getFill()->setFillType(PHPExcel_Style_Fill::FILL_SOLID); $sheet->getStyle('F1')->getFill()->getStartColor()->setRGB('EEEEEE'); $sheet->getStyle('G1')->getFill()->setFillType(PHPExcel_Style_Fill::FILL_SOLID); $sheet->getStyle('G1')->getFill()->getStartColor()->setRGB('EEEEEE'); $sheet->getStyle('H1')->getFill()->setFillType(PHPExcel_Style_Fill::FILL_SOLID); $sheet->getStyle('H1')->getFill()->getStartColor()->setRGB('EEEEEE'); $sheet->getStyle('A')->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_LEFT); // автоматическая ширина ячейки $sheet->getColumnDimension('A')->setAutoSize(true); $sheet->getColumnDimension('B')->setAutoSize(true); $sheet->getColumnDimension('C')->setAutoSize(true); $sheet->getColumnDimension('D')->setAutoSize(true); $sheet->getColumnDimension('E')->setAutoSize(true); $sheet->getColumnDimension('F')->setAutoSize(true); $sheet->getColumnDimension('G')->setAutoSize(true); $sheet->getColumnDimension('H')->setAutoSize(true); // формат ячейки текстовый $sheet->getStyle('A')->getNumberFormat()->setFormatCode(PHPExcel_Style_NumberFormat::FORMAT_TEXT); $sheet->getStyle('B')->getNumberFormat()->setFormatCode(PHPExcel_Style_NumberFormat::FORMAT_TEXT); $sheet->getStyle('C')->getNumberFormat()->setFormatCode(PHPExcel_Style_NumberFormat::FORMAT_TEXT); $sheet->getStyle('D')->getNumberFormat()->setFormatCode(PHPExcel_Style_NumberFormat::FORMAT_TEXT); $sheet->getStyle('E')->getNumberFormat()->setFormatCode(PHPExcel_Style_NumberFormat::FORMAT_TEXT); $sheet->getStyle('F')->getNumberFormat()->setFormatCode(PHPExcel_Style_NumberFormat::FORMAT_TEXT); $sheet->getStyle('G')->getNumberFormat()->setFormatCode(PHPExcel_Style_NumberFormat::FORMAT_TEXT); $sheet->getStyle('H')->getNumberFormat()->setFormatCode(PHPExcel_Style_NumberFormat::FORMAT_TEXT); if (isset($_SESSION['year']) && isset($_SESSION['month'])) { $year = $_SESSION['year']; $month = $_SESSION['month']; } else { $currend_date = new Zend_Date(); $ss = $currend_date->toArray(); $year = $ss['year']; $month = (int) $ss['month']; if ($month < 10) { $month = "0{$month}"; } $_SESSION['year'] = $year; $_SESSION['month'] = $month; } $date = "{$year}-{$month}"; $repairs = new Application_Model_DbTable_Repairs(); $data = $repairs->statisticRepairs($date); $i = 2; $sheet->setTitle("Repairs {$date}"); foreach ($data as $rows) { $number = $i - 1; $sheet->setCellValue("A{$i}", "{$number}"); $sheet->setCellValue("B{$i}", "{$rows['date']}"); $sheet->setCellValue("C{$i}", "{$rows['number']}"); $sheet->setCellValue("D{$i}", "{$rows['claim']}"); $sheet->setCellValue("E{$i}", "{$rows['diagnos']}"); $sheet->setCellValue("F{$i}", "{$rows['work']}"); $sheet->setCellValue("G{$i}", "{$rows['spares']}"); $sheet->setCellValue("H{$i}", "{$rows['comments']}"); $i++; } // Выводим содержимое файла $objWriter = new PHPExcel_Writer_Excel5($xls); $objWriter->save('repairs_mounth.xls'); // открываем файл в бинарном режиме header("Location: http://{$settings['excel']['site']}/repairs_mounth.xls"); }