private function passData($id = null)
{
$HQAddresses = new \App\Models\Addresses();
$HQPhones = new \App\Models\Phones();
$company = new \App\Models\Companies();
$ultimateParentCompany = new \App\Models\Companies();
if (!is_null($id)) {
$company = Companies::findOrNew($id);
$mediaContacts = $company->mediaContacts()->get();
$attachments = $company->attachments()->get();
$ultimateParentCompany = $company->ultimateParent()->get();
} else {
if (!Session::has('MediaContacts')) {
Session::set('MediaContacts', $company->mediaContacts()->get());
}
if (!Session::has('CompanyAttachments')) {
Session::set('CompanyAttachments', $company->attachments()->get());
}
$mediaContacts = Session::get('MediaContacts');
$attachments = Session::get("CompanyAttachments");
}
$eSize = EmployeeSize::all()->toArray();
$gProfile = GrowthProfile::where('id_Growth_Profile', '>', 1)->get()->toArray();
$oship = Ownership::all()->toArray();
$rStage = RevenueStage::where('id_Revenue_Stage', '>', 1)->get()->toArray();
$cType = CompanyType::all()->toArray();
$csType = CompanySubType::all()->toArray();
$uParent = Companies::where("Deleted", "=", NULL)->get()->sortBy('Company_Full_Name')->toArray();
$products = $company->products()->whereNull("Deleted");
foreach ($products->get() as $product) {
$productFocusTypeList[$product->id_Product] = [];
$productTypeList = [];
foreach ($product->focusSubType()->get() as $productSubType) {
$productTypeList[0] = $productSubType->Product_Focus_Sub_Type;
$productTypeListValues = ProductFocusType::where('id_Product_Focus_Type', '=', $productSubType->id_Product_Focus_Type)->get()->first();
$productTypeList[1] = $productTypeListValues->Product_Focus_Type;
$productFocusTypeList[$product->id_Product][] = $productTypeList;
}
}
if ($company->headquaters()->get()->count()) {
$HQAddresses = Addresses::findOrNew($company->headquaters()->get()->first()->AddressId);
}
if ($company->headquaters()->get()->count() && $company->headquaters()->get()->first()->PhoneId) {
$HQPhones = Phones::findOrNew($company->headquaters()->get()->first()->PhoneId);
}
foreach ($eSize as $emSize) {
$employeeSize[$emSize["id_Employee_Size"]] = $emSize["Employee_Size"];
}
foreach ($gProfile as $gwProfile) {
$growthProfile[$gwProfile["id_Growth_Profile"]] = $gwProfile["Growth_Profile"];
}
foreach ($oship as $owship) {
$ownership[$owship["id_Ownership"]] = $owship["Ownership"];
}
foreach ($rStage as $revStage) {
$revenueStage[$revStage["id_Revenue_Stage"]] = $revStage["Revenue_Stage"];
}
foreach ($cType as $coType) {
$companyType[$coType["id_Company_Type"]] = $coType["Company_Type"];
}
foreach ($csType as $coSuType) {
$companySubType[$coSuType["id_Company_Sub_Type"]] = $coSuType["Company_Sub_Type_Name"];
}
foreach ($uParent as $ulParent) {
$ultimateParent[$ulParent["id_Company"]] = $ulParent["Company_Full_Name"];
}
$country = Country::getListCountries();
return compact("employeeSize", "growthProfile", "productFocusTypeList", "ownership", "revenueStage", "companyType", "companySubType", "company", "ultimateParent", "mediaContacts", "country", "HQAddresses", "HQPhones", "products", "attachments", "ultimateParentCompany");
}
private function passData($id = null)
{
$products = new \App\Models\Products();
if (!is_null($id)) {
$products = Products::findOrNew($id);
}
if (!is_null($id)) {
$cProducts = Products::where("id_Product", "!=", $id)->whereNull("Deleted")->orderBy('Product_Title')->get()->toArray();
$attachments = $products->attachments()->get();
$productFocusSubTypeList = $products->focusSubType()->get();
$productCompetitors = $products->competitor()->get();
} else {
$cProducts = Products::whereNull("Deleted")->orderBy('Product_Title')->get()->toArray();
if (!Session::has('ProductAttachments')) {
Session::set('ProductAttachments', $products->attachments()->get());
}
$attachments = Session::get("ProductAttachments");
if (!Session::has('ProductFocusSubType')) {
Session::set('ProductFocusSubType', $products->focusSubType()->get());
}
$productFocusSubTypeList = Session::get("ProductFocusSubType");
if (!Session::has('ProductCompetitors')) {
Session::set('ProductCompetitors', $products->competitor()->get());
}
$productCompetitors = Session::get("ProductCompetitors");
}
//dd($productFocusSubTypeList);
$pFocus = ProductFocus::all();
$pfType = ProductFocusType::where("id_Product_Focus", "=", $products->id_Product_Focus ? $products->id_Product_Focus : 1)->get()->toArray();
$pfsType = ProductFocusSubType::where("id_Product_Focus_Type", "=", $products->id_Product_Focus_Type ? $products->id_Product_Focus_Type : 1)->get()->toArray();
$pPos = Positions::all()->toArray();
$competitorProducts = [];
foreach ($pFocus as $prFocus) {
$productFocus[$prFocus["id_Product_Focus"]] = $prFocus["Product_Focus"];
}
foreach ($pfType as $prfFocus) {
$productFocusType[$prfFocus["id_Product_Focus_Type"]] = $prfFocus["Product_Focus_Type"];
}
foreach ($pfsType as $prfsFocus) {
$productFocusSubType[$prfsFocus["id_Product_Focus_Sub_Type"]] = $prfsFocus["Product_Focus_Sub_Type"];
}
foreach ($cProducts as $cpProducts) {
$competitorProducts[$cpProducts["id_Product"]] = $cpProducts["Product_Title"];
}
foreach ($pPos as $prPos) {
$positions[$prPos["id_Position"]] = $prPos["Position_Name"];
}
$Companies = Companies::SelectOptionsModel();
$TargetEndUser = TargetEndUser::CheckboxesModel();
$TargetMarket = TargetMarket::CheckboxesModel();
$AssetClass = AssetClass::CheckboxesModel();
$AvailabilityTerritory = AvailabilityTerritory::CheckboxesModel();
$TargetEndUserSelection = $products->TargetEndUserSelection();
$TargetMarketSelection = $products->TargetMarketSelection();
$ClassAssetsSelection = $products->ClassAssetsSelection();
$TerritorySelection = $products->TerritorySelection();
return compact("products", "productFocus", "productFocusType", "productFocusSubType", "Companies", "TargetMarket", "TargetEndUser", "AssetClass", "competitorProducts", "AvailabilityTerritory", "positions", "attachments", "TerritorySelection", "TargetEndUserSelection", "TargetMarketSelection", "ClassAssetsSelection", "productFocusSubTypeList", "productCompetitors");
}
public function productFocusType($focus)
{
return ProductFocusType::where("id_Product_Focus", "=", $focus)->get(["id_Product_Focus_Type", "Product_Focus_Type"])->toJson();
}
