public function actionAlarm()
{
$mes = $_REQUEST['ids'];
$mes = json_decode($mes, true);
$res = array();
//获取的是一个RFID数组
foreach ($mes as $key => $value) {
$data = AsAsset::model()->findByPk($value);
if (is_null($data)) {
$res[] = array("id" => $value, "name" => 'null', "alarm" => 0);
} else {
if ($data['outPrm'] == 'y') {
if ($data['state'] == 'out') {
// echo "1";
$res[] = array("id" => $data['RFID'], "name" => $data['assetName'], "alarm" => 0);
} elseif ($data['state'] == 'in') {
// echo "2";
$res[] = array("id" => $data['RFID'], "name" => $data['assetName'], "alarm" => 1);
$mes = "RFID:" . $value . "原因:该商品显示在库存中";
yii::log($mes, "info", "alarm.log");
//将报警信息写入日志
}
} else {
$mes = "RFID:" . $value . "原因:该商品不允许外借";
yii::log($mes, "info", "alarm.log");
$res[] = array("id" => $data['RFID'], "name" => $data['assetName'], "alarm" => 1);
}
}
}
//返回值的形式为RFID，assetName，alarm（1是报警，0是不报警）
$res1 = json_encode($res);
echo $res1;
}
public function changeLogo(CUploadedFile $uploadedFile)
{
$basePath = Yii::app()->getModule('cabinet')->getUploadPath();
//создаем каталог для аватарок, если не существует
if (!is_dir($basePath) && !@mkdir($basePath, 0755, true)) {
throw new CException(Yii::t('default', 'It is not possible to create directory for logos!'));
}
$filename = $this->id . '_' . time() . '.' . $uploadedFile->extensionName;
// обновить файл
//$this->removeOldLogo();
if (!$uploadedFile->saveAs($basePath . $filename)) {
throw new CException(Yii::t('default', 'It is not possible to save logos!'));
}
// получить запись лого
$photo = $this->with('photo')->find('photo.id=:id', [':id' => $this->logo_id]);
$webroot = Yii::getpathOfAlias('webroot');
$trimPath = str_replace($webroot, '', $basePath);
$logoFileOld = null;
$File = new File();
$File->model = 'Company';
$File->type = 'image';
$File->size = filesize($basePath . $filename);
$File->name = $filename;
$File->path = $trimPath . $filename;
$File->record_id = 0;
if (!is_null($photo['photo'])) {
$File->id = $photo['photo']['id'];
$File->isNewRecord = false;
$logoFileOld = $photo['photo']['path'];
}
if ($File->save()) {
if (0 != strcmp($logoFileOld, $File->path)) {
@unlink($webroot . $logoFileOld);
}
} else {
yii::log("changeLogo save FAILED id=[" . $File->id . "]", "info");
}
if ($this->logo_id != $File->id) {
// поменять logo_id
$this->logo_id = $File->id;
if ($this->validate(['logo_id'])) {
if (true === $this->update(['logo_id'])) {
} else {
Yii::log("changeLogo update logo_id FAILED", 'info');
}
} else {
Yii::log("changeLogo validate logo_id FAILED", 'info');
}
}
//$this->logo = $filename;
return true;
}
/**
* 资产归还操作
*
* @author 张钰,汤杰
* @param
* RFID
* @todo 删除AsApply表中的相关记录，添加到AsReturned表中
*/
public function actionReturn()
{
if (XUtils::method() == 'POST' && $_POST['return'] == '确认归还') {
$RFID = $_POST['RFID'];
// var_dump($_POST['RFID']);
$asset = AsAsset::model()->findByPk($RFID);
if ($asset['state'] == 'out') {
$count = AsAsset::model()->updateByPk($RFID, array('state' => 'in'));
if ($count > 0) {
date_default_timezone_set('UTC');
$sql = "UPDATE as_borrow SET returnTime=:returnTime WHERE assetID =:assetID";
Yii::app()->db->createCommand($sql)->execute(array(':returnTime' => date('Y-m-d'), ':assetID' => $RFID));
// $sql = "SELECT * FROM as_borrow WHERE assetID =:assetID";
// $data =Yii::app ()->db->createCommand ( $sql )->queryAll();
// $data=AsBorrow::model()->findAll("assetID =:assetID",array (":assetID"=>$RFID));
$data = AsBorrow::model()->findAll("assetID =:assetID", array(":assetID" => $RFID));
$data = json_decode(CJSON::encode($data), TRUE);
$mes = "借出号:" . $data[0]['borrowId'] . " 借出人ID:" . $data[0]['userId'] . " 借出人姓名:" . $data[0]['userName'] . " 电话:" . $data[0]['userTeleNum'] . " 资产名称:" . $data[0]['assetName'] . " 资产ID:" . $data[0]['assetID'] . " 借出时间:" . $data[0]['borrowTime'] . " 归还时间:" . $data[0]['returnTime'];
yii::log($mes, "info", "borrow.log");
$analyse = new AsAnalyse();
$analyse->assetID = $data[0]['assetID'];
$analyse->assetName = $data[0]['assetName'];
$analyse->type = $data[0]['type'];
$analyse->assetSpecification = $data[0]['assetSpecification'];
$analyse->borrowTime = $data[0]['borrowTime'];
$analyse->returnTime = $data[0]['returnTime'];
// echo var_dump($analyse);
if ($analyse->save() > 0) {
$sql = "DELETE FROM as_borrow WHERE assetID=:assetID";
$data = Yii::app()->db->createCommand($sql)->execute(array(':assetID' => $RFID));
//$borrow->updateAll(array('assetID'=>$RFID),'returnTime=:returnTime',array(':returnTime'=> date('Y-m-d')));
echo "<script language=\"JavaScript\">alert(\"归还成功\");</script>";
} else {
echo "<script language=\"JavaScript\">alert(\"分析记录失败\");</script>";
}
// $sql = "DELETE FROM as_borrow WHERE assetID=:assetID";
// $data =Yii::app ()->db->createCommand ( $sql )->execute(array (':assetID' => $RFID));
// echo "<script language=\"JavaScript\">alert(\"归还成功\");</script>";
} else {
echo "<script language=\"JavaScript\">alert(\"归还失败\");</script>";
}
} else {
echo "<script language=\"JavaScript\">alert(\"该设备未被借出\");</script>";
}
} elseif (XUtils::method() == 'POST' && $_POST['return'] == '查看') {
$RFID = $_POST['RFID'];
$sql = "SELECT * FROM as_asset,as_borrow WHERE as_asset.RFID = '" . $RFID . "' and as_borrow.assetID = '" . $RFID . "'";
// echo $sql;
$data = Yii::app()->db->createCommand($sql)->queryAll();
$data = json_decode(CJSON::encode($data), TRUE);
// var_dump($data);
}
$this->render('return', array('RFID' => $_POST['RFID'], 'assetName' => $data[0]['assetName'], 'specification' => $data[0]['specification'], 'inTime' => $data[0]['inTime'], 'storageId' => $data[0]['storageId'], 'price' => $data[0]['Price'], 'name' => $data[0]['userName']));
}
