yii2.0 - CURD操作 -杂项

# insert
//$row = Yii::app()->getDb()->createCommand()->insert('goods', array(  
\Yii::$app->db->createCommand()->insert('pur_purchase_discount', [
            'pur_number' => '654321',
            'buyer' => 11111,
        ])->execute();
        
#数组的键为数据表的字段，可以直接新增数据
$status = \Yii::$app->db->createCommand()->insert('数据表名', '数组形式的数据')->execute();
$return_id = \Yii::$app->db->getLastInsertID(); //返回ID
        
# select
//单表查询
$row = \Yii::$app->db->createCommand()
            ->setSql('select * from pur_purchase_discount WHERE  pur_number="123456"')
            ->queryAll();
              ->getRawSql(); //返回sql语句  ->getSql();
//            ->execute(); //返回查询数据条数
//            ->queryOne(); //返回一个值
//            ->queryAll(); //返回所有值

//查询
$sql= 'SELECT * FROM ' . $data_table . ' WHERE id=' . $id;
//        $rows=\Yii::$app->db->createCommand($sql)->query();
$rows=\Yii::$app->db->createCommand($sql)->queryOne();



//有误？？？？？？
//$goodsTypes = Yii::app()->getDb()->createCommand()  
$row = \Yii::$app->db->createCommand()
        ->select('type_id, type_name')  
        ->from('goods_type')  
        ->where('status=:status', [  
            ':status' => 1  
        ])  
        ->queryAll();  
        
//连表查询
//有误？？？
$row = \Yii::$app->db->createCommand()->from('goods g')
        ->select('g.good_id, g.good_name, gt.type_name, g.price, g.buy_nums, g.commit_nums, g.create_time')  
        ->join('goods_type gt', 'g.good_type=gt.type_id')  
        ->where('g.`status`=:status1 and gt.`status`=:status2', [  
            ':status1' => 1,  
            ':status2' => 2  
        ])  
        ->order('g.create_time desc')  
        ->queryAll();  
        
#delete
$row = \Yii::$app->db->createCommand()
            ->delete('pur_purchase_discount', "pur_number=:pur_number", array(
                ':pur_number' => 'sss',
            ))->execute();
            
//删除
方法一：
$status = \Yii::$app->db->createCommand()
    ->delete($data_table, 'id = ' . $id)
    ->execute();
$return_id = \Yii::$app->db->getLastInsertID(); //返回ID

方法二：
WarehouseMin::findOne(2)->delete();
    
    
# update
//$row = Yii::app()->getDb()->createCommand()->update('goods', [  
$row = \Yii::$app->db->createCommand()->update('pur_purchase_discount',
            ['buyer' => 'sss',],  //修改的数据
            "pur_number=:pur_number", [':pur_number' => 123456] //条件
        )->execute();

----------------------------------------
#insert 新增数据
$goods= new PurchaseDiscount();
        $attr=['pur_number'=>'123456','buyer'=>'www','discount_price'=>11.1];
        $goods->setAttributes($attr);
        return $goods->save(false);
        
#update 更新数据
$command = \Yii::$app->db->createCommand('UPDATE pur_purchase_discount SET buyer=123456543454 WHERE pur_number=123456');
$command->execute();
-------------------------
#获取插入数据时的id
$return_id = \Yii::$app->db->getLastInsertID();

#
当你在使用了$model->save();之后
$model->id 就是上一次保存的id


--------------------------------------
//插入：待验证？？
$model = new AlibabaAccount();
if ($model->load(Yii::$app->request->post()) && $model->save()) {
    return $this->redirect(['index']);
} else {
    return $this->render('create', [
        'model' => $model,
    ]);
}
    =================== post接收到的值 ==========
    Array
    (
        [_csrf] => dkhLVDVlcXkefSE1XBYVN0YsMWdgMws8FzsEJnhUPQAaPgFgQwMcFw==
        [AlibabaAccount] => Array
            (
                [account] => 12345
                [app_key] => 12345
                [secret_key] => 23456
                [redirect_uri] => http://www.purchase.com/alibaba-account/create
                [bind_account] => Array
                    (
                        [0] => 265
                    )

                [status] => 1
            )

    )
    ==========================================================

