def inventory_list(self):
products = Product.find_by_vendor(self.request.ctx.user.vendor) if self.request.ctx.user and self.request.ctx.user.is_vendor_user() else Product.find_all(self.enterprise_id) #pylint: disable-msg=E1120
campaigns = Campaign.find_all(self.enterprise_id)
response = {
'page': 1,
'total': 1,
'records': len(products)}
rows = []
for prod in products:
#log.debug('%s %s/%s' % (p.product_id, i+1, len(products)))
# blank spot at the beginning of the row is to make room for the
# action buttons. don't remove it.
cells = ['', unicode(prod.product_id),
util.nvl(prod.name),
util.nvl(prod.sku),
util.nvl(prod.manufacturer),
util.nvl(unicode(prod.inventory)),
util.nvl(unicode(prod.inventory_par)),
util.nvl(unicode(prod.unit_cost))]
# the column ordering in the UI is dependant on the order of the
# campaigns that comes back from Campaign.find_all(). We use the
# same ordering here so we are fine not adding some campaign ID here.
for camp in campaigns:
cells.append(util.nvl(util.money(prod.get_retail_price(camp))))
rows.append({'id': str(prod.product_id),
'cell': cells})
response['rows'] = rows
return json.dumps(response)
def test_site_alternate_campaign(self):
ent = Enterprise.find_by_name('Healthy U Store')
cmpns = Campaign.find_all(ent.enterprise_id)
other_campaign = cmpns[1]
R = self.get('/?__cid=%s' % other_campaign.campaign_id)
assert R.status_int == 200
R.mustcontain("campaign_id = %s" % other_campaign.campaign_id)
def _show_prep(self, report_id):
report = Report.load(report_id)
campaigns = products = companies = users = vendors = None
if report.show_campaign_id:
campaigns = util.select_list(Campaign.find_all(self.enterprise_id), 'campaign_id', 'name', True)
if report.show_vendor_id:
vendors = util.select_list(Vendor.find_all(self.enterprise_id), 'vendor_id', 'name', True)
if report.show_company_id:
companies = util.select_list(Company.find_all(self.enterprise_id), 'company_id', 'name', True)
if report.show_user_id:
users = util.select_list(Users.find_all(self.enterprise_id), 'user_id', 'user_id', True)
if report.show_product_id:
products = util.select_list(Product.find_all(self.enterprise_id), 'product_id', 'name', True)
return {
'today' : util.today_date(),
'tomorrow' : util.tomorrow(),
'thirty_ago' : util.today_date() - datetime.timedelta(days=30),
'rpt_end_dt' : self.request.GET.get('rpt_end_dt'),
'rpt_start_dt' : self.request.GET.get('rpt_start_dt'),
'enterprise_id' : self.enterprise_id,
'report' : report,
'campaigns' : campaigns,
'products' : products,
'companies' : companies,
'users' : users,
'vendors' : vendors
}
def _edit_impl(self):
company_id = self.request.matchdict.get('company_id')
comms = []
campaigns = util.select_list(Campaign.find_all(self.enterprise_id), 'campaign_id', 'name')
company = None
if company_id:
company = Company.load(company_id)
comms = util.select_list(Communication.find_all_by_company(company), 'comm_id', 'name')
else:
company = Company()
return {'comms': comms,
'company': company,
'campaigns': campaigns}
def _edit_impl(self):
site_id = self.request.matchdict.get('site_id')
self.session['last_site_id'] = site_id
if site_id:
site = Site.load(site_id)
self.forbid_if(not site or str(site.company.enterprise_id) != str(self.enterprise_id))
else:
site = Site()
return {
'site' : site,
'shipping_methods' : Site.get_shipping_methods(),
'tax_methods' : Site.get_tax_methods(),
'companies' : util.select_list(Company.find_all(self.enterprise_id), 'company_id', 'name'),
'campaigns' : util.select_list(Campaign.find_all(self.enterprise_id), 'campaign_id', 'name')
}
def _edit_impl(self):
customer_id = self.request.matchdict.get('customer_id')
customer = None
if customer_id:
customer = Customer.load(customer_id)
self.forbid_if(not customer or customer.campaign.company.enterprise_id != self.enterprise_id)
self._add_to_recent(customer)
else:
customer = Customer()
customer.campaign = self.request.ctx.site.company.default_campaign
return {
'customer' : customer,
'users' : util.select_list(Users.find_all(self.enterprise_id), 'user_id', ['fname', 'lname'], True),
'phases' : util.select_list(CustomerPhase.find_all(self.enterprise_id), 'phase_id', 'display_name', True),
'campaigns' : util.select_list(Campaign.find_all(self.enterprise_id), 'campaign_id', 'name')
}
def _edit_impl(self):
site_id = self.request.matchdict.get('site_id')
site = Site.load(site_id)
self.forbid_if(not site or str(site.company.enterprise_id) != str(self.enterprise_id))
content_id = self.request.matchdict.get('content_id')
if content_id:
content = Content.load(content_id)
self.forbid_if(not content
or str(content.site.company.enterprise_id) != str(self.enterprise_id)
or str(content.site_id) != str(site_id))
else:
content = Content()
content.site_id = site_id
return {
'site' : site,
'content' : content,
'companies' : util.select_list(Company.find_all(self.enterprise_id), 'company_id', 'name'),
'campaigns' : util.select_list(Campaign.find_all(self.enterprise_id), 'campaign_id', 'name')
}
def _edit_impl(self):
product_id = self.request.matchdict.get('product_id')
campaigns = Campaign.find_all(self.enterprise_id)
companies = util.select_list(Company.find_all(self.enterprise_id), 'company_id', 'name')
product_types = Product.get_types()
vendors = util.select_list(Vendor.find_all(self.enterprise_id), 'vendor_id', 'name', True)
categories = util.select_list(ProductCategory.find_all(self.enterprise_id), 'category_id', 'name', True)
if product_id:
product = Product.load(product_id)
self.forbid_if(not product or product.company.enterprise_id != self.enterprise_id)
product_categories = ProductCategory.find_by_product(product)
else:
product = Product()
product_categories = []
self.forbid_if(self.request.ctx.user.is_vendor_user() and product.product_id and not self.request.ctx.user.vendor_id == product.vendor_id)
children = product.get_children()
other_products = product.find_eligible_children()
non_children = []
for prod in other_products:
found = False
for kid in children:
if kid.child_id == prod.product_id:
found = True
break
if found == False:
non_children.append(prod)
return {
'product' : product,
'campaigns' : campaigns,
'companies' : companies,
'product_types' : product_types,
'vendors' : vendors,
'categories' : categories,
'product_categories' : product_categories,
'children' : children,
'non_children': non_children,
'other_products' : other_products,
'events' : util.select_list(StatusEvent.find_all_applicable(self.enterprise_id, product), 'event_id', 'display_name'),
'is_attribute' : self.request.GET.get('is_attribute') == 'True',
'parent_product' : Product.load(self.request.GET.get('parent_id')) if 'parent_id' in self.request.GET else None
}
def _test_save_inventory(self):
ent = Enterprise.find_by_name('Healthy U Store')
cmpns = Campaign.find_all(ent.enterprise_id)
R = self.get('/crm/product/inventory_list')
assert R.status_int == 200
prods = json.loads(R.body)
self.assertGreater(prods['records'], 100)
self.assertEqual(prods['records'], len(prods['rows']))
# get the first product ID
prod = prods['rows'][1]['cell'] # ['', '1451', '5-HTP 100 mg- Pharmax', 'SUP-1003', 'Seroyal', '123', '8.0', '15.0', '25.00', '', '25.00', '25.00']
pid = prod[1]
name = prod[2]
#sku = prod[3]
#manu = prod[4]
inventory = int(prod[5])
inventory_par = prod[6]
unitcost = prod[7]
R = self.post('/crm/product/save_inventory',
{'id' : pid,
'inventory' : inventory + 10,
'inventory_par' : inventory_par,
'name' : name + ' xxx',
'unit_cost' : unitcost,
'cmp_%s' % cmpns[0].campaign_id : '999',
'cmp_%s' % cmpns[1].campaign_id : ''})
self.assertEquals(R.body, 'True')
prod = Product.load(pid)
tot = InventoryJournal.total(prod)
self.assertEqual(tot, inventory + 10)
self.assertEqual(999, prod.campaign_prices[cmpns[0].campaign_id].retail_price)
self.assertEqual(True, cmpns[1].campaign_id not in prod.campaign_prices.keys())
R = self.get('/crm/product/edit/%s' % pid)
assert R.status_int == 200
f = R.forms['frm_product']
R.mustcontain('Edit Product')
self.assertEqual(f['product_id'].value, pid)
self.assertEqual(f['name'].value, name + ' xxx')
def clear_caches(self):
for camp in Campaign.find_all(self.enterprise_id):
camp.invalidate_caches()
return "ok"
def list(self):
return {'campaigns' : Campaign.find_all(self.enterprise_id)}
def _test_save_existing(self):
ent = Enterprise.find_by_name('Healthy U Store')
cmpns = Campaign.find_all(ent.enterprise_id)
product_id = self._create_new()
R = self.get('/crm/product/list')
assert R.status_int == 200
R.mustcontain('Test Product')
R.mustcontain('Product Search') # make sure product search is in 2 places
R = self.get('/crm/product/edit/%s' % product_id)
R.mustcontain('Edit Product')
f = R.forms['frm_product']
self.assertEqual(f['product_id'].value, product_id)
self.assertEqual(f['name'].value, 'Test Product')
self.assertEqual(f['seo_keywords'].value, 'SEO Test')
f.set('name', 'Test Product New')
f.set('seo_keywords', 'SEO Test New')
for prod in Product.find_all_except(Product.load(product_id))[:3]:
f.set('child_incl_%s' % prod.product_id, prod.product_id)
f.set('child_quantity_%s' % prod.product_id, 2)
f.set('campaign_price[%s]' % cmpns[0].campaign_id, "123")
f.set('campaign_price[%s]' % cmpns[1].campaign_id, None)
f.set('prod_inventory', 25)
#cat = ProductCategory.find_all(ent.enterprise_id)[0]
#f.set('category_id', cat.category_id)
R = f.submit('submit')
self.assertEqual(R.status_int, 302)
R = R.follow()
assert R.status_int == 200
f = R.forms['frm_product']
R.mustcontain('Edit Product')
self.assertEqual(f['product_id'].value, product_id)
self.assertEqual(f['name'].value, 'Test Product New')
self.assertEqual(f['seo_keywords'].value, 'SEO Test New')
self.assertEqual(f['campaign_price[%s]' % cmpns[0].campaign_id].value, "123.00")
self.assertEqual(f['campaign_price[%s]' % cmpns[1].campaign_id].value, "")
#self.assertEqual(f['category_id'].value, cat.category_id)
prod = Product.load(product_id)
self.assertEqual(25, InventoryJournal.total(prod))
for prod in Product.find_all_except(Product.load(product_id))[:3]:
self.assertEqual(int(f['child_quantity_%s' % prod.product_id].value), 2)
#put pricing back.
R = self.get('/crm/product/edit/%s' % product_id)
R.mustcontain('Edit Product')
f = R.forms['frm_product']
self.assertEqual(f['product_id'].value, product_id)
f.set('campaign_price[%s]' % cmpns[0].campaign_id, "123")
f.set('campaign_price[%s]' % cmpns[1].campaign_id, "234")
R = f.submit('submit')
self.assertEqual(R.status_int, 302)
R = R.follow()
assert R.status_int == 200
f = R.forms['frm_product']
R.mustcontain('Edit Product')
self.assertEqual(f['product_id'].value, product_id)
self.assertEqual(f['campaign_price[%s]' % cmpns[1].campaign_id].value, "234.00")
self._delete_new(product_id)
def show_inventory(self):
return {'products' : Product.find_by_vendor(self.enterprise_id, self.request.ctx.user.vendor) \
if self.request.ctx.user.is_vendor_user() else Product.find_inventory_tracked(self.enterprise_id),
'campaigns' : Campaign.find_all(self.enterprise_id)
}
