What's new

Closed Mga master ano po ang pwede pamalit sa delete kapag gagawa ka ng information system.

Status
Not open for further replies.

DARKWING10

Eternal Poster
Joined
Jan 10, 2016
Posts
1,171
Reaction
315
Points
403
Age
34
Mgas master kasi Ang System namin ay Student Profiling Information Sytem In Guidance Office. Sa bale may nag suggest sa amin na alisin namin yung delete optiom, para maiwasan mawala yung buong student information. Kaya naman namin nilagyan ng delete button kasi. baka mamaya may mali silang lagay na student. Pero madalang naman mangyari yun,
 
Replace Delete with edit if you don't have one. para di mabura lahat ng info ng student. mapipili nyo lang kung ano ang babaguhin
 
replace with edit. but hindi naman basta basta ma dedelete yun.. lagyan nyu lang ng message pag napindot yung delete kunwari do you want do delete Yes or NO yun lang naman...
 
Or lagyan mo ng status attribute yung student.
i.e.
Kung valid yung records:
studentA.status = 'valid'

Kung invalid
studentB.status = 'forfeited'
 
Or lagyan mo ng status attribute yung student.
i.e.
Kung valid yung records:
studentA.status = 'valid'

Kung invalid
studentB.status = 'forfeited'

master pano po yung sa istura nya pag sinubukas i-search yung naka forfeited na status na student? lalagyan ko na lang po ba ng flag?
 
Ang idea, hindi na makikita nung Regular User (teacher or registrar) yung record nung mga students na may 'forfeited' flag. (So parang may pseudo delete ka)
kumbaga "select * from students where status != 'forfeited'".
Yung makakakita lang ay yung Admin o System Level User.
 
Ang idea, hindi na makikita nung Regular User (teacher or registrar) yung record nung mga students na may 'forfeited' flag. (So parang may pseudo delete ka)
kumbaga "select * from students where status != 'forfeited'".
Yung makakakita lang ay yung Admin o System Level User.
Salamat po. Yung query po ba na yan pwede ko din gamitin sa search. para yung may forfieted eh di nya pwede makita. yung mga regular users. bale ang madadagdag sa query ko ay ganito? AND status != 'forfeited'"
 
You have to add it also sa search query mo sir para di sya makita. It is called "soft delete" although other approach uses "del_flg" or "is_deleted" (deleted flag) or alike instead of "status" (if every na may iba kang paggagamitan ng status field) but the purpose is exactly the same (limiting the results to only available students [excluded the deleted ones])
 
As per suggested ng iba sa taas... pagclick po ng button magrun ka ng UPDATE QUERY.

UPDATE [table_name] SET del_flg = 1 WHERE [primary_key] = <primary_key> -----> kung Delete ang ilog mo po kung sino ang nagdelete na user.

then refresh mo yun table kung nakatable.

SELECT * FROM [table_name] WHERE del_flg = 0; since 1=deleted yung record.

Then kung may maling entry lang naman po better kung EDIT record nalang.... :)
 
Last edited by a moderator:
Don't remove the delete function nung system. Actually yung problem mo is more of a UX problem. Ang iniiwasan lang naman nila is to prevent accidental deletion of a student. To prevent such, this should come as standard na rin, is to give more friction bago maperform yung certain function, like here yung delete. What you can do is to add a confirmation dialog para sa initial na friction. Next siguro is gumawa ka ng parang `recycle bin` ng pagdedelete. Magseserve yun as an additional friction kung sakaling nagkaroon ng "accidental" deletion.
 
Hi po, Pwede po bang mag patulong ng THESIS TITLE ? I'm an BSIT Student po. need lang po for Title defense. Salamat
 
Na-encounter ko din yan, ang gusto nman nila ay kung pwede mai-recover yung deleted data.

Yun ang ginawa ko, instead na delete yung data. Move to other table ang ginawa ko. Yung other table ay auto-delete after 3 months. So within 3months pwede pa ma-recover yung deleted data.
 
MeschelleB, pwede ka siguro magbigay ng requirements sa thesis title mo?

DARKWING10, kelangan mo pa ng suggestion sa system o hindi na?
Hi po, In my case po, Naghahanap po ako ngayon ng idea for thesis tirle na pwede kon ma i-propose. Katulad ng Cemetery Mapping,Payroll system, Sales Inventory, Hotel reservations, Landslide Detection sytem, Maping and Routing System, Automatic Bus Fare system. Pero po sabi ni sir meron na po nyan at very common, Kaya naghahanap po ako ngayon ng Bago at mapakinabangan. hehehe Salamat po. Baka may ma suggest kayo na title sakin.
 
Pwede ding lagyan niyo ng parang recycle bin na kung saan mapupunta yung mga ma-dedelete at pwedeng mabalik gamit ang undo button..
Mas okay din yung edit/update
 
Status
Not open for further replies.
Back
Top