private function _getPurchaseSeries($productId, $from, $to, $type = null)
{
$sql = 'select unitPrice, created from `purchaseorderitem` where active = 1 AND productId = :pid AND created >=:from and created <= :to order by created asc';
$result = Dao::getResultsNative($sql, array('pid' => trim($productId), 'from' => trim($from), 'to' => trim($to)));
$return = array();
foreach ($result as $row) {
$created = new UDate(trim($row['created']));
$return[] = array($created->format('U') * 1000, (double) trim($row['unitPrice']) * 1.1);
}
return $return;
}
private function _getXnames()
{
$names = array();
$_12mthAgo = new UDate();
$_12mthAgo->modify('-12 month');
for ($i = 0; $i < 12; $i++) {
$from = new UDate(trim($_12mthAgo->format('Y-m-01 00:00:00')));
$to = new UDate(trim($_12mthAgo->modify('+1 month')->format('Y-m-01 00:00:00')));
$names[trim($from->format('M/Y'))] = array('from' => trim($from), 'to' => trim($to));
}
return $names;
}
private function _getXnames($from, $to, $step)
{
$names = array();
$dateFrom = new UDate(trim($from));
$dateTo = new UDate(trim($to));
do {
$from = new UDate(trim($dateFrom));
$to = new UDate(trim($dateFrom->modify($step)));
$names[trim($from->format('d/M/y'))] = array('from' => trim($from), 'to' => trim($to));
} while ($dateFrom->before($dateTo));
return $names;
}
protected static function _getAttachedFileName()
{
$now = new UDate();
$now->setTimeZone('Australia/Melbourne');
return 'open_invoice_' . $now->format('Y_m_d_H_i_s') . '.csv';
}
/**
* Getting the items
*
* @param unknown $sender
* @param unknown $param
* @throws Exception
*
*/
public function getItems($sender, $param)
{
$results = $errors = array();
try {
$class = trim($this->_focusEntity);
$pageNo = 1;
$pageSize = DaoQuery::DEFAUTL_PAGE_SIZE;
if (isset($param->CallbackParameter->pagination)) {
$pageNo = $param->CallbackParameter->pagination->pageNo;
$pageSize = $param->CallbackParameter->pagination->pageSize;
}
$serachCriteria = isset($param->CallbackParameter->searchCriteria) ? json_decode(json_encode($param->CallbackParameter->searchCriteria), true) : array();
$where = array(1);
$params = array();
if (isset($serachCriteria['taskId']) && trim($taskId = $serachCriteria['taskId']) !== '') {
$where[] = 'id like :taskId';
$params['taskId'] = '%' . $taskId . '%';
}
if (isset($serachCriteria['ord.id']) && trim($orderIds = $serachCriteria['ord.id']) !== '' && count($orderIds = explode(',', $orderIds)) > 0) {
$params['entityName'] = 'Order';
$keys = array();
foreach ($orderIds as $index => $orderId) {
$keys[] = ":" . ($key = "entityId" . $index);
$params[$key] = $orderId;
}
$where[] = 'fromEntityName = :entityName and fromEntityId in (' . implode(', ', $keys) . ')';
}
if (isset($serachCriteria['techId']) && trim($techIds = $serachCriteria['techId']) !== '' && count($techIds = explode(',', $techIds)) > 0) {
$keys = array();
foreach ($techIds as $index => $techId) {
$keys[] = ":" . ($key = "techId" . $index);
$params[$key] = $techId;
}
$where[] = 'technicianId in (' . implode(', ', $keys) . ')';
}
if (isset($serachCriteria['customer.id']) && trim($customerIds = $serachCriteria['customer.id']) !== '' && count($customerIds = explode(',', $customerIds)) > 0) {
$keys = array();
foreach ($customerIds as $index => $customerId) {
$keys[] = ":" . ($key = "customerId" . $index);
$params[$key] = $customerId;
}
$where[] = 'customerId in (' . implode(', ', $keys) . ')';
}
if (isset($serachCriteria['statusId']) && count($statusIds = $serachCriteria['statusId']) > 0) {
$keys = array();
foreach ($statusIds as $index => $statusId) {
$keys[] = ":" . ($key = "statusId" . $index);
$params[$key] = $statusId;
}
$where[] = 'statusId in (' . implode(', ', $keys) . ')';
}
if (isset($serachCriteria['dueDate_from']) && ($dueDate_from = new UDate($serachCriteria['dueDate_from'])) !== false) {
$where[] = 'dueDate >= :dueDateFrom';
$params['dueDateFrom'] = $dueDate_from->format('Y-m-d') . ' 00:00:00';
}
if (isset($serachCriteria['dueDate_to']) && ($dueDate_to = new UDate($serachCriteria['dueDate_to'])) !== false) {
$where[] = 'dueDate <= :dueDateTo';
$params['dueDateTo'] = $dueDate_from->format('Y-m-d') . ' 23:59:59';
}
$stats = array();
$objects = $class::getAllByCriteria(implode(' AND ', $where), $params, false, $pageNo, $pageSize, array('dueDate' => 'asc'), $stats);
$results['pageStats'] = $stats;
$results['items'] = array();
foreach ($objects as $obj) {
$results['items'][] = $obj->getJson();
}
} catch (Exception $ex) {
$errors[] = $ex->getMessage();
}
$param->ResponseData = StringUtilsAbstract::getJson($results, $errors);
}
/**
* Getting the view preferences
*
* @return multitype:
*/
private function _getViewPreference()
{
$now = new UDate('now', SystemSettings::getSettings(SystemSettings::TYPE_SYSTEM_TIMEZONE));
return array('ord_item.eta.from' => $now->format('Y-m-d 00:00:00'), 'ord_item.eta.to' => $now->format('Y-m-d 23:59:59'));
}
protected function _debugIncompleteFormat($humanPattern, $time)
{
return \UDate::format('DD/MM/YYYY', \UDate::getTimestampFromFormat($humanPattern, $time));
}
/**
* Getting the smart parth
*
* @param string $assetId The asset id
*
* @return string
*/
private static function _getSmartPath($assetId)
{
$now = new UDate();
$year = $now->format('Y');
if (!is_dir($yearDir = trim(self::getRootPath() . DIRECTORY_SEPARATOR . $year))) {
mkdir($yearDir);
chmod($yearDir, 0777);
}
$month = $now->format('m');
if (!is_dir($monthDir = trim($yearDir . DIRECTORY_SEPARATOR . $month))) {
mkdir($monthDir);
chmod($monthDir, 0777);
}
return $monthDir . DIRECTORY_SEPARATOR . $assetId;
}
protected static function _getAttachedFileName()
{
$now = new UDate();
$now->setTimeZone('Australia/Melbourne');
return 'accounting_code_list_' . $now->format('Y_m_d_H_i_s') . '.csv';
}
protected static function _getAttachedFileName()
{
$now = new UDate();
$now->setTimeZone('Australia/Melbourne');
return 'product_magento_import_' . $now->format('Y_m_d_H_i_s') . '.csv';
}
