<?php
class Common_Export
{
    /**
     * @desc 执行SQL
     * @param string $sql
     * @return array
     * @throws Exception
     */
    public static function getDateBySql($sql = '')
    {
        $result = array('state' => 0, 'message' => '', 'data' => array());
        if (empty($sql)) {
            $result['message'] = 'SQL语句不能为空.';
            return $result;
        }

        try {
            $db = Table_User::getInstance()->getAdapter();
            $rows = $db->query($sql)->fetchAll();
            if (empty($rows)) {
                throw new Exception('没有找到记录.');
            }
            $result['state'] = 1;
            $result['data'] = $rows;
        } catch (Exception $e) {
            $result['message'] = $e->getMessage();
        }
        return $result;
    }

    /**
     * @desc 将数组转为CSV
     * @param array $data
     * @return string
     */
    public static function exportCsv($data = array())
    {
        $str = '';
        $keyRow = array();
        if (!empty($data) && is_array($data)) {
            foreach ($data as $key => $val) {
                foreach ($val as $k => $v) {
                    $k=str_replace(',','',$k);
                    $keyRow[$k] = '';
                    $str .= $k . ",";
                }
                break;
            }
            $str = trim($str, ',') . "\n";
//            $str=iconv("UTF-8", "GBK//IGNORE", $str);
            foreach ($data as $key => $val) {
                foreach ($keyRow as $k1 => $v1) {
                    $str .= str_replace(',', '，', (isset($val[$k1]) ? $val[$k1] : '')) . ",";
                }
                $str = trim($str, ',') . "\n";
            }
        }
//        return $str;
        //IGNORE
        return iconv("UTF-8", "GBK//IGNORE", $str);
    }

    public static function exportCsvForNotKey($data = array()){
        $str = '';
        if(!empty($data)){
            foreach ($data as $key => $val) {
                // $str.=$key;
                $item = array_map('Common_Export::isNumericHandle', $val);
                $str .= implode(',' , $item)."\r\n";
                // $str .= iconv("UTF-8", "GBK//IGNORE", $strOld);
                // $str .= implode(',' , $item)."\r\n";
            }   
        }
        return $str;
    }


    public static function isNumericHandle($item){
        $item = str_replace(',' , '，' , $item);
        $chars    = array( "\r\n" ,  "\n" ,  "\r" );
        $item = str_replace($chars , ' ' , $item);
        $item = iconv("UTF-8", "GBK//IGNORE", $item);
        return "\t{$item}";
    }

}