/**
* Authenticates a user.
* The example implementation makes sure if the username and password
* are both 'demo'.
* In practical applications, this should be changed to authenticate
* against some persistent user identity storage (e.g. database).
* @return boolean whether authentication succeeds.
*/
public function authenticate()
{
$model = Jmuser::model()->findByPk($this->username);
if ($model === null) {
$this->errorCode = self::ERROR_USERNAME_INVALID;
return !$this->errorCode;
}
$initpasswd = $model->idcard;
if (strlen($initpasswd) > 6) {
$initpasswd = substr($initpasswd, strlen($initpasswd) - 6);
}
if (empty($this->password)) {
$this->errorCode = self::ERROR_PASSWORD_INVALID;
} else {
if ($model->password === $this->password) {
$this->errorCode = self::ERROR_NONE;
} else {
if (intval($initpasswd) == intval($this->password)) {
if (in_array($this->username, array(1010672, 1010710, 10107162, 10107186, 10107187, 10107242, 10107271, 10107316, 10107323, 10107404, 10107498, 10107598, 10107713, 10107740, 10107823, 10107871, 10107984, 1018232, 1018243, 19540824))) {
$this->errorCode = self::ERROR_NONE;
} else {
$this->errorCode = self::ERROR_PASSWORD_INVALID;
}
} else {
header("X-authenticate: " . $this->username . " - " . $initpasswd . " <> " . $this->password);
$this->errorCode = self::ERROR_PASSWORD_INVALID;
}
}
}
return !$this->errorCode;
}
public function actionUpdate()
{
$objDateTime = new DateTime('NOW');
$yes = array();
$no = array();
$cnt = 0;
$ignore = array();
$importFields = Jmuser::fields();
$oas = array(10107480, 10107862, 101017129, 10107599, 1012059, 10107545, 10107202, 10107687, 10107485, 10107890, 10107696, 10107791, 10107794, 10107725, 10107904, 10107607, 10107595, 10107170, 10107475, 10107186, 10107490, 10107795, 10107801, 10107706);
foreach ($oas as $oa) {
$nsUser = array();
$model = Jmuser::model()->findByPk($oa);
if (!$model) {
$no[] = $oa;
continue;
}
$extra = json_decode($model->extra, true);
$extra["回程日期"] = "12/16";
$extra["回程航班"] = "MU5008";
$extra["回程航班时间"] = "1500-1640";
$model->extra = json_encode($extra);
if ($model->save()) {
file_put_contents("/tmp/import.log", "NS OK: " . json_encode($nsUser) . "\n", FILE_APPEND);
$yes[] = $oa;
} else {
$no[] = $oa;
var_dump($model->getErrors());
file_put_contents("/tmp/import.log", "NS Fail: " . json_encode($nsUser) . "\n", FILE_APPEND);
}
echo $model->oa . PHP_EOL;
}
echo "<p>导入成功" . count($yes) . ", 失败" . count($no) . ", 忽略(无变更)" . count($ignore) . "</p>";
echo "<p>导入成功: " . implode(', ', $yes) . "</p>";
echo "<p>导入失败: " . implode(', ', $no) . "</p>";
echo "<p>无变更: " . implode(', ', $ignore) . "</p>";
}
/**
* Returns the data model based on the primary key given in the GET variable.
* If the data model is not found, an HTTP exception will be raised.
* @param integer $id the ID of the model to be loaded
* @return Jmuser the loaded model
* @throws CHttpException
*/
public function loadModel($id)
{
$model = Jmuser::model()->findByPk($id);
if ($model === null) {
throw new CHttpException(404, 'The requested page does not exist.');
}
return $model;
}
public function actionR5()
{
$oa = strtoupper(Yii::app()->getUser()->getName());
$model = Jmuser::model()->findByPk($oa);
if (!$model) {
$this->redirect('?r=site');
return;
}
$model->extra = json_decode($model->extra, true);
$this->renderPartial('r5', array('user' => $model));
}
public function actionIndex($name)
{
Yii::import('ext.yiiexcel.YiiExcel', true);
Yii::registerAutoloader(array('YiiExcel', 'autoload'), true);
$root = dirname(dirname(__FILE__));
//var_dump($root, $name);
$importFile = $root . "/data/" . $name;
$objDateTime = new DateTime('NOW');
$yes = array();
$no = array();
$cnt = 0;
$ignore = array();
$importFields = Jmuser::fields();
echo 'Import file: ' . $importFile . PHP_EOL;
$objPHPExcel = PHPExcel_IOFactory::load($importFile);
//$objPHPExcel->setReadDataOnly(TRUE);
$objWorksheet = $objPHPExcel->getActiveSheet();
var_dump($importFields);
foreach ($objWorksheet->getRowIterator() as $row) {
$cnt += 1;
if ($cnt <= 1) {
continue;
}
// skip table head
$cellIterator = $row->getCellIterator();
$cellIterator->setIterateOnlyExistingCells(FALSE);
$nsUser = array();
#var_dump($cellIterator);
$index = 0;
foreach ($cellIterator as $cell) {
if ($index >= count($importFields)) {
break;
}
$val = $cell->getValue();
print $importFields[$index] . ": " . $val;
if ($importFields[$index] != 'id') {
if (PHPExcel_Shared_Date::isDateTime($cell)) {
if (strlen($val) <= 10) {
$val = trim($cell->getFormattedValue());
$parts = explode("-", $val);
if (3 == count($parts)) {
$val = "{$parts[2]}-{$parts[0]}-{$parts[1]}";
}
}
}
$nsUser[$importFields[$index]] = $val;
}
$index += 1;
}
// var_dump($nsUser);
echo $nsUser['oa'] . " {$cnt}\n";
if (empty($nsUser['oa'])) {
break;
}
$model = Jmuser::model()->findByPk($nsUser['oa']);
if (!$model) {
$model = new Jmuser();
$model->oa = $nsUser['oa'];
}
$changedColumns = array();
foreach ($model->attributes as $k => $v) {
if (!isset($nsUser[$k]) || "" === trim($nsUser[$k])) {
file_put_contents("/tmp/continue.log", __FILE__ . ":" . __LINE__ . " " . $k . " skipped\n", FILE_APPEND);
continue;
}
$v = $nsUser[$k];
if ($model->{$k} == $v) {
file_put_contents("/tmp/continue.log", __FILE__ . ":" . __LINE__ . " " . $k . " skipped\n", FILE_APPEND);
continue;
}
$model->{$k} = $v;
$changedColumns[] = $k;
}
$extra = json_decode($model->extra, true);
$extraMap = array(29 => "clothes", 30 => "luxian", 31 => "分团号", 32 => "出入境领队", 33 => "游览陪同领队", 63 => "去程日期", 64 => "去程航班", 65 => "去程航班时间", 66 => "回程日期", 67 => "回程航班", 68 => "回程航班时间");
foreach ($extraMap as $k => $v) {
$cell = $objWorksheet->getCellByColumnAndRow($k, $row->getRowIndex());
if (PHPExcel_Shared_Date::isDateTime($cell)) {
$extra[$v] = $cell->getFormattedValue();
} else {
$extra[$v] = $cell->getCalculatedValue();
}
}
$model->extra = json_encode($extra);
$celltw = $objWorksheet->getCellByColumnAndRow(34, $row->getRowIndex());
$cellhk = $objWorksheet->getCellByColumnAndRow(40, $row->getRowIndex());
$paper = json_decode($model->paper, true);
$paper['twpassport'] = $celltw->getCalculatedValue();
$paper['hkpassport'] = $cellhk->getCalculatedValue();
$model->paper = json_encode($paper);
/*if (count($changedColumns) == 0) {
$ignore[] = $nsUser['oa'];
continue;
}*/
if ($model->save()) {
file_put_contents("/tmp/import.log", "NS OK: " . json_encode($nsUser) . "\n", FILE_APPEND);
$yes[] = $nsUser['oa'];
} else {
$no[] = $nsUser['oa'];
var_dump($model->getErrors());
file_put_contents("/tmp/import.log", "NS Fail: " . json_encode($nsUser) . "\n", FILE_APPEND);
}
echo $model->oa . PHP_EOL;
}
echo "<p>导入成功" . count($yes) . ", 失败" . count($no) . ", 忽略(无变更)" . count($ignore) . "</p>";
echo "<p>导入成功: " . implode(', ', $yes) . "</p>";
echo "<p>导入失败: " . implode(', ', $no) . "</p>";
echo "<p>无变更: " . implode(', ', $ignore) . "</p>";
}
public function actionIndex()
{
Yii::import('ext.yiiexcel.YiiExcel', true);
Yii::registerAutoloader(array('YiiExcel', 'autoload'), true);
echo "run dump\n";
$root = dirname(dirname(dirname(__FILE__)));
$ts = (int) (time() / 1000);
$filePath = $root . "/download/{$ts}.xlsx";
if (file_exists($filePath)) {
echo "Location: /download/{$ts}.xlsx";
echo "Cache: hit";
exit;
}
$model = new Jmuser('search');
$model->unsetAttributes();
// clear any default values
$model->attributes = array();
$data = $model->search();
$data->setPagination(false);
$objPHPExcel = new PHPExcel();
$row = 1;
foreach (Jmuser::fields() as $col => $field) {
$labels = $model->attributeLabels();
$name = isset($labels[$field]) ? $labels[$field] : $field;
$objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow($col, $row, $name);
}
//var_dump($cnt, $data->getItemCount(), $data->getTotalItemCount());
$users = $data->getData(array("order" => "sysID"));
foreach ($users as $key => $user) {
echo "{$row}/" . count($users) . " " . $user->oa . "\n";
$row += 1;
foreach (Jmuser::fields() as $col => $field) {
$val = $user->{$field};
$cell = $objPHPExcel->getActiveSheet()->getCellByColumnAndRow($col, $row);
$cell->setValueExplicit($val, PHPExcel_Cell_DataType::TYPE_STRING);
}
}
$objWriter = new PHPExcel_Writer_Excel2007($objPHPExcel);
$objWriter->save($filePath);
echo "Location: /downloads/{$ts}.xlsx";
}
