public function saveContent($model)
{
$model->removeSpecialAtt();
$model->user_id = 1;
$model->user_name = 'admin';
$model->publish_time = TTimeHelper::getCurrentTime();
$model->modify_time = TTimeHelper::getCurrentTime();
$model->title_format = CommonUtility::getTitleFormatValue($model->title_format);
$model->flag = CommonUtility::getFlagValue($model->flag);
$uploadedFile = CommonUtility::uploadFile('Content[title_pic]');
if ($uploadedFile != null) {
$model->title_pic = $uploadedFile['url'] . $uploadedFile['new_name'];
}
if ($model->title_pic == null || empty($model->title_pic)) {
$model->is_pic = 0;
} else {
$model->is_pic = 1;
}
if ($model->views == null) {
$model->views = 0;
}
if ($model->commonts == null) {
$model->commonts = 0;
}
if ($model->summary == null || empty($model->summary)) {
$content = strip_tags($model->content);
$pattern = '/\\s/';
//去除空白
$content = preg_replace($pattern, '', $content);
$model->summary = TStringHelper::subStr($content, 250);
}
$command = LuLu::createCommand();
if ($model->isNewRecord) {
$command->insert($this->currentTableName, $model);
} else {
$command->update($this->currentTableName, $model, ['id' => $model['id']]);
}
$command->execute();
}
public static function buildContentQuery($tableName, $other = [], $where = null)
{
$query = new Query();
if (isset($other['fields'])) {
$query->select($other['fields']);
}
if (empty($tableName)) {
// todo
$tableName = 'model_news';
}
$query->from($tableName);
if ($where !== null) {
$query->andWhere($where);
}
if (isset($other['where'])) {
$query->andWhere($other['where']);
}
if (isset($other['att1']) && is_integer($other['att1'])) {
$query->andWhere(['att1' => $other['att1']]);
}
if (isset($other['att2']) && is_integer($other['att2'])) {
$query->andWhere(['att2' => $other['att2']]);
}
if (isset($other['att3']) && is_integer($other['att3'])) {
$query->andWhere(['att3' => $other['att3']]);
}
if (isset($other['flag'])) {
$flagValue = CommonUtility::getFlagValue($other['flag']);
if ($flagValue > 0) {
$query->andWhere('flag&' . $flagValue . '>0');
}
}
if (isset($other['is_pic']) && $other['is_pic']) {
$query->andWhere(['is_pic' => 1]);
}
if (isset($other['order'])) {
$query->orderBy($other['order']);
} else {
$query->orderBy('publish_time desc');
}
if (isset($other['offset'])) {
$query->offset(intval($other['offset']));
} else {
$query->offset(0);
}
if (isset($other['limit'])) {
$query->limit(intval($other['limit']));
} else {
$query->limit(10);
}
return $query;
}
