最近,需要将原来的数据重新建模更新,在导数据的时候,需要用到cms的主表数据和附表数据,以及将所有数据整合插入新建的模型中去,示例代码记录如下:
//导数据
public function daoshuju()
{
$chart_db = pc_base::load_model('chart_model');
$chart_data_db = pc_base::load_model('chart_data_model');
$gangqinpu_db = pc_base::load_model('gangqinpu_model');
$gangqinpu_data_db = pc_base::load_model('gangqinpu_data_model');
$where = "`status` = 99 and `id` <4241 and `catid` = 489";
$info=array();
$info=$chart_db->select($where, '*', '5000', "`id` desc");
$count=0;
foreach($info AS $k=>$v)
{
$cc=$chart_data_db->get_one(array('id'=>$v['id']));
/*
$arr=array2string($quputupian);
$array = $temp = array();
if(!empty($arr)) {
foreach($arr as $key=>$val) {
$temp['url'] = $val['url'];
$temp['alt'] = $val['alt'];
$array[$key] = $temp;
}
}
$array = array2string($array);*/
$data['catid']=622;
$data['title'] = $v['title'];
$data['keywords'] = $v['keywords'];
$data['description'] = $v['description'];
$data['bianzhuzhe'] = $v['bianzhuzhe'];
$data['zimu'] = $v['zimu'];
$data['dealpic'] = $v['dealpic'];
$data['picnum'] = $v['picnum'];
$data['pdf'] = $v['pdf'];
$data['pdfpath'] = $v['pdfpath'];
$data['language'] = $v['language'];
$data['username'] = 'shihaijuan';
$data['status'] = $v['status'];
$data['listorder'] = $v['listorder'];
$data['thumb'] = $v['thumb'];
$data['dynamic_parameter'] = $v['dynamic_parameter'];
$data['dealpj'] = $v['dealpj'];
$data['puji'] = $v['puji'];
$data['filesize'] = $v['filesize'];
$data['pdfpage'] = $v['pdfpage'];
$data['hqgq_url'] = $v['url'];
$data['inputtime'] = SYS_TIME;
$data['updatetime'] = SYS_TIME;
$resid = $gangqinpu_db->insert($data,true);
if($resid){
$data2['id'] = $resid;
$data2['quputupian'] =addslashes($cc['quputupian']);
$data2['content'] = $cc['content'];
$data2['pdfs'] = addslashes($cc['pdfs']);
$gangqinpu_data_db->insert($data2);
$count++;
}
}
echo '成功上传'.$count.'条数据!';
}