public function put($rest, $id)
{
$req = $rest->request();
$info = $req->post();
$old_cost = get_standard_cost($id);
$update_no = stock_cost_update($id, $info['material_cost'], $info['labour_cost'], $info['overhead_cost'], $old_cost);
api_success_response(json_encode(array('stock_id' => $id)));
}
public function get($rest)
{
$locations = get_item_locations(false);
$ret = array();
while ($loc = db_fetch($locations)) {
$ret[] = array('loc_code' => $loc['loc_code'], 'location_name' => $loc['location_name'], 'delivery_address' => $loc['delivery_address'], 'phone' => $loc['phone'], 'phone2' => $loc['phone2'], 'fax' => $loc['fax'], 'email' => $loc['email'], 'contact' => $loc['contact']);
}
api_success_response(json_encode($ret));
}
private function glaccounts_all($from = null)
{
if ($from == null) {
$from = 0;
}
$sql = "SELECT " . TB_PREF . "chart_master.*," . TB_PREF . "chart_types.name AS AccountTypeName FROM " . TB_PREF . "chart_master," . TB_PREF . "chart_types WHERE " . TB_PREF . "chart_master.account_type=" . TB_PREF . "chart_types.id ORDER BY account_code LIMIT " . $from . ", " . RESULTS_PER_PAGE;
$query = db_query($sql, "error");
$info = array();
while ($data = db_fetch($query, "error")) {
$info[] = array('account_code' => $data['account_code'], 'account_name' => $data['account_name'], 'account_type' => $data['account_type'], 'account_code2' => $data['account_code2']);
}
api_success_response(json_encode($info));
}
private function taxgroups_all($from = null)
{
if ($from == null) {
$from = 0;
}
$sql = "SELECT * FROM " . TB_PREF . "tax_groups WHERE !inactive LIMIT " . $from . ", " . RESULTS_PER_PAGE;
$query = db_query($sql, "error");
$info = array();
while ($data = db_fetch($query, "error")) {
$info[] = array('id' => $data['id'], 'name' => $data['name'], 'tax_shipping' => $data['tax_shipping']);
}
api_success_response(json_encode($info));
}
private function bankaccounts_all($from = null)
{
if ($from == null) {
$from = 0;
}
$sql = "SELECT * FROM " . TB_PREF . "bank_accounts LIMIT " . $from . ", " . RESULTS_PER_PAGE;
$query = db_query($sql, "error");
$info = array();
while ($data = db_fetch($query, "error")) {
$info[] = array("id" => $data["id"], "account_type" => $data["account_type"], "account_code" => $data["account_code"], "bank_account_name" => $data["bank_account_name"], "bank_name" => $data["bank_name"], "bank_account_number" => $data["bank_account_number"], "bank_curr_code" => $data["bank_curr_code"], "bank_address" => $data["bank_address"], "dflt_curr_act" => $data["dflt_curr_act"]);
}
api_success_response(json_encode($info));
}
private function currencies_all($from = null)
{
if ($from == null) {
$from = 0;
}
$sql = "SELECT * FROM " . TB_PREF . "currencies WHERE !inactive LIMIT " . $from . ", " . RESULTS_PER_PAGE;
$query = db_query($sql, "error");
$info = array();
while ($data = db_fetch($query, "error")) {
$info[] = array('curr_abrev' => $data['curr_abrev'], 'currency' => $data['currency'], 'curr_symbol' => $data['curr_symbol'], 'country' => $data['country'], 'hundreds_name' => $data['hundreds_name']);
}
api_success_response(json_encode($info));
}
private function taxtypes_all($from = null)
{
if ($from == null) {
$from = 0;
}
$sql = "SELECT * FROM " . TB_PREF . "item_tax_types LIMIT " . $from . ", " . RESULTS_PER_PAGE;
$query = db_query($sql, "error");
$info = array();
while ($data = db_fetch($query, "error")) {
$info[] = array('id' => $data['id'], 'name' => $data['name'], 'exempt' => $data['exempt']);
}
api_success_response(json_encode($info));
}
private function supplier_all($from = null)
{
if ($from == null) {
$from = 0;
}
$sql = "SELECT * FROM " . TB_PREF . "suppliers LIMIT " . $from . ", " . RESULTS_PER_PAGE;
$query = db_query($sql, "error");
$info = array();
while ($data = db_fetch_assoc($query, "error")) {
$info[] = $data;
}
api_success_response(json_encode($info));
}
private function category_all($from = null)
{
$sql = "SELECT c.*, t.name as tax_name FROM " . TB_PREF . "stock_category c, " . TB_PREF . "item_tax_types t WHERE c.dflt_tax_type=t.id";
if ($from !== null) {
$sql .= "LIMIT " . $from . ", " . RESULTS_PER_PAGE;
}
$query = db_query($sql, "error");
$info = array();
while ($data = db_fetch($query, "error")) {
$info[] = array('category_id' => $data['category_id'], 'description' => $data['description'], 'dflt_tax_type' => $data['dflt_tax_type'], 'dflt_units' => $data['dflt_units'], 'dflt_mb_flag' => $data['dflt_mb_flag'], 'dflt_sales_act' => $data['dflt_sales_act'], 'dflt_cogs_act' => $data['dflt_cogs_act'], 'dflt_inventory_act' => $data['dflt_inventory_act'], 'dflt_adjustment_act' => $data['dflt_adjustment_act'], 'dflt_assembly_act' => $data['dflt_assembly_act'], 'dflt_no_sale' => $data['dflt_no_sale']);
}
api_success_response(json_encode($info));
}
function inventory_delete($id)
{
$app = \Slim\Slim::getInstance('SASYS');
$req = $app->request();
$info = $req->post();
$itm = get_item($id);
if ($itm == null) {
api_error(400, 'Invalid Stock Id');
}
delete_item($id);
$itm = get_item($id);
if ($itm != null) {
api_error(500, 'Could Not Delete from Database');
} else {
api_success_response("Item has been deleted");
}
}