Changeset 22644
- Timestamp:
- 2013/03/09 19:33:36 (11 years ago)
- File:
-
- 1 edited
Legend:
- Unmodified
- Added
- Removed
-
branches/camp/camp-2_13-tax/data/class/helper/SC_Helper_TaxRule.php
r22639 r22644 193 193 194 194 195 function getTaxRuleList($has_disable = false) 196 { 197 198 } 199 200 function getTaxRuleData($tax_rule_id) 201 { 202 $objQuery =& SC_Query_Ex::getSingletonInstance(); 195 function getTaxRuleList($has_deleted = false) 196 { 197 $objQuery =& SC_Query_Ex::getSingletonInstance(); 198 $col = 'tax_rule_id, tax_rate, calc_rule, apply_date'; 199 $where = ''; 200 if (!$has_deleted) { 201 $where .= 'del_flg = 0'; 202 } 203 $table = 'dtb_tax_rule'; 204 $objQuery->setOrder('tax_rule_id DESC'); 205 $arrRet = $objQuery->select($col, $table, $where); 206 return $arrRet; 207 208 } 209 210 function getTaxRuleData($tax_rule_id, $has_deleted = false) 211 { 212 $objQuery =& SC_Query_Ex::getSingletonInstance(); 213 $where = 'tax_rule_id = ?'; 214 if (!$has_deleted) { 215 $where .= ' AND del_flg = 0'; 216 } 203 217 return $objQuery->getRow('*', 'dtb_tax_rule', 'tax_rule_id = ?', array($tax_rule_id)); 204 218 } 205 219 206 207 function registerTaxRuleData() { 220 221 222 function getTaxRuleByTime($apply_date, $has_deleted = false) 223 { 224 $objQuery =& SC_Query_Ex::getSingletonInstance(); 225 $where = 'apply_date = ?'; 226 if (!$has_deleted) { 227 $where .= ' AND del_flg = 0'; 228 } 229 $arrRet = $objQuery->select('*', 'dtb_tax_rule', $where, array($apply_date)); 230 return $arrRet[0]; 231 } 232 233 function registerTaxRuleData($sqlval) { 234 $objQuery =& SC_Query_Ex::getSingletonInstance(); 235 236 $sqlval['apply_date'] = SC_Utils_Ex::sfGetTimestampistime($sqlval['apply_date_year'], $sqlval['apply_date_month'], $sqlval['apply_date_day'],$sqlval['apply_date_hour'], $sqlval['apply_date_minutes']); 237 238 unset($sqlval['apply_date_year']); 239 unset($sqlval['apply_date_month']); 240 unset($sqlval['apply_date_day']); 241 unset($sqlval['apply_date_hour']); 242 unset($sqlval['apply_date_minutes']); 243 244 $tax_rule_id = $sqlval['tax_rule_id']; 245 $sqlval['update_date'] = 'CURRENT_TIMESTAMP'; 246 // 新規登録 247 if ($tax_rule_id == '') { 248 // INSERTの実行 249 $sqlval['create_date'] = 'CURRENT_TIMESTAMP'; 250 $sqlval['tax_rule_id'] = $objQuery->nextVal('dtb_tax_rule_tax_rule_id'); 251 $ret = $objQuery->insert('dtb_tax_rule', $sqlval); 252 // 既存編集 253 } else { 254 unset($sqlval['tax_rule_id']); 255 unset($sqlval['create_date']); 256 $where = 'tax_rule_id = ?'; 257 $ret = $objQuery->update('dtb_tax_rule', $sqlval, $where, array($tax_rule_id)); 258 } 259 return ($ret) ? $sqlval['tax_rule_id'] : FALSE; 260 } 261 262 /** 263 * 税規約の削除. 264 * 265 * @param integer $tax_rule_id 税規約ID 266 * @return void 267 */ 268 public function deleteTaxRuleData($tax_rule_id) 269 { 270 $objQuery =& SC_Query_Ex::getSingletonInstance(); 271 $sqlval['del_flg'] = 1; 272 $sqlval['update_date'] = 'CURRENT_TIMESTAMP'; 273 $where = 'tax_rule_id = ?'; 274 $objQuery->update('dtb_tax_rule', $sqlval, $where, array($tax_rule_id)); 208 275 } 209 276
Note: See TracChangeset
for help on using the changeset viewer.