tp5视图里写原生php,tp5加入PHP原生代码操作数据库笔记

//检测是否有时间字段开始

$jcsql="select count(*) from information_schema.columns where table_name = '".$table."' and column_name = '".$field1."'";

$jcfe=db($table)->query($jcsql)[0]['count(*)'];//字段数量

if($jcfe=="0"){db("$table")->query("ALTER TABLE `$table` ADD `$field1` VARCHAR(255) NOT NULL");}

//检测是否有时间字段结束

$jckh=db("$table")->where("kehuid",$cdata[2])->find();

if(empty($jckh)){

$id1=db("$table")->order("id1 desc")->find()['id1']+1;

$kehuid=$cdata[2];

$kehu=$cdata[3];

$jine=$cdata[10];

$sqll="INSERT INTO $table (id1,kehu,kehuid,$field1) VALUES ('$id1','$kehu','$kehuid','$jine')";

db($table)->query($sqll);

}else{

$sqlll="select * from $table where kehuid='".$cdata[2]."'";

$yjl=db($table)->query($sqlll);

$yjl=$yjl[0][$field1];

$indata=$cdata[10]+$yjl;

$sqll="update $table set $field1='".$indata."' where kehuid='".$cdata[2]."'";

db($table)->query($sqll);

}

//保存至客户销售报表结束

//保存至员工销售报表开始

$table='yuangongbaobiao1';

//检测是否有时间字段开始

$jcsql="select count(*) from information_schema.columns where table_name = '".$table."' and column_name = '".$field1."'";

$jcfe=db($table)->query($jcsql)[0]['count(*)'];//字段数量

if($jcfe=="0"){db("$table")->query("ALTER TABLE `$table` ADD `$field1` VARCHAR(255) NOT NULL");}

//检测是否有时间字段结束

$jckh=db("$table")->where("name",$cdata[12])->find();

if(empty($jckh)){

$id1=db("$table")->order("id1 desc")->find()['id1']+1;

$name=$cdata[12];

$jine=$cdata[10];

$sqll="INSERT INTO $table (id1,name,$field1) VALUES ('$id1','$name','$jine')";

db($table)->query($sqll);

}else{

$sqlll="select * from $table where name='".$cdata[12]."'";

$yjl=db($table)->query($sqlll);

$yjl=$yjl[0][$field1];

$indata=$cdata[10]+$yjl;

$sqll="update $table set $field1='".$indata."' where name='".$cdata[12]."'";

db($table)->query($sqll);

}

//保存至员工销售报表结束

//保存至货销报表(数量表)开始

$table="huoxiaobaobiao1";

for($i=0;$i

$jcsql="select count(*) from information_schema.columns where table_name = '".$table."' and column_name = '".$field1."'";

$jcfe=db($table)->query($jcsql)[0]['count(*)'];//字段数量

if($jcfe=="0"){db("$table")->query("ALTER TABLE `$table` ADD `$field1` VARCHAR(255) NOT NULL");}

//检测是否有时间字段结束

$jckh=db("$table")->where("pinpai",$data1[$i][1])->where("mingcheng",$data1[$i][2])->where("xinghao",$data1[$i][3])->find();

if(empty($jckh)){

$id1=db("$table")->order("id1 desc")->find()['id1']+1;

$pinpai=$data1[$i][1];

$mingcheng=$data1[$i][2];

$xinghao=$data1[$i][3];

$sl=$data1[$i][7];

$sqll="INSERT INTO $table (id1,pinpai,mingcheng,xinghao,$field1) VALUES ('$id1','$pinpai','$mingcheng','$xinghao','$sl')";

db($table)->query($sqll);

}else{

$sqlll="select * from $table where pinpai='".$data1[$i][1]."' and mingcheng='".$data1[$i][2]."' and xinghao ='".$data1[$i][3]."'";

$yjl=db($table)->query($sqlll);

$yjl=$yjl[0][$field1];

$indata=$data1[$i][7]+$yjl;

$sqll="update $table set $field1='".$indata."' where pinpai='".$data1[$i][1]."' and mingcheng='".$data1[$i][2]."' and xinghao ='".$data1[$i][3]."'";

db($table)->query($sqll);

}

}

//保存至货销报表(数量表)结束

//保存至货销报表(金额表)开始

$table="huoxiaobaobiao2";

for($i=0;$i

$jcsql="select count(*) from information_schema.columns where table_name = '".$table."' and column_name = '".$field1."'";

$jcfe=db($table)->query($jcsql)[0]['count(*)'];//字段数量

if($jcfe=="0"){db("$table")->query("ALTER TABLE `$table` ADD `$field1` VARCHAR(255) NOT NULL");}

//检测是否有时间字段结束

$jckh=db("$table")->where("pinpai",$data1[$i][1])->where("mingcheng",$data1[$i][2])->where("xinghao",$data1[$i][3])->find();

if(empty($jckh)){

$id1=db("$table")->order("id1 desc")->find()['id1']+1;

$pinpai=$data1[$i][1];

$mingcheng=$data1[$i][2];

$xinghao=$data1[$i][3];

$sl=$data1[$i][10];

$sqll="INSERT INTO $table (id1,pinpai,mingcheng,xinghao,$field1) VALUES ('$id1','$pinpai','$mingcheng','$xinghao','$sl')";

db($table)->query($sqll);

}else{

$sqlll="select * from $table where pinpai='".$data1[$i][1]."' and mingcheng='".$data1[$i][2]."' and xinghao ='".$data1[$i][3]."'";

$yjl=db($table)->query($sqlll);

$yjl=$yjl[0][$field1];

$indata=$data1[$i][10]+$yjl;

$sqll="update $table set $field1='".$indata."' where pinpai='".$data1[$i][1]."' and mingcheng='".$data1[$i][2]."' and xinghao ='".$data1[$i][3]."'";

db($table)->query($sqll);

}

}

//保存至货销报表(金额表)结束

//检测是否有时间字段开始

$table="yuedubaobiao";

$jcsql="select count(*) from information_schema.columns where table_name = '".$table."' and column_name = '".$field1."'";

$jcfe=db($table)->query($jcsql)[0]['count(*)'];//字段数量

if($jcfe=="0"){

db($table)->query("ALTER TABLE `$table` ADD `$field1` VARCHAR(255) NOT NULL");

db($table)->query("update yuedubaobiao set $field1 = '0'");

}

$sqlll="select * from $table where xiangmu='销售总金额'";

$yjl=db($table)->query($sqlll);

$yjl=$yjl[0][$field1];

$indata=$cdata[10]+$yjl;

$sqll="update $table set $field1='".$indata."' where xiangmu='销售总金额'";

db($table)->query($sqll);

//保存至客户销售报表结束