//判断数据是否存在，存在就修改
方法一：
$model = WarehouseMin::findOne(3);
$model->setAttribute('warehouse_code','shd');
$a = $model->save();

方法二：
//修改
public function actionUpdate($id)
{
    $model = $this->findModel($id);

    if ($model->load(Yii::$app->request->post()) && $model->save()) {
        return $this->redirect(['view', 'id' => $model->id]);
    } else {
        return $this->render('update', [
            'model' => $model,
        ]);
    }
}
//删除
public function actionDelete($id)
{
    $this->findModel($id)->delete();

    return $this->redirect(['index']);
}
protected function findModel($id)
{
    if (($model = BasicTactics::findOne($id)) !== null) {
        return $model;
    } else {
        throw new NotFoundHttpException('The requested page does not exist.');
    }
}

#方法三：修改
WarehouseMin::updateAll(['warehouse_code'=>'修改的字段'],['id'=>3]);

方法四：
$model = WarehouseMin::findOne(['warehouse_code' => 11]);
$model->is_handler    = $data['is_handler']; // 是否处理
$model->handler_type  = $data['handler_type'];   // 处理类型
$result = $model->save();

#查询
方法一：返回查询的字段的内容
$map['id']     = 3;
$a    = WarehouseMin::find()
    ->select('warehouse_code',)
    ->where($map)
    ->asArray()
    ->scalar();
    
方法二：返回数组和对象
$a    = WarehouseMin::find()->all();

方法三：判断数据是否找到
$model = PurchaseWarehouseAbnormal::findOne(['defective_id' => $defective_id]);
if(!$model) {
    return '没有查到数据';
}
方法四：
$rows = PurchaseWarehouseAbnormal::find()
    ->select(['defective_id', 'handler_type'])
    ->where(['is_handler' => 1, 'is_push_to_warehouse' => 0])
    ->limit(20)
    ->asArray()
    ->all();

-----------------------------
#数组和对象之间的转换
#方法一：
//定义函数
function array2object($array) {
  if (is_array($array)) {
    $obj = new StdClass();
    foreach ($array as $key => $val){
      $obj->$key = $val;
    }
  }
  else { $obj = $array; }
  return $obj;
}
function object2array($object) {
  if (is_object($object)) {
    foreach ($object as $key => $value) {
      $array[$key] = $value;
    }
  }
  else {
    $array = $object;
  }
  return $array;
}
//用法示例如下：
$array = array('foo' => 'bar','one' => 'two','three' => 'four');
$obj = array2object($array);
print $obj->one; // output's "two"
$arr = object2array($obj);
print $arr['foo']; // output's bar
#方法二：
//调用这个函数，将其幻化为数组，然后取出对应值
function object_array($array)
{
   if(is_object($array))
   {
    $array = (array)$array;
   }
   if(is_array($array))
   {
    foreach($array as $key=>$value)
    {
     $array[$key] = object_array($value);
    }
   }
   return $array;
}
---------------------------
PHP从数组中删除元素的四种方法实例
#方法一：使用 unset 函数
//删除一个元素，且保持原有索引不变
$array = array(0 => "a", 1 => "b", 2 => "c");
unset($array[1]);
//使用 unset 并未改变数组的原有索引。如果打算重排索引（让索引从0开始，并且连续），可以使用 array_values 函数：
$array = array_values($array);

#方法二：使用 array_splice 函数
#删除一个元素，不保持索引
$array = array(0 => "a", 1 => "b", 2 => "c");
array_splice($array, 1, 1); //↑ 你想删除的元素的Offset

#方法三：使用 array_diff 函数
//按值删除多个元素，保持索引(与 unset 类似，array_diff 也将保持索引。)
$array = array(0 => "a", 1 => "b", 2 => "c");
$array = array_diff($array, ["a", "c"]); //你想删除的数组元素值values

#方法四：使用 array_diff_key 函数
//按键删除多个元素，保持索引(与 unset 类似，array_diff_key 也将保持索引。)
$array = array(0 => "a", 1 => "b", 2 => "c");
$array = array_diff_key($array, [0 => "xy", "2" => "xy"]);//你想删除的数组键keys
----------------------------
获取变量类型：gettype($a);