<?php

/**
 * 插件:zencart订单批量导出插件
 * 版本:v1.5
 * 作者:www.ezencart.com
 * QQ:40309022
 */
 if (!defined('IS_ADMIN_FLAG')) {
    die('Illegal Access');
}

//多维数组排序
function exp_array_sort($arr,$keys,$type='asc'){
	$keysvalue = $new_array = array();
	foreach ($arr as $k=>$v){
		$keysvalue[$k] = $v[$keys];
	}
	if($type == 'asc'){
		asort($keysvalue);
	}else{
		arsort($keysvalue);
	}
	reset($keysvalue);
	foreach ($keysvalue as $k=>$v){
		$new_array[$k] = $arr[$k];
	}
	return $new_array;
}

//客户信息
function exp_get_customer_info($customers_id,$order_id){
    global $db;
	$result[]='老顾客';
	$sql="SELECT os.orders_status_name FROM ".TABLE_ORDERS." o  LEFT JOIN  ".TABLE_ORDERS_STATUS." os ON o.orders_status=os.orders_status_id WHERE o.orders_id !=".$order_id." AND o.customers_id=".$customers_id." AND os.language_id=".(int)$_SESSION['languages_id'].";";
	$customerinfo = $db->Execute($sql);
	if($customerinfo->RecordCount()==0){
		return null;
	}else{
		while(!$customerinfo->EOF){
		$customer_result[]=$customerinfo->fields['orders_status_name'];
		$customerinfo->MoveNext();
		}
		$pursh_num=array_count_values($customer_result);
		foreach ($pursh_num as $key => $value){
				$result[]= $key.': '.$value.'次';
		}
		return implode("\n",$result);
	}
}

//获取顾客留言
function exp_get_comments($order_id){
global $db;
$sql="SELECT comments FROM ". TABLE_ORDERS_STATUS_HISTORY ." WHERE `orders_id`=".$order_id." ORDER BY orders_status_history_id ASC";
$ordercoment = $db->Execute($sql);
return iconv(CHARSET, "utf-8",$ordercoment->fields['comments']);
}

//交易金额明细
function exp_get_order_amount_detail($order){
	$result='';
	foreach($order->totals as $vo){
		$result .=$vo['title'].$vo['text']."\n";
	}
	return iconv(CHARSET, "utf-8",$result);
}

//交易号
function exp_get_transaction_number($order_id,$payment_module_code){
	global $db;
	if($payment_module_code=='rppay'){	//日付交易号
		$rp=$db->Execute("SELECT rp_transactionid FROM ".TABLE_ORDERS." WHERE order_id=".$order_id); //日付交易号
		return $rp->fields['rp_transactionid'];
	}
	$paypal=$db->Execute("SELECT txn_id FROM ".TABLE_PAYPAL." WHERE order_id=".$order_id); //paypal交易号
	if(!empty($paypal->fields['txn_id'])){
		return $paypal->fields['txn_id'];
	}

	return null;
}

//总件数
 function exp_get_order_total_qty($order){
 	$qty=0;
 	foreach($order->products as $vo){
		$qty =$qty+$vo['qty'];
	}

	return $qty;
 }

 //属性
 function exp_get_order_products_attributes($order,$m){
 	$attr='';
 	if(!empty($order->products[$m]['attributes'])){
	 	foreach ($order->products[$m]['attributes'] as $value) {
	 		$attr .=$value['option'].' - '.$value['value']."\n";
	 	}
	 }
 	return $attr;
 }

 //获取产品分类信息
function exp_get_full_categories($cID){
   global $db;
   static $parent_cache = array();
   $cats = array();
   $cats[] = $cID;
   $parent = $db->Execute("SELECT parent_id, categories_id
                           FROM " . TABLE_CATEGORIES . "
                           WHERE categories_id=" . (int)$cID);
   while(!$parent->EOF && $parent->fields['parent_id'] != 0) {
     $parent_cache[(int)$parent->fields['categories_id']] = (int)$parent->fields['parent_id'];
     $cats[] = $parent->fields['parent_id'];
     if(isset($parent_cache[(int)$parent->fields['parent_id']])) {
       $parent->fields['parent_id'] = $parent_cache[(int)$parent->fields['parent_id']];
     } else {
       $parent = $db->Execute("SELECT parent_id, categories_id
                               FROM " . TABLE_CATEGORIES . "
                               WHERE categories_id=" . (int)$parent->fields['parent_id']);
     }
   }
   $cats = array_reverse($cats);
   $result['cpath']=implode('_',$cats);
   foreach($cats as $cid){
		$cname[]=zen_get_category_name($cid, $_SESSION['languages_id']);
   }
   $result['cname']=iconv(CHARSET, "utf-8",implode(', ',$cname));
   return $result;
 }

 //交易号
function exp_get_prodcuts_info($products_id){
	global $db;
	$p=$db->Execute("SELECT p.products_image,pd.products_description,m.manufacturers_name,p.master_categories_id FROM ".TABLE_PRODUCTS." p
					LEFT JOIN ".TABLE_PRODUCTS_DESCRIPTION." pd ON p.products_id=pd.products_id
					LEFT JOIN ".TABLE_MANUFACTURERS." m ON m.manufacturers_id=p.manufacturers_id
	 				WHERE
	 				pd.language_id=".(int)$_SESSION['languages_id']."
	 				AND p.products_id=".(int)$products_id);
	$products_description=str_replace('<br />', "\n", $p->fields['products_description']);
	$products_description=preg_replace('/<\/(.*)>/iUs', "\n", $products_description);
	$products_description=preg_replace('/<(.*)>/iUs', "", $products_description);

	return array(
			'products_image'=>'../'. DIR_WS_IMAGES.$p->fields['products_image'],
			'master_categories_id'=>$p->fields['master_categories_id'],
			'products_description'=>$products_description,
			'manufacturers_name'=>$p->fields['manufacturers_name'],
		);
}


function exp_create_thumbnail($products_images){
	if(!is_file($products_images)) return false;
	require_once(DIR_WS_CLASSES . 'imagecrop.php');
	$path=DIR_WS_IMAGES.'order/'.md5($products_images).'.jpg';
	if(is_file($path)) return $path;
	$ic=new ImageCrop($products_images,$path);
	$ic->Crop(IMAGES_EXPORT_WIDTH,IMAGES_EXPORT_HEIGHT,3);
	$ic->SaveImage();
	$ic->SaveAlpha();
	$ic->destory();
	return $path;
}

if (!zen_page_key_exists('ordersexcelexport')) {
		 zen_register_admin_page('ordersexcelexport', 'BOX_TOOLS_PRODUCT_LINKS_EXPORT',
					 'FILENAME_ORDERS_EXCEL_EXPORT','' , 'tools', 'Y', 200);
 }?>