How manage flag field in an associative table with hasManyCheckBox?

[blastiko]

Hi all

This is the scenario
Table "students", table "masterlocations" and associative table "studentmasterlocations": one student can partecipate at one o more master on specific location and obsiouly one location can hospitate one o more students.

Tables:

CREATE TABLE students(idINT(11) NOT NULL AUTO_INCREMENT,firstnameVARCHAR(250) NOT NULL COLLATE 'utf8_general_ci',lastnameVARCHAR(250) NOT NULL COLLATE 'utf8_general_ci',createdatDATETIME NULL DEFAULT NULL,updatedatDATETIME NULL DEFAULT NULL,deletedat DATETIME NULL DEFAULT NULL, PRIMARY KEY (id) USING BTREE, ) COLLATE='utf8_general_ci' ENGINE=InnoDB AUTO_INCREMENT=46 ;

CREATE TABLE studentmasterlocations(studentidINT(11) NOT NULL,masterlocationidINT(11) NOT NULL,tutorTINYINT(1) UNSIGNED NOT NULL DEFAULT '0',createdatDATETIME NULL DEFAULT NULL,updatedatDATETIME NULL DEFAULT NULL,deletedat DATETIME NULL DEFAULT NULL, PRIMARY KEY (studentid, masterlocationid) USING BTREE, INDEX fk_studentsmasters_students1_idx (studentid) USING BTREE, INDEX fk_studentsmasters_masters1_idx (masterlocationid) USING BTREE, CONSTRAINT fk_studentsmasters_masters1 FOREIGN KEY (masterlocationid) REFERENCES masterlocations (id) ON UPDATE CASCADE ON DELETE CASCADE, CONSTRAINT fk_studentsmasters_students1 FOREIGN KEY (studentid) REFERENCES students (id) ON UPDATE CASCADE ON DELETE CASCADE ) COLLATE='utf8_general_ci' ENGINE=InnoDB ;

CREATE TABLE masterlocations(idINT(11) NOT NULL AUTO_INCREMENT,nameVARCHAR(250) NULL DEFAULT NULL COLLATE 'utf8_general_ci',createdatDATETIME NULL DEFAULT NULL,updatedatDATETIME NULL DEFAULT NULL,deletedat DATETIME NULL DEFAULT NULL, PRIMARY KEY (id) USING BTREE) COLLATE='utf8_general_ci' ENGINE=InnoDB AUTO_INCREMENT=1 ;

Those are the models

Student.cfc
component extends="Model" { function config() { hasMany(name = "studentmasterlocations"); nestedProperties(associations="studentmasterlocations", allowDelete=true); }

Studentmasterlocation.cfc
component extends="Model" { function config() { belongsTo(name = "student"); belongsTo(name = "masterlocation"); } }

Masterlocation.cfc
component extends="Model" { function config() { hasMany(name = "studentmasterlocations"); } }

In the html form:
...
#hasManyCheckBox(objectName = "student", association = "studentmasterlocations", keys = "#student.key()#,#masterlocations.id#", label=" #masterlocations.locationname#")#
...

All this code works fine: create, edit, update, ecc, without extra code.
Example code in controller Students.cfc -> edit():
student=model("student").findByKey(key=params.key, include="studentmasterlocations") masterlocations=model("masterlocation").FindAll(order="name");

The "problem" is that i don't know how to manage field flag "tutor" on table "studentmasterlocations".
Must i manual manage this flag?
And if yes, how?

Thank

[blastiko]

Ok, i resolved with this code.

In Students.cfc (controller), edit() method:
student=model("student").findByKey(key=params.key, include="studentmasterlocations"); studentmasterlocations=model("studentmasterlocation").findAll(where="studentid=#student.id#"); masterlocations=model("masterlocation").FindAll(order="name", include="master,location");

and in html:
<cfloop query="masterlocations" > <cfif (master_id neq masterlocations.masterid)> <cfif (master_id neq 0)> #includePartial(partial = "partial_student_master_accordion_part2")# </cfif> #includePartial(partial = "partial_student_master_accordion_part1")# <cfset master_id = masterlocations.masterid> </cfif> <cfif (master_id eq masterlocations.masterid)> #hasManyCheckBox(objectName = "student", association = "studentmasterlocations", keys = "#student.key()#,#masterlocations.id#", label="&nbsp;#masterlocations.locationname#")# <cfset tutorfound = false> <cfloop query="studentmasterlocations"> <cfif (masterlocations.id eq studentmasterlocations.masterlocationid)> #checkBox(objectName = "student", property = "tutor", association = "studentmasterlocations", position=studentmasterlocations.currentRow, label="tutor")# <cfset tutorfound = true> <cfbreak> </cfif> </cfloop> <cfif (not tutorfound)> #checkBoxTag(id="student-studentmasterlocations-#student.key()#-#masterlocations.id#-tutor", name = "student[studentmasterlocations][#student.key()#,#masterlocations.id#][tutor]", uncheckedValue = "0", label="tutor")# </cfif> </cfif> </cfloop>

My question now is: is there a more elegant solution (using some framework's function, that i ignore) or the above is the most acceptable solution?