Desktop application

Question

mange a product expiry or batch number 1st arrive product first sale using mysql window form need this form

Sachin Singh · Answer

Your Logic should Go Like this (consider 2+ week (15 days atleast) as a marker, if DaysRemaining is less than 15 days then its a warning (yellow)) DaysRemaining= CurrentDate-ExpirayDate If((DaysRemaining-15days)>CurrentDate) set Color to white if((DaysRemaining-15days) Set Color to Red if(DaysRemaining-15days)==CurrentDate) set Color To yellow if(DaysRemaining==CurrentDate) set Color To green This is just Logic you have to follow , try to complete it by yourself , If you stuck then share your code and anyone will help you, but at first try by yourself.

Rajanikant Hawaldar · Answer

Order by expirydate desc. So first in tablets will be displayed on top so medicine store keeper can find the particular in store rack.

Rajanikant Hawaldar · Answer

You want us to develop software for you or your expecting code for this?

zeshan athar · Answer

for example, I add 10 tablets on 20.10.2020 next day add more 10 tablets in stock have different expiry date how they will manage dates according stock

zeshan athar · Answer

my final project medicine store all have done I need mange project expiry dates issue. like this pic show expiry product info

Desktop application

Answers (5)