php - Display multiple rows as one in MySQL -


I want some advice

I have created a web app where a user can assign multiple forms The recipients simultaneously insert multiple rows (one line per recipient) in a work form_assignments such that the table is like so: 

  foreach (as the $ line $ Recipients) {$ query = "insert in form_assignments (SENDER_ID, recipient_id, form_id, DUE_DATE, priority_id, comment, completion) values ​​('{ $ {SENDER_ID} ','. $ Line ['id']. ", '{$ Assign_form_id}', '2014 -04-30 00:00:00', '{$ priority_ID}', '{$ comment}' In the above example,  $ recipient  is an array containing  $ row ['id'], '{$ completed}');   
  
 Therefore, an assignment can generate these 100 rows (for 100 recipients), for example, and each recipient of "complete" Can edit your personal line in the form it is now Far better.  
 The problem is, if I want to generate a list of assignments for that user, then I should see only one row for the multi-user assignment (not one line  
 I like to be able to show a table to the user:  
  You have been assigned: Form 1: 50 Users Reason: April 25, 2014 User Full: 10 See User List < / Em>  
 and assign each group to one The account will appear:  
  User 1 has given you the following form: Due to Form 1: April 25, 2014, click to mark as complete   < p> I do not know about this, how to know about it, if someone can point me in the right direction, then I appreciate it.   
 
 
 If I understand you correctly, you want to present the assigning person For the result of each assignment / date grouped by a list of assignments, assignment and date, you also want to show how many users have already completed the assignment rights.  
 So you want to select from the assignment and your result will be  sender_id ,  form_id  and  DUE_DATE  first:  
  select SENDER_ID, form_id, GroupedAssignments group groupedAssignments.sender_id, groupedAssignments.form_id, groupedAssignments.due_date from task as   
 Now you want < Code> JOIN  How many students have already ended this assignment to find out the given task. This is the reason why I added the nickname 'Group Assetment' to join a  join  since your    
  as the finishedAssignments function JOIN (groupedAssignments.sender_id = finishedAssignments.sender_id and groupedAssignments.form_id = finishedAssignments .form_id and groupedAssignments.due_date = finishedAssignments.due_date and finishedAssignments.completed = TRUE)   
 You can add a calculation to:  
  Select group group as swagames.adder_id, groupedsignments.form_id, group Assessment. Add assignments as tasks completed in the form of groups that were grouped in the form of data (COUNT), finished as Assassinated (Sponsored Assignment), (Grouped Permissions.ender_id = Expirations.Company_ID and Grouped Assignments.form_id = finishedAssignments. Form_id and grouped assignment.data_data = expired asset.data and endassment.plotted = TRUE) Assignments finished by group. Sheanda_ID, Finnish Assetments.form_id, FinishesSig Nments.due_date   
 Obviously I did not do this test and it will not work for you, but it should take you in the right direction. Read more on

Comments

Post a Comment

Popular posts from this blog

Java - Error: no suitable method found for add(int, java.lang.String) -

I'm in the middle of homework work and I'm stuck. At this point in my code, I think that I should have a GUI window that opens and allows me to type "inserted text number". Notice is not going anywhere but at this point, If I pass through the problem then it will be in a linked list. I am getting two of the same error for the lines. Add (index, element); And I can not seem to get past it, there is no suitable method for the error "add (int, java. string string)". Code is below, please advise. To clarify - this will not be a method error because it is a linked list. There should not be any way involved. import java.awt. *; Import java.awt.event. *; Import javax.swing. *; Import java.util. *; Import java.util.Scanner; Import java.util.LinkedList; Public class TopTenList JFrame {Private TopTenList tt; See the Private JTextArea list; Private JTextField cmdTextField; Private JTextField resultsTestfield; // This GUI window is the code for the public toptist...
Read more

java - JPA TypedQuery: Parameter value element did not match expected type -

I am using JPA 2.0 and getting the following code in the DAO layer: Public Zero Test () {string key = "status"; String [] Conditions = {"A", "B"}; & Lt; TestTable & gt; Results = Search (Keys, Conditions); } Public listing & lt; TestTable & gt; Search (string key, object value error) {string sql = "test ndf to testlet and jade nand." + Key + "in:" + key; TypedQuery & LT; TestTable & gt; Query = entityManager.createQuery (SQL, TestTable.class); Query.setParameter (key, Arrays.asList (valueArr)) / *** Error Line *** Return query.getResultList (); } In the above error line, it throws the following exception: java.lang.IllegalArgumentException: parameter value element [[Ljava.lang.String; @ cbe5bc] did not match the expected type [java.lang.String] Why is this expected type string while actually this string []? Please help! Note: This is derived from the normal routine and is a simplified code. I can no...
Read more

c++ - static template member variable has internal linkage but is not defined -

Yes, I know, there is a question with almost the same title, but it refers to a different situation. Error message) In my case, I have a .cpp file with a big named designation name (implementation details). There is a property class template with a static data member in that name space, which I need to access from outside the unknown namespace. I give it a little bit of meat: file.hpp namespace Bar {template & lt; Typename A & gt; Struct foo {static_assert (is_same & lt; a, float & gt; :: value} is_same & lt; a, double>: value, ""); Fixed zero set_static_var (a const & x); // ...}; } and file.cpp namespace {template & lt; Typename A & gt; Struct foo_traits {// supports the implementation of several static code bars: foo & lt; & Gt; Fixed A data; }; The template's & lt; & Gt; Float foo_traits & lt; Float & gt; :: datum; // No change if this is in the global namespace template & lt; & Gt; Doub...
Read more