OpenACS

gustafn
committed
oacs-5-10:gustafn:20221024085439
on 24 Oct 22
added URN for accessability, minor cleanup
/tcl/dotlrn-homework-procs.xql (+6 -6)
18 18    </querytext>
19 19 </fullquery>
20 20
21 21  
22 22 <fullquery name="dotlrn_homework::new.fs_content_size">     
23 23    <querytext>
24 24      
25 25      update cr_revisions
26 26      set content = :tmp_filename,
27 27        content_length = :tmp_size
28 28      where revision_id = :revision_id
29 29            
30 30    </querytext>
31 31 </fullquery>
32 32
33 33  
34 34 <fullquery name="dotlrn_homework::send_homework_alerts.get_alert_info">     
35 35    <querytext>
36 36      
37 37      select f.name, folder.label as folder_name,
38          u.first_names || ' ' || u.last_name as student_name
39        from cr_items f, cr_folders folder, cc_users u, acs_objects o
  38        p.first_names || ' ' || p.last_name as student_name
  39      from cr_items f, cr_folders folder, persons p, acs_objects o
40 40      where f.item_id = :file_id
41 41        and o.object_id = :file_id
42 42        and folder.folder_id = :folder_id
43          and u.user_id = o.creation_user
  43        and p.person_id = o.creation_user
44 44
45 45    </querytext>
46 46 </fullquery>
47 47
48 48  
49 49 <fullquery name="dotlrn_homework::send_correction_alerts.get_alert_info">     
50 50    <querytext>
51 51      
52 52      select f.name, folder.label as folder_name,
53          u.first_names || ' ' || u.last_name as admin_name
54        from cr_items f, cr_folders folder, cc_users u
  53        p.first_names || ' ' || p.last_name as admin_name
  54      from cr_items f, cr_folders folder, persons p
55 55      where item_id = :homework_file_id
56 56        and folder.folder_id = :folder_id
57          and u.user_id = :user_id
  57        and p.person_id = :user_id
58 58
59 59    </querytext>
60 60 </fullquery>
61 61  
62 62 </queryset>