/var/www/myprog.com.ua/admin/models
Edit: /var/www/myprog.com.ua/admin/models/class.reference_model.php (15379B)
database->prepare("SELECT r.*
FROM `company` r
WHERE r.`deleted`='0'");
$sth->execute();
$data = $sth->fetchAll(PDO::FETCH_ASSOC);
}catch(PDOException $e){
//echo $e->getMessage();exit;
return $e->getMessage();
}
//var_export($data);exit;
return $data;
}
public function getCompany($id=0){
if($id==0)return;
try{
$sth = $this->database->prepare("SELECT r.*
FROM `company` r
WHERE r.id='".$id."' AND r.`deleted`='0' ");
$sth->execute();
$data = $sth->fetchAll(PDO::FETCH_ASSOC);
}catch(PDOException $e){
//echo $e->getMessage();exit;
return $e->getMessage();
}
//var_export($data);exit;
return $data[0];
}
public function getCompanyOrderTypes($company_id=0){
if($company_id==0)return;
try{
$sth = $this->database->prepare("SELECT cot.*
FROM `company_order_types` cot
INNER JOIN order_types ot ON ot.id=cot.order_type_id
WHERE cot.company_id='".$company_id."' AND ot.deleted='0' GROUP BY cot.order_type_id");
$sth->execute();
$data = $sth->fetchAll(PDO::FETCH_ASSOC);
}catch(PDOException $e){
//echo $e->getMessage();exit;
return null;
}
//var_export($data);exit;
return $data;
}
public function getCompanyContractor($company_id=0){
if($company_id==0)return;
try{
$sth = $this->database->prepare("SELECT cc.*
FROM `company_contractor` cc
INNER JOIN contractor c ON c.id=cc.contractor_id
WHERE cc.company_id='".$company_id."' AND c.deleted='0' GROUP BY cc.contractor_id");
$sth->execute();
$data = $sth->fetchAll(PDO::FETCH_ASSOC);
}catch(PDOException $e){
//echo $e->getMessage();exit;
return null;
}
//var_export($data);exit;
return $data;
}
public function add_company(){
$data['name'] = $_POST['name'];
$data['phone'] = $_POST['phone'];
$id = $this->database->insert(DB_PREFIX.'company',$data);
if($id>0){
ajax::success(true);
}else{
echo '{"fail":"Ошибка добавления предприятия!"}';
exit;
}
//header('Location:'.URL.'admin/roles' );
}
public function del_company($id=0){
$change_role = false;
if($id==0)return;
$data['deleted'] = '1';
$rowcount = $this->database->update(DB_PREFIX.'company',$data,"id={$id}");
if($rowcount>0){
header('Location:'.URL.'reference/bills' );
}else{
echo '{"fail":"Ошибка удаления предприятия!"}';
exit;
}
}
public function save_company($id=0){
if($id==0)return;
$data['name'] = $_POST['name'];
$data['phone'] = $_POST['phone'];
$rowcount = $this->database->update('company',$data,"id={$id}");
if($rowcount>0){
ajax::success(true);
}else{
echo '{"fail":"Ошибка сохранения предприятия!"}';
exit;
}
}
// COMPANY PERMISSIONS >>>
public function save_company_order_type($company_id,$order_type_id,$checked){
$change_perm = false;
if($company_id==0||$order_type_id==0)return;
$data['company_id'] = $company_id;
$data['order_type_id'] = $order_type_id;
//$data['checked'] = $checked;
$rowcount = $this->database->query("DELETE FROM company_order_types WHERE company_id={$company_id} AND order_type_id={$order_type_id}");
if($checked==1){
$id = $this->database->insert('company_order_types',$data);
}
echo $company_id.' '.$order_type_id.' '.$checked;exit;
header('Location:'.URL.'reference/company/id/'+$company_id );
}
// COMPANY <<<
// BILLS <<<
public function getAllBills(){
try{
$sth = $this->database->prepare("SELECT r.*,c.name as currency,co.name as company
FROM `bills` r
LEFT JOIN `currency` c ON c.id=r.currency_id
LEFT JOIN `company` co ON co.id=r.company_id
WHERE r.`deleted`='0'");
$sth->execute();
$data = $sth->fetchAll(PDO::FETCH_ASSOC);
}catch(PDOException $e){
//echo $e->getMessage();exit;
return $e->getMessage();
}
//var_export($data);exit;
return $data;
}
public function getBills(){
try{
$superuser = (session::get('selected_login_id')>0)?' AND ub.user_id='.session::get('selected_login_id').' ':' ';
$sth=$this->database->prepare("SELECT b.*, cu.name as currency, co.name as company
FROM user_bills ub
INNER JOIN bills b ON ub.bill_id=b.id
INNER JOIN currency cu ON cu.id=b.currency_id
LEFT JOIN company co ON co.id=b.company_id
WHERE b.deleted='0' ".$superuser);
$sth->execute();
$data = $sth->fetchAll(PDO::FETCH_ASSOC);
}catch(PDOException $e){
//echo $e->getMessage();exit;
return $e->getMessage();
}
//var_export($data);exit;
return $data;
}
public function getBill($id=0){
if($id==0)return;
try{
$sth = $this->database->prepare("SELECT r.*,c.name as currency
FROM `bills` r
LEFT JOIN `currency` c ON c.id=r.currency_id
WHERE r.id='".$id."' AND r.`deleted`='0' ");
$sth->execute();
$data = $sth->fetchAll(PDO::FETCH_ASSOC);
}catch(PDOException $e){
//echo $e->getMessage();exit;
return $e->getMessage();
}
//var_export($data);exit;
return $data[0];
}
public function add_bill(){
$user_id = session::get('id_user');
$data['name'] = $_POST['name'];
$data['currency_id'] = $_POST['currency_id'];
$data['company_id'] = $_POST['company_id'];
$data['balance'] = $_POST['balance'];
$data['start_balance'] = $_POST['balance'];
$data['owner_user_id'] = $user_id;
$id = $this->database->insert(DB_PREFIX.'bills',$data);
if($id>0){
$u_bills['user_id'] = $user_id;
$u_bills['bill_id'] = $id;
$id = $this->database->insert(DB_PREFIX.'user_bills',$u_bills);
ajax::success(true);
}else{
echo '{"fail":"Ошибка сохранения счёта!"}';
exit;
}
//header('Location:'.URL.'admin/roles' );
}
public function del_bill($id=0){
$change_role = false;
if($id==0)exit;
$data['deleted'] = '1';
//header('Location:'.URL.'reference/bills' );
$rowcount = $this->database->update(DB_PREFIX.'bills',$data,"id={$id} AND balance=0");
//if($rowcount>0){
if(true){
header('Location:'.URL.'reference/bills' );
}else{
$json['fail'] = 'Ошибка удаления счёта!';
echo $this->json_encode__($json);
exit;
}
}
public function save_bill($id=0){
if($id==0)return;
$bill_before = $this->getBill($id);
$balance_start_before = $bill_before['start_balance'];
$balance_before = $bill_before['balance'];
$data['name'] = $_POST['name'];
$data['company_id'] = $_POST['company_id'];
$data['balance'] = $balance_before+($_POST['start_balance']-$balance_start_before);
$data['start_balance'] = $_POST['start_balance'];
$rowcount = $this->database->update('bills',$data,"id={$id}");
if($rowcount>0){
ajax::success(true);
}else{
echo '{"fail":"Ошибка сохранения счёта!"}';
exit;
}
}
// BILLS <<<
// CONTRACTOR >>>
public function getContractors(){
try{
$sth = $this->database->prepare("SELECT r.*, o.contractor_id
FROM `contractor` r
LEFT JOIN `orders` o ON o.contractor_id = r.id
WHERE r.`deleted`='0'
GROUP BY r.id
ORDER BY r.`type`");
$sth->execute();
$data = $sth->fetchAll(PDO::FETCH_ASSOC);
}catch(PDOException $e){
//echo $e->getMessage();exit;
return $e->getMessage();
}
//var_export($data);exit;
return $data;
}
public function getСontractor($id=0){
if($id==0)return;
try{
$sth = $this->database->prepare("SELECT r.*
FROM `contractor` r
WHERE r.id='".$id."' AND r.`deleted`='0' ");
$sth->execute();
$data = $sth->fetchAll(PDO::FETCH_ASSOC);
}catch(PDOException $e){
//echo $e->getMessage();exit;
return $e->getMessage();
}
//var_export($data);exit;
return $data[0];
}
public function add_contractor(){
$data['name'] = $_POST['name'];
$data['type'] = $_POST['type'];
$data['phone'] = $_POST['phone'];
$data['email'] = isset($_POST['email'])?$_POST['email']:'';
$id = $this->database->insert('contractor',$data);
if($id>0){
ajax::success(true);
}else{
echo '{"fail":"Ошибка сохранения контрагента!"}';
exit;
}
//header('Location:'.URL.'admin/roles' );
}
public function del_contractor($id=0){
$change_role = false;
if($id==0)return;
$data['deleted'] = '1';
$rowcount = $this->database->update('contractor',$data,"id={$id}");
if($rowcount>0){
header('Location:'.URL.'reference/contractors' );
}else{
echo '{"fail":"Ошибка удаления контрагента!"}';
exit;
}
}
public function save_contractor($id=0){
if($id==0)return;
$data['name'] = $_POST['name'];
$data['type'] = $_POST['type'];
$data['phone'] = $_POST['phone'];
$data['email'] = $_POST['email'];
$rowcount = $this->database->update('contractor',$data,"id={$id}");
if($rowcount>0){
ajax::success(true);
}else{
echo '{"fail":"Ошибка сохранения контрагента!"}';
exit;
}
}
// CONTRACTOR <<<
// ORDER TYPES >>>
// PERMISSIONS >>>
public function save_company_contractor($company_id,$contractor_id,$checked){
$change_perm = false;
if($company_id==0||$contractor_id==0)return;
$data['contractor_id'] = $contractor_id;
$data['company_id'] = $company_id;
//$data['checked'] = $checked;
$rowcount = $this->database->query("DELETE FROM company_contractor WHERE company_id={$company_id} AND contractor_id={$contractor_id}");
if($checked==1){
$id = $this->database->insert('company_contractor',$data);
}
echo $company_id.' '.$contractor_id.' '.$checked;exit;
header('Location:'.URL.'reference/company/id/'+$company_id);
}
public function getAllOrderTypes(){
session::set('timeout',time());
try{
$sth = $this->database->prepare("SELECT r.*
FROM `order_types` r
WHERE r.`deleted`='0'
ORDER BY r.incoming DESC");
$sth->execute();
$data = $sth->fetchAll(PDO::FETCH_ASSOC);
}catch(PDOException $e){
//echo $e->getMessage();exit;
return $e->getMessage();
}
//var_export($data);exit;
return $data;
}
public function getOrderTypes(){
session::set('timeout',time());
try{
$sth = $this->database->prepare("SELECT r.*,o.order_type_id
FROM `order_types` r
LEFT JOIN `orders` o ON o.order_type_id = r.id
WHERE r.`deleted`='0'
GROUP BY r.id
ORDER BY r.incoming DESC");
$sth->execute();
$data = $sth->fetchAll(PDO::FETCH_ASSOC);
}catch(PDOException $e){
//echo $e->getMessage();exit;
return $e->getMessage();
}
//var_export($data);exit;
return $data;
}
public function getOrderType($id=0){
if($id==0)return;
try{
$sth = $this->database->prepare("SELECT r.*
FROM `order_types` r
WHERE r.id='".$id."' AND r.`deleted`='0' ");
$sth->execute();
$data = $sth->fetchAll(PDO::FETCH_ASSOC);
}catch(PDOException $e){
//echo $e->getMessage();exit;
return $e->getMessage();
}
//var_export($data);exit;
return $data[0];
}
public function add_order_type(){
$data['name'] = $_POST['name'];
$data['incoming'] = $_POST['incoming'];
$data['type'] = $_POST['type'];
$data['owner_id'] = $_POST['owner_id'];
$id = $this->database->insert('order_types',$data);
if($id>0){
ajax::success(true);
}else{
echo '{"fail":"Ошибка сохранения типа ордера!"}';
exit;
}
//header('Location:'.URL.'admin/roles' );
}
public function del_order_type($id=0){
$change_role = false;
if($id==0)return;
$data['deleted'] = '1';
$rowcount = $this->database->update('order_types',$data,"id={$id}");
if($rowcount>0){
header('Location:'.URL.'reference/order_types' );
}else{
echo '{"fail":"Ошибка удаления типа ордера!"}';
exit;
}
}
public function save_order_type($id=0){
if($id==0)return;
$data['name'] = $_POST['name'];
$data['incoming'] = $_POST['incoming'];
$data['type'] = $_POST['type'];
$data['owner_id'] = $_POST['owner_id'];
$rowcount = $this->database->update('order_types',$data,"id={$id}");
if($rowcount>0){
ajax::success(true);
}else{
echo '{"fail":"Ошибка сохранения типа ордера!"}';
exit;
}
}
// ORDER TYPES <<<
// CURRENCY >>>
public function getCurrencys(){
try{
$sth = $this->database->prepare("SELECT r.*
FROM `currency` r
WHERE r.`deleted`='0' ");
$sth->execute();
$data = $sth->fetchAll(PDO::FETCH_ASSOC);
}catch(PDOException $e){
//echo $e->getMessage();exit;
return $e->getMessage();
}
//var_export($data);exit;
return $data;
}
public function getCurrency($id=0){
if($id==0)return;
try{
$sth = $this->database->prepare("SELECT r.*
FROM `currency` r
WHERE r.id='".$id."' AND r.`deleted`='0' ");
$sth->execute();
$data = $sth->fetchAll(PDO::FETCH_ASSOC);
}catch(PDOException $e){
//echo $e->getMessage();exit;
return $e->getMessage();
}
//var_export($data);exit;
return $data[0];
}
public function add_currency(){
$data['name'] = $_POST['name'];
$data['code'] = $_POST['code'];
$id = $this->database->insert('currency',$data);
if($id>0){
ajax::success(true);
}else{
echo '{"fail":"Ошибка сохранения валюты!"}';
exit;
}
//header('Location:'.URL.'admin/roles' );
}
public function del_currency($id=0){
$change_role = false;
if($id==0)return;
$data['deleted'] = '1';
$rowcount = $this->database->update('currency',$data,"id={$id}");
if($rowcount>0){
header('Location:'.URL.'reference/currencys' );
}else{
echo '{"fail":"Ошибка удаления валюты!"}';
exit;
}
}
public function save_currency($id=0){
if($id==0)return;
$data['name'] = $_POST['name'];
$data['code'] = $_POST['code'];
$rowcount = $this->database->update('currency',$data,"id={$id}");
if($rowcount>0){
ajax::success(true);
}else{
echo '{"fail":"Ошибка сохранения валюты!"}';
exit;
}
}
// CURRENCY <<<
}
?>