</div> <?php /* $TEST = $baseService->getDB()->Execute("SELECT * FROM BO_PHAN WHERE TRUE"); debugging_p($TEST); $TEST2 = $baseService->getDB()->GetAll("SELECT * FROM BO_PHAN WHERE TRUE"); debugging_p($TEST2); $arr234 = $baseService->getDB()->GetAssoc("select * from BO_PHAN"); # returns associative array $key=>col debugging_p($arr234); */ //build a staic header $boPhanArray = $baseService->getDB()->GetAll("SELECT * FROM BO_PHAN WHERE TRUE"); $loaiNgayArray = $baseService->getDB()->GetAll("SELECT * FROM LOAI_NGAY WHERE TRUE"); debugging_p($boPhanArray, "bophanArray"); debugging_p($loaiNgayArray, "loaiNgayArray"); $htmlHeader = ""; $firstRowHeader = ""; $secondRowHeader = ""; // add chi Nhanh - ca columns $firstRowHeader = '<th class="sorting_disabled" colspan="1" rowspan="2">Chi nhánh - Ca</th>'; //$secondRowHeader = '<th class="sorting_disabled" colspan="0"></th>'; foreach ($loaiNgayArray as $loaiNgay) { //debugging("asd"); $firstRowHeader = $firstRowHeader . '<th align="center" class="sorting_disabled" colspan="' . count($boPhanArray) . '" rowspan="1"><div align="center">' . $loaiNgay['TEN'] . '</div></th>'; } $firstRowHeader = '<tr role="row">' . $firstRowHeader . '</tr>'; foreach ($loaiNgayArray as $loaiNgay) { foreach ($boPhanArray as $boPhan) { $secondRowHeader = $secondRowHeader . '<th class="sorting_disabled" colspan="1" rowspan="1">' . $boPhan['TEN'] . '</th>'; }
public function addElementMultiPrimaryKey($table, $obj) { $ele = new $table(); //debugging_p($ele, "ele") ; $PrimaryKeyName = $ele->PrimaryKeyName(); debugging_p($PrimaryKeyName, "PrimaryKeyName"); $arrArgLoad = array(); $strPrimaryKeyName = ""; foreach ($PrimaryKeyName as $pkey) { array_push($arrArgLoad, $obj[$pkey]); $strPrimaryKeyName = $strPrimaryKeyName . $pkey . ' = ? '; if ($i < count($PrimaryKeyName) - 1) { $strPrimaryKeyName = $strPrimaryKeyName . ' AND '; } $i++; } $ele->Load($strPrimaryKeyName, $arrArgLoad); //check in database the existance of this record or not. /* $strPrimaryKeyName = ''; $i = 0; foreach ($PrimaryKeyName as $pkey) { $strPrimaryKeyName = $strPrimaryKeyName.$pkey.' = '.$obj[$pkey]; if ($i < count($PrimaryKeyName) - 1) { $strPrimaryKeyName = $strPrimaryKeyName.' AND '; } $i++; } //$strPrimaryKeyName = $strPrimaryKeyName.'TRUE '; $ele->Load($strPrimaryKeyName); */ debugging_p($ele, "ele"); //update this record with new content. /* foreach($obj as $k=>$v){ if($k == 't' || $k == 'a' || $k == 'id'){ continue; } if($v == "NULL"){ $v = null; } $ele->$k = $v; } */ $ele->SO_LUONG = $obj['SO_LUONG']; debugging_p($ele, "ele after update new content"); $ok = $ele->Save(); debugging_p($ele, "ele after saved"); if (!$ok) { debugging($ele->ErrorMsg(), "ele->ErrorMsg()"); //error_log($ele->ErrorMsg()); return $this->findError($ele->ErrorMsg()); } return $ele->SO_LUONG; }