$price = $app->request->post('price');
$date_start = $app->request->post('date_start');
$date_end = $app->request->post('date_end');
if ($aid == null) {
fail("aid is null");
}
try {
$contract = R::dispense('contract');
$contract->id = $id;
$contract->sid = $sid;
$contract->aid = $aid;
$contract->price = $price;
$contract->date_start = $date_start;
$contract->date_end = $date_end;
$contract->approved = "미승인";
safeStore($contract);
success('');
} catch (RedBeanPHP\RedException\SQL $e) {
fail($e);
}
});
$app->get('/agent', function () use($app) {
$agent = R::findAll('agent');
success(R::exportAll($agent));
});
$app->post('/agent', function () use($app) {
$json = $app->request->getBody();
$obj = json_decode($json);
$aid = $obj->{'aid'};
$fee = $obj->{'fee'};
$sql = "UPDATE agent SET fee = '{$fee}' WHERE aid = '{$aid}'";
| 전남 |
| 전북 |
| 제주 |
| 충남 |
| 충북 |
*/
R::setup( 'mysql:host=localhost;dbname=smartqna',
'root', 'denters0318' );
$region= R::dispense('region');
$region->lv0='string';
$region->lv1='string';
setUnique($region, array('lv0', 'lv1'));
safeStore($region);
function safeStore($obj)
{
try {
$id = R::store($obj);
echo "saved id [$id]";
} catch (RedBeanPHP\RedException\SQL $e) {
echo "failed: $e<br><br>";
}
}
function setUnique($bean, $arr)
{
$bean->setMeta("buildcommand.unique" , array($arr));
}
$school->year='string';
$school->sch_grade='string';
$school->sch_type='string';
$school->lv0='string';
$school->edu_dept='string';
$school->lv1='string';
$school->name='string';
$school->origin='string';
$school->status='string';
$school->establish='string';
$school->postal='string';
$school->address='string';
$school->phone='string';
$school->fax='string';
$school->homepage ='string';
safeStore($school);
function safeStore($obj)
{
try {
$id = R::store($obj);
echo "saved id [$id]";
} catch (RedBeanPHP\RedException\SQL $e) {
echo "failed: $e<br><br>";
}
}
?>
