public function getdata($sku, $c_id)
{
$response = array();
$companyproducts = EeCompanyProduct::find()->joinWith(array('c' => function ($q) {
$q->from('ee_company ec');
}))->joinWith(array('product'))->where('sku = :abc AND ec.c_id = :cid', array(':abc' => $sku, ':cid' => $c_id))->limit(10)->all();
if ($companyproducts) {
$bills = EeCompanyBillDetails::find()->joinWith(array('companyBill' => function ($q) {
$q->from('ee_company_bills');
}))->joinWith('eeReturnHistories')->where('merchant_c_id = :cid AND product_id = :pi AND inventory_status_id IN (1,6)', array(':cid' => $companyproducts[0]->c_id, ':pi' => $companyproducts[0]['product_id']))->all();
if ($bills) {
$response['Available_Inventory'] = count($bills);
$response['Company'] = $companyproducts[0]->c['companyname'];
$response['Product Model'] = $companyproducts[0]->product['model_no'];
$response['Product Description'] = $companyproducts[0]->product['description'];
$response['Product MRP'] = $companyproducts[0]->product['mrp'];
$response['Bill Id'] = $bills;
$response['CP'] = $companyproducts[0];
$response['Product'] = $companyproducts[0]->product;
} else {
$response['Available_Inventory'] = 0;
$response['Company'] = $companyproducts[0]->c['companyname'];
$response['Product Model'] = $companyproducts[0]->product['model_no'];
$response['Product Description'] = $companyproducts[0]->product['description'];
$response['Product MRP'] = $companyproducts[0]->product['mrp'];
$response['CP'] = $companyproducts[0];
$response['Product'] = $companyproducts[0]->product;
}
} else {
$response['Error'] = 'No product found';
}
return $response;
}
/**
* @return \yii\db\ActiveQuery
*/
public function getEeCompanyProducts()
{
return $this->hasMany(EeCompanyProduct::className(), ['product_id' => 'id']);
}
/**
* @return \yii\db\ActiveQuery
*/
public function getCompanyProduct()
{
return $this->hasOne(EeCompanyProduct::className(), ['id' => 'company_product_id']);
}
