$objPHPExcel->getProperties()->setCreator("Maarten Balliauw")->setLastModifiedBy("Maarten Balliauw")->setTitle("Office 2007 XLSX Test Document")->setSubject("Office 2007 XLSX Test Document")->setDescription("Test document for Office 2007 XLSX, generated using PHP classes.")->setKeywords("office 2007 openxml php")->setCategory("Test result file");
$objPHPExcel->setActiveSheetIndex(0)->setCellValue('A1', 'SKU');
$objPHPExcel->setActiveSheetIndex(0)->setCellValue('B1', '到货数量');
$objPHPExcel->setActiveSheetIndex(0)->setCellValue('C1', '异常数量');
$objPHPExcel->setActiveSheetIndex(0)->setCellValue('D1', '采购');
$objPHPExcel->setActiveSheetIndex(0)->setCellValue('E1', '供应商');
$objPHPExcel->setActiveSheetIndex(0)->setCellValue('F1', '到货时间');
$row = 2;
$sql = "SELECT * from ph_sku_reach_record where status=0 ";
$sql = $dbConn->execute($sql);
$skuInfo = $dbConn->getResultArray($sql);
foreach ($skuInfo as $item) {
$sku = $item['sku'];
$totalAmount = $item['totalAmount'];
$amount = $item['amount'];
$purname = getNameById($item['purchaseId']);
$partner = $item['partnerName'];
$addtime = date("Y-m-d", $item['addtime']);
$objPHPExcel->setActiveSheetIndex(0)->setCellValue('A' . $row, $sku);
$objPHPExcel->setActiveSheetIndex(0)->setCellValue('B' . $row, $totalAmount);
$objPHPExcel->setActiveSheetIndex(0)->setCellValue('C' . $row, $amount);
$objPHPExcel->setActiveSheetIndex(0)->setCellValue('D' . $row, $purname);
$objPHPExcel->setActiveSheetIndex(0)->setCellValue('E' . $row, $partner);
$objPHPExcel->setActiveSheetIndex(0)->setCellValue('F' . $row, $addtime);
$row++;
}
$objPHPExcel->getActiveSheet(0)->getStyle('A1:N' . $row)->getAlignment()->setVertical(PHPExcel_Style_Alignment::VERTICAL_CENTER);
$objPHPExcel->setActiveSheetIndex(0)->getColumnDimension('A')->setWidth(15);
$objPHPExcel->setActiveSheetIndex(0)->getColumnDimension('B')->setWidth(25);
$objPHPExcel->setActiveSheetIndex(0)->getColumnDimension('C')->setWidth(15);
$objPHPExcel->setActiveSheetIndex(0)->getColumnDimension('D')->setWidth(15);
<?php
/**
* Created by PhpStorm.
* User: ray
* Date: 7/27/15
* Time: 6:56 PM
*/
require_once "../include.php";
$id = $_REQUEST['id'];
$arr_res = queryTemp($id);
$username = getNameById($id);
$gas_res = $arr_res[0];
// 沼气产量数组
$d_res = $arr_res[1];
// 日期数组
$gas_total = $arr_res[2];
// 沼气总量
$mid_res = $arr_res[3];
// 平均温度数组
$gas_avg = $gas_total / count($d_res);
?>
<!DOCTYPE HTML>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<title>Highcharts Example</title>
<script type="text/javascript" src="http://cdn.hcharts.cn/jquery/jquery-1.8.2.min.js"></script>
<style type="text/css">
${demo.css}
?>
<tr>
<td><?php
echo $vo['id'];
?>
</td>
<td><?php
echo $vo['no'];
?>
</td>
<td><?php
echo $vo['name'];
?>
</td>
<td><?php
echo getNameById("subject", $vo['subid']);
?>
</td>
<td><?php
echo $vo['fudaoyuan'];
?>
</td>
<td><?php
echo $vo['rxsj'];
?>
</td>
<td><?php
echo $vo['bysj'];
?>
</td>
<td class="text-center" ><?php
function getPluginFileById($fileId = 0)
{
return getNameById('name', 'qo_files', $fileId);
}
/**
* A handler of each state.
* @param int state code
*/
public function state($state)
{
eval(USER);
$cm = new ContestModel();
$contest = $cm->getCurrentContest();
$contest = $contest[0];
$qm = new QuizModel();
$this->assign('contestname', $contest['name']);
$this->assign('contest', $contest);
$team = DBModel::getTeamDetail(DBModel::getTeamByUser(session('userid')));
$states = DBModel::selectDB('cernet_statepage');
$this->assign('statepage', $states[$state - 1]['html']);
switch ($state) {
case 1:
// dump($qm);
$this->assign('total', $qm->getTotalOnce());
$this->assign('pass', $qm->getPass());
break;
case 2:
$conf = array();
$conf['user_id'] = session('userid');
$conf['statecode'] = 0;
$model = D('cernet_teammate');
$invitations = $model->where($conf)->select();
$list = array();
foreach ($invitations as $invitation) {
array_push($list, DBModel::getFullInvitation($invitation));
}
$this->assign('list', $list);
$this->assign('invitation', json_encode($invitations));
case 3:
// invitation
$conf = array();
$conf['user_id'] = session('userid');
$conf['statecode'] = 0;
$model = D('cernet_teammate');
$invitations = $model->where($conf)->select();
$teamsize = $cm->getTeamSize();
$list = array();
foreach ($invitations as $invitation) {
array_push($list, DBModel::getFullInvitation($invitation));
}
$this->assign('list', $list);
$this->assign('invitation', json_encode($invitations));
// inteam
$this->assign('inteam', DBModel::inteam(session('userid')) ? 1 : '');
// get the team
$this->assign('teamname', $team['team']['name']);
$this->assign('leadername', getNameById('cernet_user', $team['team']['leader']));
$this->assign('isleader', DBModel::isLeader(session('userid')));
$this->assign('teamsize', $teamsize);
$contest = $cm->getCurrentContest();
$contest = $contest[0];
$model = D('cernet_user');
$team_id = DBModel::getTeamByUser(session('userid'));
$map['cernet_teammate.statecode'] = array(array('neq', 1), array('exp', 'is NULL'), 'OR');
$map['cernet_teammate.team_id'] = array(array('neq', $team_id), array('exp', 'is NULL'), 'OR');
$map['cernet_user.statecode'] = array(array('gt', 1), array('lt', 4));
// $map['cernet_user.statecode'] = 3;
$userlist = $model->join('LEFT JOIN cernet_teammate ON cernet_user.id = cernet_teammate.user_id')->where($map)->field('cernet_teammate.statecode,id,name')->select();
$model = D('cernet_teammate');
unset($map['cernet_teammate.statecode']);
$map['cernet_teammate.team_id'] = $team_id;
$map['cernet_user.id'] = array('NEQ', session('userid'));
$candidate = $model->join('LEFT JOIN cernet_user ON cernet_user.id = cernet_teammate.user_id')->field('cernet_teammate.statecode,id,name')->where($map)->select();
// dump($map);
// dump($candidate);
// die();
$team = DBModel::getTeamDetail($team_id);
$this->assign('banner', $cm->getBanner());
$this->assign('team', $team);
$this->assign('userlist', json_encode($userlist));
$this->assign('candidate', json_encode($candidate));
$this->assign('teamsize', $cm->getTeamSize());
$this->assign('contest', $contest);
$this->assign("less", "buildteam" . ".less");
break;
case 4:
$this->assign('team', $team);
$this->assign('mates', $team['teammate']);
break;
case 5:
$team_id = DBModel::getTeamByUser(session('userid'));
$teamdetail = DBModel::getTeamDetail($team_id)['team'];
$post['post_time'] = $teamdetail['post_time'];
$post['post_company'] = $teamdetail['post_company'];
$post['post_id'] = $teamdetail['post_id'];
$post['post_status'] = $teamdetail['post_status'];
$this->assign('post', $post);
$this->assign('team', $team['team']);
break;
case 6:
break;
case 8:
$this->assign('prize', $team['team']['prize']);
break;
case 7:
$this->assign('team', $team);
$this->assign('mates', $team['teammate']);
break;
}
}
public static function getSecondTeamDetail($team_id)
{
$model = D('second_team');
$matemod = D('second_teammate');
$conf['second_team.id'] = $team_id;
$res = array();
$res['team'] = $model->where($conf)->find();
$res['teammate'] = $matemod->join("second_user ON second_teammate.user_id = second_user.id")->where(array('second_teammate.team_id' => $team_id))->select();
$res['teacher'] = $model->join('second_teacher ON second_teacher.id = second_team.teacher')->where($conf)->find() or -1;
$res['tutor'] = $model->join('cernet_tutor ON cernet_tutor.id = second_team.tutor_id')->where($conf)->find() or -1;
$res['report'] = $model->join('second_report ON second_team.report_id = second_report.id')->where($conf)->find() or -1;
// get name by id
$res['team']['universityname'] = getNameById('cernet_university', $res['team']['university']);
foreach ($res['teammate'] as $k => $v) {
$res['teammate'][$k]['universityname'] = getNameById('cernet_university', $v['university']);
$res['teammate'][$k]['majorname'] = getNameById('cernet_major', $v['major']);
$res['teammate'][$k]['cityname'] = getNameById('cernet_city', $v['city']);
$res['teammate'][$k]['degreename'] = getNameById('cernet_degree', $v['degree']);
$res['teammate'][$k]['isleader'] = DBModel::isLeader($v['id']);
}
// get leader
$cond = array();
$cond['id'] = $res['team']['leader'];
$res['leader'] = DBModel::getByFields('second_user', $cond);
$res['leader'] = $res['leader'][0];
return $res;
}
function exportOrder($data)
{
global $dbConn;
$num = 0;
$dataArr = array();
foreach ($data as $id) {
$sql = "SELECT a.addtime, a.recordnumber, a.purchaseuser_id, b.sku, b.price, b.count, b.parid, b.stockqty, b.sendqty FROM ph_ow_order as a ";
$sql .= " JOIN ph_ow_order_detail as b ON a.id = b.po_id WHERE a.id = '{$id}' AND a.is_delete = 0 AND b.is_delete = 0 ";
$query = $dbConn->query($sql);
$datalist = array();
if ($query) {
$rtnData = $dbConn->fetch_array_all($query);
if (!empty($rtnData)) {
$ii = 0;
foreach ($rtnData as $k => $v) {
$addtime = $v['addtime'];
$recordnumber = $v['recordnumber'];
$parid = $v['parid'];
//$purid = $v['purchaseuser_id'];
$price = $v['price'];
$count = $v['count'];
$sku = $v['sku'];
$stockqty = $v['stockqty'];
$sendqty = $v['sendqty'];
$skuinfo = getSkuById($sku);
$name = $skuinfo[0]['goodsName'];
$parname = getParNameById($parid);
$purid = getOverCguser($sku);
$purname = getNameById($purid);
$datalist[$ii]['addtime'] = $addtime;
$datalist[$ii]['recordnumber'] = $recordnumber;
$datalist[$ii]['parname'] = $parname;
$datalist[$ii]['purname'] = $purname;
$datalist[$ii]['stockqty'] = $stockqty;
$datalist[$ii]['sendqty'] = $sendqty;
$datalist[$ii]['sku'] = $sku;
$datalist[$ii]['name'] = $name;
$datalist[$ii]['price'] = $price;
$datalist[$ii]['count'] = $count;
$datalist[$ii]['totalmoney'] = $price * $count;
$ii++;
}
$dataArr[$num] = $datalist;
$num++;
}
}
}
return $dataArr;
}
//$lastDay = $now ;//测试
$dateFarmat = date("Y-m-d", $lastDay);
$lastStart = strtotime($dateFarmat . "00:00:00");
$lastEnd = strtotime($dateFarmat . "23:59:59");
var_dump($lastStart, $lastEnd);
$sql = "select distinct a.id, a.*,b.*,c.price,c.count from ph_order_arrive_log as a left join ph_order as b \n\t\ton a.ordersn=b.recordnumber left join ph_order_detail as c\n\t\ton b.id=c.po_id \n\t\twhere a.sku=c.sku\n\t\tand a.arrive_time>{$lastStart} and a.arrive_time<{$lastEnd}\n \t";
echo $sql;
$sql = $dbConn->execute($sql);
$skuReachInfo = $dbConn->getResultArray($sql);
print_r($skuReachInfo);
$row = 2;
foreach ($skuReachInfo as $itemSku) {
$addtime = $itemSku['addtime'];
$recordnumber = $itemSku['recordnumber'];
$partnerName = getParterNameById($itemSku['partner_id']);
$purchaseName = getNameById($itemSku['purchaseuser_id']);
$sku = $itemSku['sku'];
$goodsName = getSkuById($sku);
$price = $itemSku['price'];
$count = $itemSku['count'];
$totalmoney = $price * $count;
$arrive_time = $itemSku['arrive_time'];
$amount = $itemSku['amount'];
//到货数量
$objPHPExcel->setActiveSheetIndex(0)->setCellValue('A' . $row, date("Y/m/d", $addtime));
$objPHPExcel->setActiveSheetIndex(0)->setCellValue('B' . $row, $recordnumber);
$objPHPExcel->setActiveSheetIndex(0)->setCellValue('C' . $row, $partnerName);
$objPHPExcel->setActiveSheetIndex(0)->setCellValue('D' . $row, $sku);
$objPHPExcel->setActiveSheetIndex(0)->setCellValue('E' . $row, $goodsName);
//产品名称
$objPHPExcel->setActiveSheetIndex(0)->setCellValue('F' . $row, $count);
<div class="col-lg-6">
<div class="panel panel-default">
<div class="panel-heading"><h3 class="panel-title">用户信息</h3></div>
<div class="panel-body">
<div class="form-group">
<label class="control-label x80">昵 称：</label>
<span><?php
echo $userinfo["nickname"];
?>
</span>
</div>
<div class="form-group">
<label class="control-label x80">姓 名：</label>
<span><?php
echo getNameById('student', $userinfo["uid"]);
?>
</span>
</div>
<div class="form-group">
<label class="control-label x80">邮 箱：</label>
<span><?php
echo $userinfo["email"];
?>
</span>
</div>
<div class="form-group">
<label class="control-label x80">个性签名：</label>
<span><?php
echo $userinfo["signature"];
?>
/**
* Login handle function.
* Usertype: Student
*/
public function login_()
{
try {
$cond['username'] = xassert(safepost('username'), Error('post'));
$pwd = xassert(safepost('password'), Error('post'));
$cond['password'] = encrypt($pwd);
$config = C('TMPL_PARSE_STRING');
$root = $config['__ROOT__'];
if ($id = DBModel::existUser('cernet_user', $cond)) {
session('usertype', 'cernet');
session('userid', $id);
session('username', $cond['username']);
session('truename', getNameById("cernet_user", $id));
header("Location: {$root}/Index/index");
// $this->success('', "__ROOT__/Index/index");
} elseif ($id = DBModel::existUser('second_user', $cond)) {
session('usertype', 'second');
session('userid', $id);
session('username', $cond['username']);
header("Location: {$root}/Index/index");
// $this->success('', "__ROOT__/Index/index");
} else {
# Error Tips
$this->error(Error('login'), lastpage());
}
} catch (Exception $e) {
throw_exception($e->getMessage());
}
}
if (isset($history) && !empty($history)) {
$count = 1;
echo '<table class="table table-bordered">
<thead>
<tr>
<th>#</th>
<th>Item Name</th>
<th>Transaction Id</th>
<th>Amount</th>
<th>Date</th>
</tr>
</thead>
<tbody>';
foreach ($history as $transaction_history) {
echo '<tr><td>' . $count . '</td><td>';
echo getNameById($transaction_history->getitemid());
echo '</td>';
echo '<td>';
echo $transaction_history->gettransactionid();
echo '</td>';
echo '<td>';
echo $transaction_history->getamount();
echo '</td>';
echo '<td>';
echo $transaction_history->getdate();
echo '</td></tr>';
$count++;
}
echo '</tbody> </table>';
}
}
?>
<tr>
<td><?php
echo $vo['id'];
?>
</td>
<td><?php
echo $vo['name'];
?>
</td>
<td><?php
echo getNameById('teacher', $vo['teaid']);
?>
</td>
<td><?php
echo getNameById('subject', $vo['subid']);
?>
</td>
<td><?php
echo $vo['xuefen'];
?>
</td>
<td>
<?php
echo showCourseStatus($vo['id']);
?>
</td>
</tr><?php
}
}
} else {
function getName_($key, $val)
{
switch ($key) {
case 'university':
return getNameById('cernet_university', $val);
case 'teacher':
return getNameById('cernet_teacher', $val);
case 'city':
return getNameById('cernet_city', $val);
case 'degree':
return getNameById('cernet_degree', $val);
case 'major':
return getNameById('cernet_major', $val);
case 'tutor_id':
return getNameById('cernet_tutor', $val);
case 'report_id':
return getNameById('cernet_report', $val);
case 'leader':
return getNameById('cernet_user', $val);
default:
return $val;
}
}
public function history_award()
{
eval(ADMIN);
$cond = $_GET;
unset($cond['__hash__']);
unset($cond['_URL_']);
$awards = DBModel::getByFields('second_award', $cond);
$tables = ['second_user', 'second_team', 'second_teacher'];
foreach ($awards as $k => $v) {
$awards[$k]['uname'] = getNameById($tables[$v['user_type']], $v['user_id']);
$awards[$k]['contest'] = $v['contest_id'];
$awards[$k]['award'] = $v['award'];
}
$this->assign("award", $awards);
$this->assign("type", $tables);
$this->assign("less", __FUNCTION__ . ".less");
eval(NDSP);
}
