function SaveCostCode()
{
$cc = new ACC_CostCodes();
PdoDataAccess::FillObjectByArray($cc, $_POST);
if (empty($_POST["IsBlockable"])) {
$cc->IsBlockable = "NO";
}
$where = " cc.IsActive='YES' AND level1=?";
$param = array($cc->level1);
if ($cc->level2 * 1 > 0) {
$where .= " AND level2=?";
$param[] = $cc->level2;
} else {
$where .= " AND level2 is null";
}
if ($cc->level3 * 1 > 0) {
$where .= " AND level3=?";
$param[] = $cc->level3;
} else {
$where .= " AND level3 is null";
}
$dt = ACC_CostCodes::SelectCost($where, $param);
if ($dt->rowCount() > 0) {
$record = $dt->fetch();
if ($record["CostID"] != $cc->CostID) {
Response::createObjectiveResponse(false, 'کد حساب تکراری است');
die;
}
}
if ($cc->CostID == '') {
$res = $cc->InsertCost();
} else {
$res = $cc->UpdateCost();
}
Response::createObjectiveResponse($res, $cc->popExceptionDescription());
die;
}
<?php
//--------------------------
// developer: Jafarkhani
// Date: 94.06
//--------------------------
require_once '../header.inc.php';
require_once 'baseinfo.class.php';
require_once '../global/ManageReport.class.php';
require_once inc_reportGenerator;
Manage_Report::BeginReport();
echo "<br><br>";
$dataTable = ACC_CostCodes::SelectCost(" 1=1 order by Costcode");
$rpg = new ReportGenerator();
$rpg->addColumn("کد حساب", "CostCode");
$rpg->addColumn("گروه حساب", "LevelTitle0");
$rpg->addColumn("حساب کل", "LevelTitle1");
$rpg->addColumn("معین", "LevelTitle2");
$rpg->addColumn("جزء معین", "LevelTitle3");
$rpg->mysql_resource = $dataTable;
$rpg->generateReport();
die;