/**
* 检测哪些分类是跟目前的分类信息不对应的
*
* @Author tianyunzi
* @DateTime 2016-02-18T09:38:48+0800
* @return [type] [description]
*/
public function checkCateInfoAction()
{
$count = 0;
$fp = fopen("/tmp/b", "r");
while (!feof($fp)) {
$line = trim(fgets($fp));
if (empty($line)) {
continue;
}
$count++;
$propertyArr = explode("\t", $line);
$propertyArr[1] = json_decode($propertyArr[1], true);
$cateid = $propertyArr[0];
$cateRs = Fbcateinfo::findFirst(array("conditions" => "cateid = ?1", "bind" => array(1 => $cateid), "limit" => 1));
if (empty($cateRs)) {
echo "分类 " . $cateid . "不存在\n";
continue;
}
if ($cateRs->is_leaf != 1) {
echo "分类 " . $cateid . "不是末级分类\n";
continue;
}
/** 检测下该分类下属性是不是已经入库 */
$count = Fbcateproperty::count("cateid='" . $cateid . "'");
if ($count == 0) {
echo "分类 " . $cateid . "没能入属性表成功!\n";
continue;
}
}
echo "总共" . $count . "条\n";
}
public function checkCatezh($cateid)
{
$cateMysql = Fbcateinfo::findFirst(array("conditions" => "cateid = ?1", "bind" => array(1 => $cateid), "limit" => 1));
if (empty($cateMysql)) {
return false;
}
if ($cateMysql->catezh) {
return true;
}
$catezh = $this->getCatezh($cateMysql->catename);
echo $cateMysql->catename . "\t" . $catezh . "\n";
$cateMysql->catezh = $catezh;
$cateMysql->save();
}
/**
* 分析下所有的新增的分类是否和属性对应，因为新增分类id是自增的，所以可能id对应的不正确
*
* @Author tianyunzi
* @DateTime 2016-02-18T10:28:38+0800
* @return [type] [description]
*/
public function cateaddAction()
{
$id = 0;
while (1) {
$cateMysql = Fbcateinfo::find(array("conditions" => "cateid > ?1 and is_copyadd = 1", "bind" => array(1 => $id), "limit" => 100));
$cateRs = $cateMysql->toArray();
if (empty($cateRs)) {
break;
}
foreach ($cateRs as $value) {
$id = $value["cateid"];
$propertyRs = Fbcateproperty::find(array("conditions" => "cateid = ?1", "bind" => array(1 => $id), "limit" => 100));
$propertyRs = $propertyRs->toArray();
if (empty($propertyRs)) {
continue;
}
echo $value["catename"] . "\n";
foreach ($propertyRs as $value1) {
echo "==== " . $value1["ppname"] . " ======\n";
}
}
}
}
