registration.soap.php 172 KB

1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253545556575859606162636465666768697071727374757677787980818283848586878889909192939495969798991001011021031041051061071081091101111121131141151161171181191201211221231241251261271281291301311321331341351361371381391401411421431441451461471481491501511521531541551561571581591601611621631641651661671681691701711721731741751761771781791801811821831841851861871881891901911921931941951961971981992002012022032042052062072082092102112122132142152162172182192202212222232242252262272282292302312322332342352362372382392402412422432442452462472482492502512522532542552562572582592602612622632642652662672682692702712722732742752762772782792802812822832842852862872882892902912922932942952962972982993003013023033043053063073083093103113123133143153163173183193203213223233243253263273283293303313323333343353363373383393403413423433443453463473483493503513523533543553563573583593603613623633643653663673683693703713723733743753763773783793803813823833843853863873883893903913923933943953963973983994004014024034044054064074084094104114124134144154164174184194204214224234244254264274284294304314324334344354364374384394404414424434444454464474484494504514524534544554564574584594604614624634644654664674684694704714724734744754764774784794804814824834844854864874884894904914924934944954964974984995005015025035045055065075085095105115125135145155165175185195205215225235245255265275285295305315325335345355365375385395405415425435445455465475485495505515525535545555565575585595605615625635645655665675685695705715725735745755765775785795805815825835845855865875885895905915925935945955965975985996006016026036046056066076086096106116126136146156166176186196206216226236246256266276286296306316326336346356366376386396406416426436446456466476486496506516526536546556566576586596606616626636646656666676686696706716726736746756766776786796806816826836846856866876886896906916926936946956966976986997007017027037047057067077087097107117127137147157167177187197207217227237247257267277287297307317327337347357367377387397407417427437447457467477487497507517527537547557567577587597607617627637647657667677687697707717727737747757767777787797807817827837847857867877887897907917927937947957967977987998008018028038048058068078088098108118128138148158168178188198208218228238248258268278288298308318328338348358368378388398408418428438448458468478488498508518528538548558568578588598608618628638648658668678688698708718728738748758768778788798808818828838848858868878888898908918928938948958968978988999009019029039049059069079089099109119129139149159169179189199209219229239249259269279289299309319329339349359369379389399409419429439449459469479489499509519529539549559569579589599609619629639649659669679689699709719729739749759769779789799809819829839849859869879889899909919929939949959969979989991000100110021003100410051006100710081009101010111012101310141015101610171018101910201021102210231024102510261027102810291030103110321033103410351036103710381039104010411042104310441045104610471048104910501051105210531054105510561057105810591060106110621063106410651066106710681069107010711072107310741075107610771078107910801081108210831084108510861087108810891090109110921093109410951096109710981099110011011102110311041105110611071108110911101111111211131114111511161117111811191120112111221123112411251126112711281129113011311132113311341135113611371138113911401141114211431144114511461147114811491150115111521153115411551156115711581159116011611162116311641165116611671168116911701171117211731174117511761177117811791180118111821183118411851186118711881189119011911192119311941195119611971198119912001201120212031204120512061207120812091210121112121213121412151216121712181219122012211222122312241225122612271228122912301231123212331234123512361237123812391240124112421243124412451246124712481249125012511252125312541255125612571258125912601261126212631264126512661267126812691270127112721273127412751276127712781279128012811282128312841285128612871288128912901291129212931294129512961297129812991300130113021303130413051306130713081309131013111312131313141315131613171318131913201321132213231324132513261327132813291330133113321333133413351336133713381339134013411342134313441345134613471348134913501351135213531354135513561357135813591360136113621363136413651366136713681369137013711372137313741375137613771378137913801381138213831384138513861387138813891390139113921393139413951396139713981399140014011402140314041405140614071408140914101411141214131414141514161417141814191420142114221423142414251426142714281429143014311432143314341435143614371438143914401441144214431444144514461447144814491450145114521453145414551456145714581459146014611462146314641465146614671468146914701471147214731474147514761477147814791480148114821483148414851486148714881489149014911492149314941495149614971498149915001501150215031504150515061507150815091510151115121513151415151516151715181519152015211522152315241525152615271528152915301531153215331534153515361537153815391540154115421543154415451546154715481549155015511552155315541555155615571558155915601561156215631564156515661567156815691570157115721573157415751576157715781579158015811582158315841585158615871588158915901591159215931594159515961597159815991600160116021603160416051606160716081609161016111612161316141615161616171618161916201621162216231624162516261627162816291630163116321633163416351636163716381639164016411642164316441645164616471648164916501651165216531654165516561657165816591660166116621663166416651666166716681669167016711672167316741675167616771678167916801681168216831684168516861687168816891690169116921693169416951696169716981699170017011702170317041705170617071708170917101711171217131714171517161717171817191720172117221723172417251726172717281729173017311732173317341735173617371738173917401741174217431744174517461747174817491750175117521753175417551756175717581759176017611762176317641765176617671768176917701771177217731774177517761777177817791780178117821783178417851786178717881789179017911792179317941795179617971798179918001801180218031804180518061807180818091810181118121813181418151816181718181819182018211822182318241825182618271828182918301831183218331834183518361837183818391840184118421843184418451846184718481849185018511852185318541855185618571858185918601861186218631864186518661867186818691870187118721873187418751876187718781879188018811882188318841885188618871888188918901891189218931894189518961897189818991900190119021903190419051906190719081909191019111912191319141915191619171918191919201921192219231924192519261927192819291930193119321933193419351936193719381939194019411942194319441945194619471948194919501951195219531954195519561957195819591960196119621963196419651966196719681969197019711972197319741975197619771978197919801981198219831984198519861987198819891990199119921993199419951996199719981999200020012002200320042005200620072008200920102011201220132014201520162017201820192020202120222023202420252026202720282029203020312032203320342035203620372038203920402041204220432044204520462047204820492050205120522053205420552056205720582059206020612062206320642065206620672068206920702071207220732074207520762077207820792080208120822083208420852086208720882089209020912092209320942095209620972098209921002101210221032104210521062107210821092110211121122113211421152116211721182119212021212122212321242125212621272128212921302131213221332134213521362137213821392140214121422143214421452146214721482149215021512152215321542155215621572158215921602161216221632164216521662167216821692170217121722173217421752176217721782179218021812182218321842185218621872188218921902191219221932194219521962197219821992200220122022203220422052206220722082209221022112212221322142215221622172218221922202221222222232224222522262227222822292230223122322233223422352236223722382239224022412242224322442245224622472248224922502251225222532254225522562257225822592260226122622263226422652266226722682269227022712272227322742275227622772278227922802281228222832284228522862287228822892290229122922293229422952296229722982299230023012302230323042305230623072308230923102311231223132314231523162317231823192320232123222323232423252326232723282329233023312332233323342335233623372338233923402341234223432344234523462347234823492350235123522353235423552356235723582359236023612362236323642365236623672368236923702371237223732374237523762377237823792380238123822383238423852386238723882389239023912392239323942395239623972398239924002401240224032404240524062407240824092410241124122413241424152416241724182419242024212422242324242425242624272428242924302431243224332434243524362437243824392440244124422443244424452446244724482449245024512452245324542455245624572458245924602461246224632464246524662467246824692470247124722473247424752476247724782479248024812482248324842485248624872488248924902491249224932494249524962497249824992500250125022503250425052506250725082509251025112512251325142515251625172518251925202521252225232524252525262527252825292530253125322533253425352536253725382539254025412542254325442545254625472548254925502551255225532554255525562557255825592560256125622563256425652566256725682569257025712572257325742575257625772578257925802581258225832584258525862587258825892590259125922593259425952596259725982599260026012602260326042605260626072608260926102611261226132614261526162617261826192620262126222623262426252626262726282629263026312632263326342635263626372638263926402641264226432644264526462647264826492650265126522653265426552656265726582659266026612662266326642665266626672668266926702671267226732674267526762677267826792680268126822683268426852686268726882689269026912692269326942695269626972698269927002701270227032704270527062707270827092710271127122713271427152716271727182719272027212722272327242725272627272728272927302731273227332734273527362737273827392740274127422743274427452746274727482749275027512752275327542755275627572758275927602761276227632764276527662767276827692770277127722773277427752776277727782779278027812782278327842785278627872788278927902791279227932794279527962797279827992800280128022803280428052806280728082809281028112812281328142815281628172818281928202821282228232824282528262827282828292830283128322833283428352836283728382839284028412842284328442845284628472848284928502851285228532854285528562857285828592860286128622863286428652866286728682869287028712872287328742875287628772878287928802881288228832884288528862887288828892890289128922893289428952896289728982899290029012902290329042905290629072908290929102911291229132914291529162917291829192920292129222923292429252926292729282929293029312932293329342935293629372938293929402941294229432944294529462947294829492950295129522953295429552956295729582959296029612962296329642965296629672968296929702971297229732974297529762977297829792980298129822983298429852986298729882989299029912992299329942995299629972998299930003001300230033004300530063007300830093010301130123013301430153016301730183019302030213022302330243025302630273028302930303031303230333034303530363037303830393040304130423043304430453046304730483049305030513052305330543055305630573058305930603061306230633064306530663067306830693070307130723073307430753076307730783079308030813082308330843085308630873088308930903091309230933094309530963097309830993100310131023103310431053106310731083109311031113112311331143115311631173118311931203121312231233124312531263127312831293130313131323133313431353136313731383139314031413142314331443145314631473148314931503151315231533154315531563157315831593160316131623163316431653166316731683169317031713172317331743175317631773178317931803181318231833184318531863187318831893190319131923193319431953196319731983199320032013202320332043205320632073208320932103211321232133214321532163217321832193220322132223223322432253226322732283229323032313232323332343235323632373238323932403241324232433244324532463247324832493250325132523253325432553256325732583259326032613262326332643265326632673268326932703271327232733274327532763277327832793280328132823283328432853286328732883289329032913292329332943295329632973298329933003301330233033304330533063307330833093310331133123313331433153316331733183319332033213322332333243325332633273328332933303331333233333334333533363337333833393340334133423343334433453346334733483349335033513352335333543355335633573358335933603361336233633364336533663367336833693370337133723373337433753376337733783379338033813382338333843385338633873388338933903391339233933394339533963397339833993400340134023403340434053406340734083409341034113412341334143415341634173418341934203421342234233424342534263427342834293430343134323433343434353436343734383439344034413442344334443445344634473448344934503451345234533454345534563457345834593460346134623463346434653466346734683469347034713472347334743475347634773478347934803481348234833484348534863487348834893490349134923493349434953496349734983499350035013502350335043505350635073508350935103511351235133514351535163517351835193520352135223523352435253526352735283529353035313532353335343535353635373538353935403541354235433544354535463547354835493550355135523553355435553556355735583559356035613562356335643565356635673568356935703571357235733574357535763577357835793580358135823583358435853586358735883589359035913592359335943595359635973598359936003601360236033604360536063607360836093610361136123613361436153616361736183619362036213622362336243625362636273628362936303631363236333634363536363637363836393640364136423643364436453646364736483649365036513652365336543655365636573658365936603661366236633664366536663667366836693670367136723673367436753676367736783679368036813682368336843685368636873688368936903691369236933694369536963697369836993700370137023703370437053706370737083709371037113712371337143715371637173718371937203721372237233724372537263727372837293730373137323733373437353736373737383739374037413742374337443745374637473748374937503751375237533754375537563757375837593760376137623763376437653766376737683769377037713772377337743775377637773778377937803781378237833784378537863787378837893790379137923793379437953796379737983799380038013802380338043805380638073808380938103811381238133814381538163817381838193820382138223823382438253826382738283829383038313832383338343835383638373838383938403841384238433844384538463847384838493850385138523853385438553856385738583859386038613862386338643865386638673868386938703871387238733874387538763877387838793880388138823883388438853886388738883889389038913892389338943895389638973898389939003901390239033904390539063907390839093910391139123913391439153916391739183919392039213922392339243925392639273928392939303931393239333934393539363937393839393940394139423943394439453946394739483949395039513952395339543955395639573958395939603961396239633964396539663967396839693970397139723973397439753976397739783979398039813982398339843985398639873988398939903991399239933994399539963997399839994000400140024003400440054006400740084009401040114012401340144015401640174018401940204021402240234024402540264027402840294030403140324033403440354036403740384039404040414042404340444045404640474048404940504051405240534054405540564057405840594060406140624063406440654066406740684069407040714072407340744075407640774078407940804081408240834084408540864087408840894090409140924093409440954096409740984099410041014102410341044105410641074108410941104111411241134114411541164117411841194120412141224123412441254126412741284129413041314132413341344135413641374138413941404141414241434144414541464147414841494150415141524153415441554156415741584159416041614162416341644165416641674168416941704171417241734174417541764177417841794180418141824183418441854186418741884189419041914192419341944195419641974198419942004201420242034204420542064207420842094210421142124213421442154216421742184219422042214222422342244225422642274228422942304231423242334234423542364237423842394240424142424243424442454246424742484249425042514252425342544255425642574258425942604261426242634264426542664267426842694270427142724273427442754276427742784279428042814282428342844285428642874288428942904291429242934294429542964297429842994300430143024303430443054306430743084309431043114312431343144315431643174318431943204321432243234324432543264327432843294330433143324333433443354336433743384339434043414342434343444345434643474348434943504351435243534354435543564357435843594360436143624363436443654366436743684369437043714372437343744375437643774378437943804381438243834384438543864387438843894390439143924393439443954396439743984399440044014402440344044405440644074408440944104411441244134414441544164417441844194420442144224423442444254426442744284429443044314432443344344435443644374438443944404441444244434444444544464447444844494450445144524453445444554456445744584459446044614462446344644465446644674468446944704471447244734474447544764477447844794480448144824483448444854486448744884489449044914492449344944495449644974498449945004501450245034504450545064507450845094510451145124513451445154516451745184519452045214522452345244525452645274528452945304531453245334534453545364537453845394540454145424543454445454546454745484549455045514552455345544555455645574558455945604561456245634564456545664567456845694570457145724573457445754576457745784579458045814582458345844585458645874588458945904591459245934594459545964597459845994600460146024603460446054606460746084609461046114612461346144615461646174618461946204621462246234624462546264627462846294630463146324633463446354636463746384639464046414642464346444645464646474648464946504651465246534654465546564657465846594660466146624663466446654666466746684669467046714672467346744675467646774678467946804681468246834684468546864687468846894690469146924693469446954696469746984699470047014702470347044705470647074708470947104711471247134714471547164717471847194720472147224723472447254726472747284729473047314732473347344735473647374738473947404741474247434744474547464747474847494750475147524753475447554756475747584759476047614762476347644765476647674768476947704771477247734774477547764777477847794780478147824783
  1. <?php
  2. require ('../inc/global.inc.php');
  3. $libpath = api_get_path(LIBRARY_PATH);
  4. require_once($libpath.'nusoap/nusoap.php');
  5. require_once ($libpath.'fileManage.lib.php');
  6. require_once ($libpath.'usermanager.lib.php');
  7. require_once ($libpath.'fileUpload.lib.php');
  8. require_once(api_get_path(INCLUDE_PATH).'lib/mail.lib.inc.php');
  9. require_once ($libpath.'add_course.lib.inc.php');
  10. require_once($libpath.'course.lib.php');
  11. require_once ($libpath.'sessionmanager.lib.php');
  12. // Create the server instance
  13. $server = new soap_server();
  14. // Initialize WSDL support
  15. $server->configureWSDL('WSRegistration', 'urn:WSRegistration');
  16. /* Register DokeosWSCreateUsers function */
  17. // Register the data structures used by the service
  18. // Prepare input params
  19. $server->wsdl->addComplexType(
  20. 'extras',
  21. 'complexType',
  22. 'struct',
  23. 'all',
  24. '',
  25. array(
  26. 'field_name' => array('name' => 'field_name', 'type' => 'xsd:string'),
  27. 'field_value' => array('name' => 'field_value', 'type' => 'xsd:string')
  28. )
  29. );
  30. $server->wsdl->addComplexType(
  31. 'extrasList',
  32. 'complexType',
  33. 'array',
  34. '',
  35. 'SOAP-ENC:Array',
  36. array(),
  37. array(array('ref'=>'SOAP-ENC:arrayType','wsdl:arrayType' => 'tns:extras[]')),'tns:extras'
  38. );
  39. $server->wsdl->addComplexType(
  40. 'usersParams',
  41. 'complexType',
  42. 'struct',
  43. 'all',
  44. '',
  45. array(
  46. 'firstname' => array('name' => 'firstname', 'type' => 'xsd:string'),
  47. 'lastname' => array('name' => 'lastname', 'type' => 'xsd:string'),
  48. 'status' => array('name' => 'status', 'type' => 'xsd:string'),
  49. 'email' => array('name' => 'email', 'type' => 'xsd:string'),
  50. 'loginname' => array('name' => 'loginname', 'type' => 'xsd:string'),
  51. 'password' => array('name' => 'password', 'type' => 'xsd:string'),
  52. 'language' => array('name' => 'language', 'type' => 'xsd:string'),
  53. 'phone' => array('name' => 'phone', 'type' => 'xsd:string'),
  54. 'expiration_date' => array('name' => 'expiration_date', 'type' => 'xsd:string'),
  55. 'original_user_id_name' => array('name' => 'original_user_id_name', 'type' => 'xsd:string'),
  56. 'original_user_id_value' => array('name' => 'original_user_id_value', 'type' => 'xsd:string'),
  57. 'extra' => array('name' => 'extra', 'type' => 'tns:extrasList')
  58. )
  59. );
  60. $server->wsdl->addComplexType(
  61. 'usersParamsList',
  62. 'complexType',
  63. 'array',
  64. '',
  65. 'SOAP-ENC:Array',
  66. array(),
  67. array(array('ref'=>'SOAP-ENC:arrayType','wsdl:arrayType' => 'tns:usersParams[]')),'tns:usersParams'
  68. );
  69. $server->wsdl->addComplexType(
  70. 'createUsers',
  71. 'complexType',
  72. 'struct',
  73. 'all',
  74. '',
  75. array(
  76. 'users' => array('name' => 'users', 'type' => 'tns:userParamsList'),
  77. 'secret_key' => array('name' => 'secret_key', 'type' => 'xsd:string')
  78. )
  79. );
  80. // Prepare output params, in this case will return an array
  81. $server->wsdl->addComplexType(
  82. 'result_createUsers',
  83. 'complexType',
  84. 'struct',
  85. 'all',
  86. '',
  87. array(
  88. 'original_user_id_value' => array('name' => 'original_user_id_value', 'type' => 'xsd:string'),
  89. 'result' => array('name' => 'result', 'type' => 'xsd:string')
  90. )
  91. );
  92. $server->wsdl->addComplexType(
  93. 'results_createUsers',
  94. 'complexType',
  95. 'array',
  96. '',
  97. 'SOAP-ENC:Array',
  98. array(),
  99. array(array('ref'=>'SOAP-ENC:arrayType','wsdl:arrayType' => 'tns:result_createUsers[]')),'tns:result_createUsers'
  100. );
  101. // Register the method to expose
  102. $server->register('DokeosWSCreateUsers', // method name
  103. array('createUsers' => 'tns:createUsers'), // input parameters
  104. array('return' => 'tns:results_createUsers'), // output parameters
  105. 'urn:WSRegistration', // namespace
  106. 'urn:WSRegistration#DokeosWSCreateUsers', // soapaction
  107. 'rpc', // style
  108. 'encoded', // use
  109. 'This service adds a user' // documentation
  110. );
  111. // Define the method DokeosWSCreateUsers
  112. function DokeosWSCreateUsers($params) {
  113. global $_user, $userPasswordCrypted,$_configuration;
  114. $secret_key = $params['secret_key'];
  115. $security_key = $_SERVER['REMOTE_ADDR'].$_configuration['security_key'];
  116. if (!api_is_valid_secret_key($secret_key,$security_key)) {
  117. return -1; //secret key is incorrect
  118. }
  119. // database table definition
  120. $table_user = Database::get_main_table(TABLE_MAIN_USER);
  121. $t_uf = Database::get_main_table(TABLE_MAIN_USER_FIELD);
  122. $t_ufv = Database::get_main_table(TABLE_MAIN_USER_FIELD_VALUES);
  123. $users_params = $params['users'];
  124. $results = array();
  125. $orig_user_id_value = array();
  126. foreach($users_params as $user_param) {
  127. $firstName = $user_param['firstname']; $lastName = $user_param['lastname'];
  128. $status = $user_param['status']; $email = $user_param['email'];
  129. $loginName = $user_param['loginname']; $password = $user_param['password'];
  130. $official_code = '';$language='';$phone = '';$picture_uri = '';$auth_source = PLATFORM_AUTH_SOURCE;
  131. $expiration_date = '0000-00-00 00:00:00'; $active = 1; $hr_dept_id=0; $extra=null;
  132. $original_user_id_name= $user_param['original_user_id_name'];
  133. $original_user_id_value = $user_param['original_user_id_value'];
  134. $orig_user_id_value[] = $user_param['original_user_id_value'];
  135. $extra_list = $user_param['extra'];
  136. if (!empty($user_param['language'])) { $language=$user_param['language'];}
  137. if (!empty($user_param['phone'])) { $phone = $user_param['phone'];}
  138. if (!empty($user_param['expiration_date'])) { $expiration_date = $user_param['expiration_date'];}
  139. // check if exits x_user_id into user_field_values table
  140. $sql = "SELECT field_value,user_id FROM $t_uf uf,$t_ufv ufv WHERE ufv.field_id=uf.id AND field_variable='$original_user_id_name' AND field_value='$original_user_id_value'";
  141. $res = api_sql_query($sql,__FILE__,__LINE__);
  142. $row = Database::fetch_row($res);
  143. $count_row = Database::num_rows($res);
  144. if ($count_row > 0) {
  145. // check if user is not active
  146. $sql = "SELECT user_id FROM $table_user WHERE user_id ='".$row[1]."' AND active= '0'";
  147. $resu = api_sql_query($sql,__FILE__,__LINE__);
  148. $r_check_user = Database::fetch_row($resu);
  149. $count_user_id = Database::num_rows($resu);
  150. if ($count_user_id > 0) {
  151. $sql = "UPDATE $table_user SET
  152. lastname='".Database::escape_string($lastName)."',
  153. firstname='".Database::escape_string($firstName)."',
  154. username='".Database::escape_string($loginName)."',";
  155. if(!is_null($password))
  156. {
  157. $password = $userPasswordCrypted ? md5($password) : $password;
  158. $sql .= " password='".Database::escape_string($password)."',";
  159. }
  160. if(!is_null($auth_source))
  161. {
  162. $sql .= " auth_source='".Database::escape_string($auth_source)."',";
  163. }
  164. $sql .= "
  165. email='".Database::escape_string($email)."',
  166. status='".Database::escape_string($status)."',
  167. official_code='".Database::escape_string($official_code)."',
  168. phone='".Database::escape_string($phone)."',
  169. expiration_date='".Database::escape_string($expiration_date)."',
  170. active='1',
  171. hr_dept_id=".intval($hr_dept_id);
  172. $sql .= " WHERE user_id='".$r_check_user[0]."'";
  173. api_sql_query($sql,__FILE__,__LINE__);
  174. $results[] = $r_check_user[0];
  175. continue;
  176. //return $r_check_user[0]; //
  177. } else {
  178. $results[] = 0;
  179. continue;
  180. //return 0; // user id already exits
  181. }
  182. }
  183. // default language
  184. if (empty($language)) {
  185. $language = api_get_setting('platformLanguage');
  186. }
  187. if (!empty($_user['user_id'])) {
  188. $creator_id = $_user['user_id'];
  189. } else {
  190. $creator_id = '';
  191. }
  192. // First check wether the login already exists
  193. if (! UserManager::is_username_available($loginName)) {
  194. if(api_set_failure('login-pass already taken')) {
  195. $results[] = 0;
  196. continue;
  197. }
  198. }
  199. $password = ($userPasswordCrypted ? md5($password) : $password);
  200. $sql = "INSERT INTO $table_user
  201. SET lastname = '".Database::escape_string(trim($lastName))."',
  202. firstname = '".Database::escape_string(trim($firstName))."',
  203. username = '".Database::escape_string(trim($loginName))."',
  204. status = '".Database::escape_string($status)."',
  205. password = '".Database::escape_string($password)."',
  206. email = '".Database::escape_string($email)."',
  207. official_code = '".Database::escape_string($official_code)."',
  208. picture_uri = '".Database::escape_string($picture_uri)."',
  209. creator_id = '".Database::escape_string($creator_id)."',
  210. auth_source = '".Database::escape_string($auth_source)."',
  211. phone = '".Database::escape_string($phone)."',
  212. language = '".Database::escape_string($language)."',
  213. registration_date = now(),
  214. expiration_date = '".Database::escape_string($expiration_date)."',
  215. hr_dept_id = '".Database::escape_string($hr_dept_id)."',
  216. active = '".Database::escape_string($active)."'";
  217. $result = api_sql_query($sql);
  218. if ($result) {
  219. //echo "id returned";
  220. $return=Database::get_last_insert_id();
  221. require_once (api_get_path(LIBRARY_PATH).'urlmanager.lib.php');
  222. if ($_configuration['multiple_access_urls']==true) {
  223. if (api_get_current_access_url_id()!=-1)
  224. UrlManager::add_user_to_url($return, api_get_current_access_url_id());
  225. else
  226. UrlManager::add_user_to_url($return, 1);
  227. } else {
  228. //we are adding by default the access_url_user table with access_url_id = 1
  229. UrlManager::add_user_to_url($return, 1);
  230. }
  231. // save new fieldlabel into user_field table
  232. $field_id = UserManager::create_extra_field($original_user_id_name,1,$original_user_id_name,'');
  233. // save the external system's id into user_field_value table'
  234. $res = UserManager::update_extra_field_value($return,$original_user_id_name,$original_user_id_value);
  235. if (is_array($extra_list) && count($extra_list) > 0) {
  236. foreach ($extra_list as $extra) {
  237. $extra_field_name = $extra['field_name'];
  238. $extra_field_value = $extra['field_value'];
  239. // save new fieldlabel into user_field table
  240. $field_id = UserManager::create_extra_field($extra_field_name,1,$extra_field_name,'');
  241. // save the external system's id into user_field_value table'
  242. $res = UserManager::update_extra_field_value($return,$extra_field_name,$extra_field_value);
  243. }
  244. }
  245. } else {
  246. $results[] = 0;
  247. continue;
  248. }
  249. $results[] = $return;
  250. } // end principal foreach
  251. $count_results = count($results);
  252. $output = array();
  253. for($i = 0; $i < $count_results; $i++) {
  254. $output[] = array('original_user_id_value' =>$orig_user_id_value[$i],'result' => $results[$i]);
  255. }
  256. return $output;
  257. }
  258. /* Register DokeosWSCreateUser function */
  259. // Register the data structures used by the service
  260. $server->wsdl->addComplexType(
  261. 'createUser',
  262. 'complexType',
  263. 'struct',
  264. 'all',
  265. '',
  266. array(
  267. 'firstname' => array('name' => 'firstname', 'type' => 'xsd:string'),
  268. 'lastname' => array('name' => 'lastname', 'type' => 'xsd:string'),
  269. 'status' => array('name' => 'status', 'type' => 'xsd:string'),
  270. 'email' => array('name' => 'email', 'type' => 'xsd:string'),
  271. 'loginname' => array('name' => 'loginname', 'type' => 'xsd:string'),
  272. 'password' => array('name' => 'password', 'type' => 'xsd:string'),
  273. 'language' => array('name' => 'language', 'type' => 'xsd:string'),
  274. 'phone' => array('name' => 'phone', 'type' => 'xsd:string'),
  275. 'expiration_date' => array('name' => 'expiration_date', 'type' => 'xsd:string'),
  276. 'original_user_id_name' => array('name' => 'original_user_id_name', 'type' => 'xsd:string'),
  277. 'original_user_id_value' => array('name' => 'original_user_id_value', 'type' => 'xsd:string'),
  278. 'extra' => array('name' => 'extra', 'type' => 'tns:extrasList'),
  279. 'secret_key' => array('name' => 'secret_key', 'type' => 'xsd:string')
  280. )
  281. );
  282. // Register the method to expose
  283. $server->register('DokeosWSCreateUser', // method name
  284. array('createUser' => 'tns:createUser'), // input parameters
  285. array('return' => 'xsd:string'), // output parameters
  286. 'urn:WSRegistration', // namespace
  287. 'urn:WSRegistration#DokeosWSCreateUser', // soapaction
  288. 'rpc', // style
  289. 'encoded', // use
  290. 'This service adds a user' // documentation
  291. );
  292. // Define the method DokeosWSCreateUser
  293. function DokeosWSCreateUser($params) {
  294. global $_user, $userPasswordCrypted,$_configuration;
  295. $secret_key = $params['secret_key'];
  296. $security_key = $_SERVER['REMOTE_ADDR'].$_configuration['security_key'];
  297. if (!api_is_valid_secret_key($secret_key,$security_key)) {
  298. return -1; //secret key is incorrect
  299. }
  300. // database table definition
  301. $table_user = Database::get_main_table(TABLE_MAIN_USER);
  302. $t_uf = Database::get_main_table(TABLE_MAIN_USER_FIELD);
  303. $t_ufv = Database::get_main_table(TABLE_MAIN_USER_FIELD_VALUES);
  304. $firstName = $params['firstname']; $lastName = $params['lastname'];
  305. $status = $params['status']; $email = $params['email'];
  306. $loginName = $params['loginname']; $password = $params['password'];
  307. $official_code = '';$language='';$phone = '';$picture_uri = '';$auth_source = PLATFORM_AUTH_SOURCE;
  308. $expiration_date = '0000-00-00 00:00:00'; $active = 1; $hr_dept_id=0; $extra=null;
  309. $original_user_id_name= $params['original_user_id_name'];
  310. $original_user_id_value = $params['original_user_id_value'];
  311. $extra_list = $params['extra'];
  312. if (!empty($params['language'])) { $language=$params['language'];}
  313. if (!empty($params['phone'])) { $phone = $params['phone'];}
  314. if (!empty($params['expiration_date'])) { $expiration_date = $params['expiration_date'];}
  315. // check if exits x_user_id into user_field_values table
  316. $sql = "SELECT field_value,user_id FROM $t_uf uf,$t_ufv ufv WHERE ufv.field_id=uf.id AND field_variable='$original_user_id_name' AND field_value='$original_user_id_value'";
  317. $res = api_sql_query($sql,__FILE__,__LINE__);
  318. $row = Database::fetch_row($res);
  319. $count_row = Database::num_rows($res);
  320. if ($count_row > 0) {
  321. // check if user is not active
  322. $sql = "SELECT user_id FROM $table_user WHERE user_id ='".$row[1]."' AND active= '0'";
  323. $resu = api_sql_query($sql,__FILE__,__LINE__);
  324. $r_check_user = Database::fetch_row($resu);
  325. $count_user_id = Database::num_rows($resu);
  326. if ($count_user_id > 0) {
  327. $sql = "UPDATE $table_user SET
  328. lastname='".Database::escape_string($lastName)."',
  329. firstname='".Database::escape_string($firstName)."',
  330. username='".Database::escape_string($loginName)."',";
  331. if(!is_null($password))
  332. {
  333. $password = $userPasswordCrypted ? md5($password) : $password;
  334. $sql .= " password='".Database::escape_string($password)."',";
  335. }
  336. if(!is_null($auth_source))
  337. {
  338. $sql .= " auth_source='".Database::escape_string($auth_source)."',";
  339. }
  340. $sql .= "
  341. email='".Database::escape_string($email)."',
  342. status='".Database::escape_string($status)."',
  343. official_code='".Database::escape_string($official_code)."',
  344. phone='".Database::escape_string($phone)."',
  345. expiration_date='".Database::escape_string($expiration_date)."',
  346. active='1',
  347. hr_dept_id=".intval($hr_dept_id);
  348. $sql .= " WHERE user_id='".$r_check_user[0]."'";
  349. api_sql_query($sql,__FILE__,__LINE__);
  350. return $r_check_user[0];
  351. } else {
  352. return 0;
  353. //return 0; // user id already exits
  354. }
  355. }
  356. // default language
  357. if (empty($language)) {
  358. $language = api_get_setting('platformLanguage');
  359. }
  360. if (!empty($_user['user_id'])) {
  361. $creator_id = $_user['user_id'];
  362. } else {
  363. $creator_id = '';
  364. }
  365. // First check wether the login already exists
  366. if (! UserManager::is_username_available($loginName)) {
  367. if(api_set_failure('login-pass already taken')) {
  368. return 0;
  369. }
  370. }
  371. $password = ($userPasswordCrypted ? md5($password) : $password);
  372. $sql = "INSERT INTO $table_user
  373. SET lastname = '".Database::escape_string(trim($lastName))."',
  374. firstname = '".Database::escape_string(trim($firstName))."',
  375. username = '".Database::escape_string(trim($loginName))."',
  376. status = '".Database::escape_string($status)."',
  377. password = '".Database::escape_string($password)."',
  378. email = '".Database::escape_string($email)."',
  379. official_code = '".Database::escape_string($official_code)."',
  380. picture_uri = '".Database::escape_string($picture_uri)."',
  381. creator_id = '".Database::escape_string($creator_id)."',
  382. auth_source = '".Database::escape_string($auth_source)."',
  383. phone = '".Database::escape_string($phone)."',
  384. language = '".Database::escape_string($language)."',
  385. registration_date = now(),
  386. expiration_date = '".Database::escape_string($expiration_date)."',
  387. hr_dept_id = '".Database::escape_string($hr_dept_id)."',
  388. active = '".Database::escape_string($active)."'";
  389. $result = api_sql_query($sql);
  390. if ($result) {
  391. //echo "id returned";
  392. $return=Database::get_last_insert_id();
  393. require_once (api_get_path(LIBRARY_PATH).'urlmanager.lib.php');
  394. if ($_configuration['multiple_access_urls']==true) {
  395. if (api_get_current_access_url_id()!=-1)
  396. UrlManager::add_user_to_url($return, api_get_current_access_url_id());
  397. else
  398. UrlManager::add_user_to_url($return, 1);
  399. } else {
  400. //we are adding by default the access_url_user table with access_url_id = 1
  401. UrlManager::add_user_to_url($return, 1);
  402. }
  403. // save new fieldlabel into user_field table
  404. $field_id = UserManager::create_extra_field($original_user_id_name,1,$original_user_id_name,'');
  405. // save the external system's id into user_field_value table'
  406. $res = UserManager::update_extra_field_value($return,$original_user_id_name,$original_user_id_value);
  407. if (is_array($extra_list) && count($extra_list) > 0) {
  408. foreach ($extra_list as $extra) {
  409. $extra_field_name = $extra['field_name'];
  410. $extra_field_value = $extra['field_value'];
  411. // save new fieldlabel into user_field table
  412. $field_id = UserManager::create_extra_field($extra_field_name,1,$extra_field_name,'');
  413. // save the external system's id into user_field_value table'
  414. $res = UserManager::update_extra_field_value($return,$extra_field_name,$extra_field_value);
  415. }
  416. }
  417. } else {
  418. return 0;
  419. }
  420. return $return;
  421. }
  422. /* Register DokeosWSCreateUsersPasswordCrypted function */
  423. // Register the data structures used by the service
  424. //prepare input params
  425. // Input params for editing users
  426. $server->wsdl->addComplexType(
  427. 'createUsersPassEncryptParams',
  428. 'complexType',
  429. 'struct',
  430. 'all',
  431. '',
  432. array(
  433. 'firstname' => array('name' => 'firstname', 'type' => 'xsd:string'),
  434. 'lastname' => array('name' => 'lastname', 'type' => 'xsd:string'),
  435. 'status' => array('name' => 'status', 'type' => 'xsd:string'),
  436. 'email' => array('name' => 'email', 'type' => 'xsd:string'),
  437. 'loginname' => array('name' => 'loginname', 'type' => 'xsd:string'),
  438. 'password' => array('name' => 'password', 'type' => 'xsd:string'),
  439. 'encrypt_method' => array('name' => 'encrypt_method', 'type' => 'xsd:string'),
  440. 'language' => array('name' => 'language', 'type' => 'xsd:string'),
  441. 'phone' => array('name' => 'phone', 'type' => 'xsd:string'),
  442. 'expiration_date' => array('name' => 'expiration_date', 'type' => 'xsd:string'),
  443. 'original_user_id_name' => array('name' => 'original_user_id_name', 'type' => 'xsd:string'),
  444. 'original_user_id_value' => array('name' => 'original_user_id_value', 'type' => 'xsd:string'),
  445. 'extra' => array('name' => 'extra', 'type' => 'tns:extrasList')
  446. )
  447. );
  448. $server->wsdl->addComplexType(
  449. 'createUsersPassEncryptParamsList',
  450. 'complexType',
  451. 'array',
  452. '',
  453. 'SOAP-ENC:Array',
  454. array(),
  455. array(array('ref'=>'SOAP-ENC:arrayType','wsdl:arrayType' => 'tns:createUsersPassEncryptParams[]')),'tns:createUsersPassEncryptParams'
  456. );
  457. // Register the data structures used by the service
  458. $server->wsdl->addComplexType(
  459. 'createUsersPasswordCrypted',
  460. 'complexType',
  461. 'struct',
  462. 'all',
  463. '',
  464. array(
  465. 'users' => array('name' => 'users', 'type' => 'tns:createUsersPassEncryptParamsList'),
  466. 'secret_key' => array('name' => 'secret_key', 'type' => 'xsd:string')
  467. )
  468. );
  469. // Prepare output params, in this case will return an array
  470. $server->wsdl->addComplexType(
  471. 'result_createUsersPassEncrypt',
  472. 'complexType',
  473. 'struct',
  474. 'all',
  475. '',
  476. array(
  477. 'original_user_id_value' => array('name' => 'original_user_id_value', 'type' => 'xsd:string'),
  478. 'result' => array('name' => 'result', 'type' => 'xsd:string')
  479. )
  480. );
  481. $server->wsdl->addComplexType(
  482. 'results_createUsersPassEncrypt',
  483. 'complexType',
  484. 'array',
  485. '',
  486. 'SOAP-ENC:Array',
  487. array(),
  488. array(array('ref'=>'SOAP-ENC:arrayType','wsdl:arrayType' => 'tns:result_createUsersPassEncrypt[]')),'tns:result_createUsersPassEncrypt'
  489. );
  490. // Register the method to expose
  491. $server->register('DokeosWSCreateUsersPasswordCrypted', // method name
  492. array('createUsersPasswordCrypted' => 'tns:createUsersPasswordCrypted'), // input parameters
  493. array('return' => 'tns:results_createUsersPassEncrypt'), // output parameters
  494. 'urn:WSRegistration', // namespace
  495. 'urn:WSRegistration#DokeosWSCreateUsersPasswordCrypted', // soapaction
  496. 'rpc', // style
  497. 'encoded', // use
  498. 'This service adds users to dokeos' // documentation
  499. );
  500. // Define the method DokeosWSCreateUsersPasswordCrypted
  501. function DokeosWSCreateUsersPasswordCrypted($params) {
  502. global $_user, $userPasswordCrypted,$_configuration;
  503. $secret_key = $params['secret_key'];
  504. $security_key = $_SERVER['REMOTE_ADDR'].$_configuration['security_key'];
  505. if (!api_is_valid_secret_key($secret_key,$security_key)) {
  506. return -1; //secret key is incorrect
  507. }
  508. // database table definition
  509. $table_user = Database::get_main_table(TABLE_MAIN_USER);
  510. $t_uf = Database::get_main_table(TABLE_MAIN_USER_FIELD);
  511. $t_ufv = Database::get_main_table(TABLE_MAIN_USER_FIELD_VALUES);
  512. $users_params = $params['users'];
  513. $results = array();
  514. $orig_user_id_value = array();
  515. foreach($users_params as $user_param) {
  516. $password = $user_param['password'];
  517. $encrypt_method = $user_param['encrypt_method'];
  518. $firstName = $user_param['firstname']; $lastName = $user_param['lastname'];
  519. $status = $user_param['status']; $email = $user_param['email'];
  520. $loginName = $user_param['loginname'];
  521. $official_code = '';$language='';$phone = '';$picture_uri = '';$auth_source = PLATFORM_AUTH_SOURCE;
  522. $expiration_date = '0000-00-00 00:00:00'; $active = 1; $hr_dept_id=0; $extra=null;
  523. $original_user_id_name= $user_param['original_user_id_name'];
  524. $original_user_id_value = $user_param['original_user_id_value'];
  525. $orig_user_id_value[] = $user_param['original_user_id_value'];
  526. $extra_list = $user_param['extra'];
  527. $salt = '';
  528. if ($userPasswordCrypted === $encrypt_method ) {
  529. if ($encrypt_method == 'md5' && !preg_match('/^[A-Fa-f0-9]{32}$/',$password)) {
  530. $msg = "Encryption $encrypt_method is invalid";
  531. $results[] = $msg;
  532. continue;
  533. } else if ($encrypt_method == 'sha1' && !preg_match('/^[A-Fa-f0-9]{40}$/',$password)) {
  534. $msg = "Encryption $encrypt_method is invalid";
  535. $results[] = $msg;
  536. continue;
  537. }
  538. } else {
  539. $msg = "This encryption $encrypt_method is not configured into dokeos ";
  540. $results[] = $msg;
  541. continue;
  542. }
  543. if (is_array($extra_list) && count($extra_list) > 0) {
  544. foreach ($extra_list as $extra) {
  545. if($extra['field_name'] == 'salt') {
  546. $salt = $extra['field_value'];
  547. break;
  548. }
  549. }
  550. }
  551. if (!empty($user_param['language'])) { $language=$user_param['language'];}
  552. if (!empty($user_param['phone'])) { $phone = $user_param['phone'];}
  553. if (!empty($user_param['expiration_date'])) { $expiration_date = $user_param['expiration_date'];}
  554. // check if exits x_user_id into user_field_values table
  555. $sql = "SELECT field_value,user_id FROM $t_uf uf,$t_ufv ufv WHERE ufv.field_id=uf.id AND field_variable='$original_user_id_name' AND field_value='$original_user_id_value'";
  556. $res = api_sql_query($sql,__FILE__,__LINE__);
  557. $row = Database::fetch_row($res);
  558. $count_row = Database::num_rows($res);
  559. if ($count_row > 0) {
  560. // check if user is not active
  561. $sql = "SELECT user_id FROM $table_user WHERE user_id ='".$row[1]."' AND active= '0'";
  562. $resu = api_sql_query($sql,__FILE__,__LINE__);
  563. $r_check_user = Database::fetch_row($resu);
  564. $count_check_user = Database::num_rows($resu);
  565. if ($count_check_user > 0) {
  566. $sql = "UPDATE $table_user SET
  567. lastname='".Database::escape_string($lastName)."',
  568. firstname='".Database::escape_string($firstName)."',
  569. username='".Database::escape_string($loginName)."',";
  570. if(!is_null($auth_source))
  571. {
  572. $sql .= " auth_source='".Database::escape_string($auth_source)."',";
  573. }
  574. $sql .= "
  575. password='".Database::escape_string($password)."',
  576. email='".Database::escape_string($email)."',
  577. status='".Database::escape_string($status)."',
  578. official_code='".Database::escape_string($official_code)."',
  579. phone='".Database::escape_string($phone)."',
  580. expiration_date='".Database::escape_string($expiration_date)."',
  581. active='1',
  582. hr_dept_id=".intval($hr_dept_id);
  583. $sql .= " WHERE user_id='".$r_check_user[0]."'";
  584. api_sql_query($sql,__FILE__,__LINE__);
  585. if (is_array($extra_list) && count($extra_list) > 0) {
  586. foreach ($extra_list as $extra) {
  587. $extra_field_name = $extra['field_name'];
  588. $extra_field_value = $extra['field_value'];
  589. // save the external system's id into user_field_value table'
  590. $res = UserManager::update_extra_field_value($r_check_user[0],$extra_field_name,$extra_field_value);
  591. }
  592. }
  593. $results[] = $r_check_user[0];
  594. continue;
  595. } else {
  596. $results[] = 0;
  597. continue; // user id already exits
  598. }
  599. }
  600. // default language
  601. if (empty($language)) {
  602. $language = api_get_setting('platformLanguage');
  603. }
  604. if (!empty($_user['user_id'])) {
  605. $creator_id = $_user['user_id'];
  606. } else {
  607. $creator_id = '';
  608. }
  609. // First check wether the login already exists
  610. if (! UserManager::is_username_available($loginName)) {
  611. if(api_set_failure('login-pass already taken')) {
  612. $results[] = 0;
  613. continue;
  614. }
  615. }
  616. $sql = "INSERT INTO $table_user
  617. SET lastname = '".Database::escape_string(trim($lastName))."',
  618. firstname = '".Database::escape_string(trim($firstName))."',
  619. username = '".Database::escape_string(trim($loginName))."',
  620. status = '".Database::escape_string($status)."',
  621. password = '".Database::escape_string($password)."',
  622. email = '".Database::escape_string($email)."',
  623. official_code = '".Database::escape_string($official_code)."',
  624. picture_uri = '".Database::escape_string($picture_uri)."',
  625. creator_id = '".Database::escape_string($creator_id)."',
  626. auth_source = '".Database::escape_string($auth_source)."',
  627. phone = '".Database::escape_string($phone)."',
  628. language = '".Database::escape_string($language)."',
  629. registration_date = now(),
  630. expiration_date = '".Database::escape_string($expiration_date)."',
  631. hr_dept_id = '".Database::escape_string($hr_dept_id)."',
  632. active = '".Database::escape_string($active)."'";
  633. $result = api_sql_query($sql);
  634. if ($result) {
  635. //echo "id returned";
  636. $return=Database::get_last_insert_id();
  637. require_once (api_get_path(LIBRARY_PATH).'urlmanager.lib.php');
  638. if ($_configuration['multiple_access_urls']==true) {
  639. if (api_get_current_access_url_id()!=-1)
  640. UrlManager::add_user_to_url($return, api_get_current_access_url_id());
  641. else
  642. UrlManager::add_user_to_url($return, 1);
  643. } else {
  644. //we are adding by default the access_url_user table with access_url_id = 1
  645. UrlManager::add_user_to_url($return, 1);
  646. }
  647. // save new fieldlabel into user_field table
  648. $field_id = UserManager::create_extra_field($original_user_id_name,1,$original_user_id_name,'');
  649. // save the remote system's id into user_field_value table'
  650. $res = UserManager::update_extra_field_value($return,$original_user_id_name,$original_user_id_value);
  651. if (is_array($extra_list) && count($extra_list) > 0) {
  652. foreach ($extra_list as $extra) {
  653. $extra_field_name = $extra['field_name'];
  654. $extra_field_value = $extra['field_value'];
  655. // save new fieldlabel into user_field table
  656. $field_id = UserManager::create_extra_field($extra_field_name,1,$extra_field_name,'');
  657. // save the external system's id into user_field_value table'
  658. $res = UserManager::update_extra_field_value($return,$extra_field_name,$extra_field_value);
  659. }
  660. }
  661. } else {
  662. $results[] = 0;
  663. continue;
  664. }
  665. $results[] = $return;
  666. } // end principal foreach
  667. $count_results = count($results);
  668. $output = array();
  669. for($i = 0; $i < $count_results; $i++) {
  670. $output[] = array('original_user_id_value' =>$orig_user_id_value[$i],'result' => $results[$i]);
  671. }
  672. return $output;
  673. }
  674. /* Register DokeosWSCreateUserPasswordCrypted function */
  675. // Register the data structures used by the service
  676. //prepare input params
  677. // Input params for editing users
  678. $server->wsdl->addComplexType(
  679. 'createUserPasswordCrypted',
  680. 'complexType',
  681. 'struct',
  682. 'all',
  683. '',
  684. array(
  685. 'firstname' => array('name' => 'firstname', 'type' => 'xsd:string'),
  686. 'lastname' => array('name' => 'lastname', 'type' => 'xsd:string'),
  687. 'status' => array('name' => 'status', 'type' => 'xsd:string'),
  688. 'email' => array('name' => 'email', 'type' => 'xsd:string'),
  689. 'loginname' => array('name' => 'loginname', 'type' => 'xsd:string'),
  690. 'password' => array('name' => 'password', 'type' => 'xsd:string'),
  691. 'encrypt_method' => array('name' => 'encrypt_method', 'type' => 'xsd:string'),
  692. 'language' => array('name' => 'language', 'type' => 'xsd:string'),
  693. 'phone' => array('name' => 'phone', 'type' => 'xsd:string'),
  694. 'expiration_date' => array('name' => 'expiration_date', 'type' => 'xsd:string'),
  695. 'original_user_id_name' => array('name' => 'original_user_id_name', 'type' => 'xsd:string'),
  696. 'original_user_id_value' => array('name' => 'original_user_id_value', 'type' => 'xsd:string'),
  697. 'extra' => array('name' => 'extra', 'type' => 'tns:extrasList'),
  698. 'secret_key' => array('name' => 'secret_key', 'type' => 'xsd:string')
  699. )
  700. );
  701. // Register the method to expose
  702. $server->register('DokeosWSCreateUserPasswordCrypted', // method name
  703. array('createUserPasswordCrypted' => 'tns:createUserPasswordCrypted'), // input parameters
  704. array('return' => 'xsd:string'), // output parameters
  705. 'urn:WSRegistration', // namespace
  706. 'urn:WSRegistration#DokeosWSCreateUserPasswordCrypted', // soapaction
  707. 'rpc', // style
  708. 'encoded', // use
  709. 'This service adds users to dokeos' // documentation
  710. );
  711. // Define the method DokeosWSCreateUserPasswordCrypted
  712. function DokeosWSCreateUserPasswordCrypted($params) {
  713. global $_user, $userPasswordCrypted,$_configuration;
  714. $secret_key = $params['secret_key'];
  715. $security_key = $_SERVER['REMOTE_ADDR'].$_configuration['security_key'];
  716. if (!api_is_valid_secret_key($secret_key,$security_key)) {
  717. return -1; //secret key is incorrect
  718. }
  719. // database table definition
  720. $table_user = Database::get_main_table(TABLE_MAIN_USER);
  721. $t_uf = Database::get_main_table(TABLE_MAIN_USER_FIELD);
  722. $t_ufv = Database::get_main_table(TABLE_MAIN_USER_FIELD_VALUES);
  723. //$users_params = $params['users'];
  724. $results = array();
  725. $orig_user_id_value = array();
  726. $password = $params['password'];
  727. $encrypt_method = $params['encrypt_method'];
  728. $firstName = $params['firstname']; $lastName = $params['lastname'];
  729. $status = $params['status']; $email = $params['email'];
  730. $loginName = $params['loginname'];
  731. $official_code = '';$language='';$phone = '';$picture_uri = '';$auth_source = PLATFORM_AUTH_SOURCE;
  732. $expiration_date = '0000-00-00 00:00:00'; $active = 1; $hr_dept_id=0; $extra=null;
  733. $original_user_id_name= $params['original_user_id_name'];
  734. $original_user_id_value = $params['original_user_id_value'];
  735. $orig_user_id_value[] = $params['original_user_id_value'];
  736. $extra_list = $params['extra'];
  737. $salt = '';
  738. if ($userPasswordCrypted === $encrypt_method ) {
  739. if ($encrypt_method == 'md5' && !preg_match('/^[A-Fa-f0-9]{32}$/',$password)) {
  740. $msg = "Encryption $encrypt_method is invalid";
  741. return $msg;
  742. } else if ($encrypt_method == 'sha1' && !preg_match('/^[A-Fa-f0-9]{40}$/',$password)) {
  743. $msg = "Encryption $encrypt_method is invalid";
  744. return $msg;
  745. }
  746. } else {
  747. $msg = "This encryption $encrypt_method is not configured into dokeos ";
  748. return $msg;
  749. }
  750. if (!empty($params['language'])) { $language=$params['language'];}
  751. if (!empty($params['phone'])) { $phone = $params['phone'];}
  752. if (!empty($params['expiration_date'])) { $expiration_date = $params['expiration_date'];}
  753. // check if exits x_user_id into user_field_values table
  754. $sql = "SELECT field_value,user_id FROM $t_uf uf,$t_ufv ufv WHERE ufv.field_id=uf.id AND field_variable='$original_user_id_name' AND field_value='$original_user_id_value'";
  755. $res = api_sql_query($sql,__FILE__,__LINE__);
  756. $row = Database::fetch_row($res);
  757. $count_row = Database::num_rows($res);
  758. if ($count_row > 0) {
  759. // check if user is not active
  760. $sql = "SELECT user_id FROM $table_user WHERE user_id ='".$row[1]."' AND active= '0'";
  761. $resu = api_sql_query($sql,__FILE__,__LINE__);
  762. $r_check_user = Database::fetch_row($resu);
  763. $count_check_user = Database::num_rows($resu);
  764. if ($count_check_user > 0) {
  765. $sql = "UPDATE $table_user SET
  766. lastname='".Database::escape_string($lastName)."',
  767. firstname='".Database::escape_string($firstName)."',
  768. username='".Database::escape_string($loginName)."',";
  769. if(!is_null($auth_source))
  770. {
  771. $sql .= " auth_source='".Database::escape_string($auth_source)."',";
  772. }
  773. $sql .= "
  774. password='".Database::escape_string($password)."',
  775. email='".Database::escape_string($email)."',
  776. status='".Database::escape_string($status)."',
  777. official_code='".Database::escape_string($official_code)."',
  778. phone='".Database::escape_string($phone)."',
  779. expiration_date='".Database::escape_string($expiration_date)."',
  780. active='1',
  781. hr_dept_id=".intval($hr_dept_id);
  782. $sql .= " WHERE user_id='".$r_check_user[0]."'";
  783. api_sql_query($sql,__FILE__,__LINE__);
  784. if (is_array($extra_list) && count($extra_list) > 0) {
  785. foreach ($extra_list as $extra) {
  786. $extra_field_name = $extra['field_name'];
  787. $extra_field_value = $extra['field_value'];
  788. // save the external system's id into user_field_value table'
  789. $res = UserManager::update_extra_field_value($r_check_user[0],$extra_field_name,$extra_field_value);
  790. }
  791. }
  792. return $r_check_user[0];
  793. } else {
  794. return 0;
  795. }
  796. }
  797. // default language
  798. if (empty($language)) {
  799. $language = api_get_setting('platformLanguage');
  800. }
  801. if (!empty($_user['user_id'])) {
  802. $creator_id = $_user['user_id'];
  803. } else {
  804. $creator_id = '';
  805. }
  806. // First check wether the login already exists
  807. if (! UserManager::is_username_available($loginName)) {
  808. if(api_set_failure('login-pass already taken')) {
  809. return 0;
  810. }
  811. }
  812. $sql = "INSERT INTO $table_user
  813. SET lastname = '".Database::escape_string(trim($lastName))."',
  814. firstname = '".Database::escape_string(trim($firstName))."',
  815. username = '".Database::escape_string(trim($loginName))."',
  816. status = '".Database::escape_string($status)."',
  817. password = '".Database::escape_string($password)."',
  818. email = '".Database::escape_string($email)."',
  819. official_code = '".Database::escape_string($official_code)."',
  820. picture_uri = '".Database::escape_string($picture_uri)."',
  821. creator_id = '".Database::escape_string($creator_id)."',
  822. auth_source = '".Database::escape_string($auth_source)."',
  823. phone = '".Database::escape_string($phone)."',
  824. language = '".Database::escape_string($language)."',
  825. registration_date = now(),
  826. expiration_date = '".Database::escape_string($expiration_date)."',
  827. hr_dept_id = '".Database::escape_string($hr_dept_id)."',
  828. active = '".Database::escape_string($active)."'";
  829. $result = api_sql_query($sql);
  830. if ($result) {
  831. //echo "id returned";
  832. $return=Database::get_last_insert_id();
  833. require_once (api_get_path(LIBRARY_PATH).'urlmanager.lib.php');
  834. if ($_configuration['multiple_access_urls']==true) {
  835. if (api_get_current_access_url_id()!=-1)
  836. UrlManager::add_user_to_url($return, api_get_current_access_url_id());
  837. else
  838. UrlManager::add_user_to_url($return, 1);
  839. } else {
  840. //we are adding by default the access_url_user table with access_url_id = 1
  841. UrlManager::add_user_to_url($return, 1);
  842. }
  843. // save new fieldlabel into user_field table
  844. $field_id = UserManager::create_extra_field($original_user_id_name,1,$original_user_id_name,'');
  845. // save the remote system's id into user_field_value table'
  846. $res = UserManager::update_extra_field_value($return,$original_user_id_name,$original_user_id_value);
  847. if (is_array($extra_list) && count($extra_list) > 0) {
  848. foreach ($extra_list as $extra) {
  849. $extra_field_name = $extra['field_name'];
  850. $extra_field_value = $extra['field_value'];
  851. // save new fieldlabel into user_field table
  852. $field_id = UserManager::create_extra_field($extra_field_name,1,$extra_field_name,'');
  853. // save the external system's id into user_field_value table'
  854. $res = UserManager::update_extra_field_value($return,$extra_field_name,$extra_field_value);
  855. }
  856. }
  857. } else {
  858. return 0;
  859. }
  860. return $return;
  861. }
  862. /* Register DokeosWSEditUsers function */
  863. // Register the data structures used by the service
  864. $server->wsdl->addComplexType(
  865. 'editUsersParams',
  866. 'complexType',
  867. 'struct',
  868. 'all',
  869. '',
  870. array(
  871. 'original_user_id_value' => array('name' => 'original_user_id_value', 'type' => 'xsd:string'),
  872. 'original_user_id_name' => array('name' => 'original_user_id_name', 'type' => 'xsd:string'),
  873. 'firstname' => array('name' => 'firstname', 'type' => 'xsd:string'),
  874. 'lastname' => array('name' => 'lastname', 'type' => 'xsd:string'),
  875. 'username' => array('name' => 'username', 'type' => 'xsd:string'),
  876. 'password' => array('name' => 'password', 'type' => 'xsd:string'),
  877. 'email' => array('name' => 'email', 'type' => 'xsd:string'),
  878. 'status' => array('name' => 'status', 'type' => 'xsd:string'),
  879. 'phone' => array('name' => 'phone', 'type' => 'xsd:string'),
  880. 'expiration_date' => array('name' => 'expiration_date', 'type' => 'xsd:string'),
  881. 'extra' => array('name' => 'extra', 'type' => 'tns:extrasList')
  882. )
  883. );
  884. $server->wsdl->addComplexType(
  885. 'editUsersParamsList',
  886. 'complexType',
  887. 'array',
  888. '',
  889. 'SOAP-ENC:Array',
  890. array(),
  891. array(array('ref'=>'SOAP-ENC:arrayType','wsdl:arrayType' => 'tns:editUsersParams[]')),'tns:editUsersParams'
  892. );
  893. $server->wsdl->addComplexType(
  894. 'editUsers',
  895. 'complexType',
  896. 'struct',
  897. 'all',
  898. '',
  899. array(
  900. 'users' => array('name' => 'users', 'type' => 'tns:editUsersParamsList'),
  901. 'secret_key' => array('name' => 'secret_key', 'type' => 'xsd:string')
  902. )
  903. );
  904. // Prepare output params, in this case will return an array
  905. $server->wsdl->addComplexType(
  906. 'result_editUsers',
  907. 'complexType',
  908. 'struct',
  909. 'all',
  910. '',
  911. array(
  912. 'original_user_id_value' => array('name' => 'original_user_id_value', 'type' => 'xsd:string'),
  913. 'result' => array('name' => 'result', 'type' => 'xsd:string')
  914. )
  915. );
  916. $server->wsdl->addComplexType(
  917. 'results_editUsers',
  918. 'complexType',
  919. 'array',
  920. '',
  921. 'SOAP-ENC:Array',
  922. array(),
  923. array(array('ref'=>'SOAP-ENC:arrayType','wsdl:arrayType' => 'tns:result_editUsers[]')),'tns:result_editUsers'
  924. );
  925. // Register the method to expose
  926. $server->register('DokeosWSEditUsers', // method name
  927. array('editUsers' => 'tns:editUsers'), // input parameters
  928. array('return' => 'tns:results_editUsers'), // output parameters
  929. 'urn:WSRegistration', // namespace
  930. 'urn:WSRegistration#DokeosWSEditUsers', // soapaction
  931. 'rpc', // style
  932. 'encoded', // use
  933. 'This service edits a user from wiener' // documentation
  934. );
  935. // Define the method DokeosWSEditUsers
  936. function DokeosWSEditUsers($params)
  937. {
  938. global $userPasswordCrypted,$_configuration;
  939. $secret_key = $params['secret_key'];
  940. $security_key = $_SERVER['REMOTE_ADDR'].$_configuration['security_key'];
  941. if (!api_is_valid_secret_key($secret_key,$security_key)) {
  942. return -1; //secret key is incorrect
  943. }
  944. $table_user = Database :: get_main_table(TABLE_MAIN_USER);
  945. $t_uf = Database::get_main_table(TABLE_MAIN_USER_FIELD);
  946. $t_ufv = Database::get_main_table(TABLE_MAIN_USER_FIELD_VALUES);
  947. $users_params = $params['users'];
  948. $results = array();
  949. $orig_user_id_value = array();
  950. foreach($users_params as $user_param) {
  951. $original_user_id_value = $user_param['original_user_id_value'];
  952. $original_user_id_name = $user_param['original_user_id_name'];
  953. $orig_user_id_value[] = $original_user_id_value;
  954. $firstname = $user_param['firstname'];
  955. $lastname = $user_param['lastname'];
  956. $username = $user_param['username'];
  957. $password = null; $auth_source = null;
  958. $email = $user_param['email']; $status = $user_param['status'];
  959. $official_code = ''; $phone = $user_param['phone'];
  960. $picture_uri = ''; $expiration_date = $user_param['expiration_date']; $active = 1;
  961. $creator_id= null; $hr_dept_id=0; $extra=null;
  962. $extra_list = $user_param['extra'];
  963. if (!empty($user_param['password'])) { $password = $user_param['password'];}
  964. // get user id from id wiener
  965. $sql = "SELECT user_id FROM $t_uf uf,$t_ufv ufv WHERE ufv.field_id=uf.id AND field_variable='$original_user_id_name' AND field_value='$original_user_id_value'";
  966. $res = api_sql_query($sql,__FILE__,__LINE__);
  967. $row = Database::fetch_row($res);
  968. $user_id = $row[0];
  969. if (empty($user_id)) {
  970. $results[] = 0; // original_user_id_value doesn't exits
  971. continue;
  972. } else {
  973. $sql = "SELECT user_id FROM $table_user WHERE user_id ='$user_id' AND active= '0'";
  974. $resu = api_sql_query($sql,__FILE__,__LINE__);
  975. $r_check_user = Database::fetch_row($resu);
  976. if (!empty($r_check_user[0])) {
  977. $results[] = 0; // user_id is not active
  978. continue;
  979. }
  980. }
  981. // check if username already exits
  982. $sql = "SELECT username FROM $table_user WHERE username = '$username' AND user_id <> '$user_id'";
  983. $res_un = api_sql_query($sql,__FILE__,__LINE__);
  984. $r_username = Database::fetch_row($res_un);
  985. if (!empty($r_username[0])) {
  986. $results[] = 0; // username already exits
  987. continue;
  988. }
  989. $sql = "UPDATE $table_user SET
  990. lastname='".Database::escape_string($lastname)."',
  991. firstname='".Database::escape_string($firstname)."',
  992. username='".Database::escape_string($username)."',";
  993. if(!is_null($password))
  994. {
  995. $password = $userPasswordCrypted ? md5($password) : $password;
  996. $sql .= " password='".Database::escape_string($password)."',";
  997. }
  998. if(!is_null($auth_source))
  999. {
  1000. $sql .= " auth_source='".Database::escape_string($auth_source)."',";
  1001. }
  1002. $sql .= "
  1003. email='".Database::escape_string($email)."',
  1004. status='".Database::escape_string($status)."',
  1005. official_code='".Database::escape_string($official_code)."',
  1006. phone='".Database::escape_string($phone)."',
  1007. picture_uri='".Database::escape_string($picture_uri)."',
  1008. expiration_date='".Database::escape_string($expiration_date)."',
  1009. active='".Database::escape_string($active)."',
  1010. hr_dept_id=".intval($hr_dept_id);
  1011. if(!is_null($creator_id))
  1012. {
  1013. $sql .= ", creator_id='".Database::escape_string($creator_id)."'";
  1014. }
  1015. $sql .= " WHERE user_id='$user_id'";
  1016. $return = @api_sql_query($sql,__FILE__,__LINE__);
  1017. if (is_array($extra_list) && count($extra_list) > 0) {
  1018. foreach ($extra_list as $extra) {
  1019. $extra_field_name = $extra['field_name'];
  1020. $extra_field_value = $extra['field_value'];
  1021. // save the external system's id into user_field_value table'
  1022. $res = UserManager::update_extra_field_value($user_id,$extra_field_name,$extra_field_value);
  1023. }
  1024. }
  1025. $results[] = $return;
  1026. continue;
  1027. }
  1028. $count_results = count($results);
  1029. $output = array();
  1030. for($i = 0; $i < $count_results; $i++) {
  1031. $output[] = array('original_user_id_value' =>$orig_user_id_value[$i],'result' => $results[$i]);
  1032. }
  1033. return $output;
  1034. }
  1035. /* Register DokeosWSEditUser function */
  1036. // Register the data structures used by the service
  1037. $server->wsdl->addComplexType(
  1038. 'editUser',
  1039. 'complexType',
  1040. 'struct',
  1041. 'all',
  1042. '',
  1043. array(
  1044. 'original_user_id_value' => array('name' => 'original_user_id_value', 'type' => 'xsd:string'),
  1045. 'original_user_id_name' => array('name' => 'original_user_id_name', 'type' => 'xsd:string'),
  1046. 'firstname' => array('name' => 'firstname', 'type' => 'xsd:string'),
  1047. 'lastname' => array('name' => 'lastname', 'type' => 'xsd:string'),
  1048. 'username' => array('name' => 'username', 'type' => 'xsd:string'),
  1049. 'password' => array('name' => 'password', 'type' => 'xsd:string'),
  1050. 'email' => array('name' => 'email', 'type' => 'xsd:string'),
  1051. 'status' => array('name' => 'status', 'type' => 'xsd:string'),
  1052. 'phone' => array('name' => 'phone', 'type' => 'xsd:string'),
  1053. 'expiration_date' => array('name' => 'expiration_date', 'type' => 'xsd:string'),
  1054. 'extra' => array('name' => 'extra', 'type' => 'tns:extrasList'),
  1055. 'secret_key' => array('name' => 'secret_key', 'type' => 'xsd:string')
  1056. )
  1057. );
  1058. // Register the method to expose
  1059. $server->register('DokeosWSEditUser', // method name
  1060. array('editUser' => 'tns:editUser'), // input parameters
  1061. array('return' => 'xsd:string'), // output parameters
  1062. 'urn:WSRegistration', // namespace
  1063. 'urn:WSRegistration#DokeosWSEditUser', // soapaction
  1064. 'rpc', // style
  1065. 'encoded', // use
  1066. 'This service edits a user from wiener' // documentation
  1067. );
  1068. // Define the method DokeosWSEditUser
  1069. function DokeosWSEditUser($params)
  1070. {
  1071. global $userPasswordCrypted,$_configuration;
  1072. $secret_key = $params['secret_key'];
  1073. $security_key = $_SERVER['REMOTE_ADDR'].$_configuration['security_key'];
  1074. if (!api_is_valid_secret_key($secret_key,$security_key)) {
  1075. return -1; //secret key is incorrect
  1076. }
  1077. $table_user = Database :: get_main_table(TABLE_MAIN_USER);
  1078. $t_uf = Database::get_main_table(TABLE_MAIN_USER_FIELD);
  1079. $t_ufv = Database::get_main_table(TABLE_MAIN_USER_FIELD_VALUES);
  1080. $original_user_id_value = $params['original_user_id_value'];
  1081. $original_user_id_name = $params['original_user_id_name'];
  1082. $firstname = $params['firstname'];
  1083. $lastname = $params['lastname'];
  1084. $username = $params['username'];
  1085. $password = null; $auth_source = null;
  1086. $email = $params['email']; $status = $params['status'];
  1087. $official_code = ''; $phone = $params['phone'];
  1088. $picture_uri = ''; $expiration_date = $params['expiration_date']; $active = 1;
  1089. $creator_id= null; $hr_dept_id=0; $extra=null;
  1090. $extra_list = $params['extra'];
  1091. if (!empty($params['password'])) { $password = $params['password'];}
  1092. // get user id from id wiener
  1093. $sql = "SELECT user_id FROM $t_uf uf,$t_ufv ufv WHERE ufv.field_id=uf.id AND field_variable='$original_user_id_name' AND field_value='$original_user_id_value'";
  1094. $res = api_sql_query($sql,__FILE__,__LINE__);
  1095. $row = Database::fetch_row($res);
  1096. $user_id = $row[0];
  1097. if (empty($user_id)) {
  1098. return 0;
  1099. } else {
  1100. $sql = "SELECT user_id FROM $table_user WHERE user_id ='$user_id' AND active= '0'";
  1101. $resu = api_sql_query($sql,__FILE__,__LINE__);
  1102. $r_check_user = Database::fetch_row($resu);
  1103. if (!empty($r_check_user[0])) {
  1104. return 0;
  1105. }
  1106. }
  1107. // check if username already exits
  1108. $sql = "SELECT username FROM $table_user WHERE username = '$username' AND user_id <> '$user_id'";
  1109. $res_un = api_sql_query($sql,__FILE__,__LINE__);
  1110. $r_username = Database::fetch_row($res_un);
  1111. if (!empty($r_username[0])) {
  1112. return 0;
  1113. }
  1114. $sql = "UPDATE $table_user SET
  1115. lastname='".Database::escape_string($lastname)."',
  1116. firstname='".Database::escape_string($firstname)."',
  1117. username='".Database::escape_string($username)."',";
  1118. if(!is_null($password))
  1119. {
  1120. $password = $userPasswordCrypted ? md5($password) : $password;
  1121. $sql .= " password='".Database::escape_string($password)."',";
  1122. }
  1123. if(!is_null($auth_source))
  1124. {
  1125. $sql .= " auth_source='".Database::escape_string($auth_source)."',";
  1126. }
  1127. $sql .= "
  1128. email='".Database::escape_string($email)."',
  1129. status='".Database::escape_string($status)."',
  1130. official_code='".Database::escape_string($official_code)."',
  1131. phone='".Database::escape_string($phone)."',
  1132. picture_uri='".Database::escape_string($picture_uri)."',
  1133. expiration_date='".Database::escape_string($expiration_date)."',
  1134. active='".Database::escape_string($active)."',
  1135. hr_dept_id=".intval($hr_dept_id);
  1136. if(!is_null($creator_id))
  1137. {
  1138. $sql .= ", creator_id='".Database::escape_string($creator_id)."'";
  1139. }
  1140. $sql .= " WHERE user_id='$user_id'";
  1141. $return = @api_sql_query($sql,__FILE__,__LINE__);
  1142. if (is_array($extra_list) && count($extra_list) > 0) {
  1143. foreach ($extra_list as $extra) {
  1144. $extra_field_name = $extra['field_name'];
  1145. $extra_field_value = $extra['field_value'];
  1146. // save the external system's id into user_field_value table'
  1147. $res = UserManager::update_extra_field_value($user_id,$extra_field_name,$extra_field_value);
  1148. }
  1149. }
  1150. return $return;
  1151. }
  1152. /* Register DokeosWSEditUsersPasswordCrypted function */
  1153. // Register the data structures used by the service
  1154. $server->wsdl->addComplexType(
  1155. 'editUsersPasswordCryptedParams',
  1156. 'complexType',
  1157. 'struct',
  1158. 'all',
  1159. '',
  1160. array(
  1161. 'original_user_id_value' => array('name' => 'original_user_id_value', 'type' => 'xsd:string'),
  1162. 'original_user_id_name' => array('name' => 'original_user_id_name', 'type' => 'xsd:string'),
  1163. 'firstname' => array('name' => 'firstname', 'type' => 'xsd:string'),
  1164. 'lastname' => array('name' => 'lastname', 'type' => 'xsd:string'),
  1165. 'username' => array('name' => 'username', 'type' => 'xsd:string'),
  1166. 'password' => array('name' => 'password', 'type' => 'xsd:string'),
  1167. 'encrypt_method' => array('name' => 'encrypt_method', 'type' => 'xsd:string'),
  1168. 'email' => array('name' => 'email', 'type' => 'xsd:string'),
  1169. 'status' => array('name' => 'status', 'type' => 'xsd:string'),
  1170. 'phone' => array('name' => 'phone', 'type' => 'xsd:string'),
  1171. 'expiration_date' => array('name' => 'expiration_date', 'type' => 'xsd:string'),
  1172. 'extra' => array('name' => 'extra', 'type' => 'tns:extrasList')
  1173. )
  1174. );
  1175. $server->wsdl->addComplexType(
  1176. 'editUsersPasswordCryptedParamsList',
  1177. 'complexType',
  1178. 'array',
  1179. '',
  1180. 'SOAP-ENC:Array',
  1181. array(),
  1182. array(array('ref'=>'SOAP-ENC:arrayType','wsdl:arrayType' => 'tns:editUsersPasswordCryptedParams[]')),'tns:editUsersPasswordCryptedParams'
  1183. );
  1184. $server->wsdl->addComplexType(
  1185. 'editUsersPasswordCrypted',
  1186. 'complexType',
  1187. 'struct',
  1188. 'all',
  1189. '',
  1190. array(
  1191. 'users' => array('name' => 'users', 'type' => 'tns:editUsersPasswordCryptedParamsList'),
  1192. 'secret_key' => array('name' => 'secret_key', 'type' => 'xsd:string')
  1193. )
  1194. );
  1195. // Prepare output params, in this case will return an array
  1196. $server->wsdl->addComplexType(
  1197. 'result_editUsersPasswordCrypted',
  1198. 'complexType',
  1199. 'struct',
  1200. 'all',
  1201. '',
  1202. array(
  1203. 'original_user_id_value' => array('name' => 'original_user_id_value', 'type' => 'xsd:string'),
  1204. 'result' => array('name' => 'result', 'type' => 'xsd:string')
  1205. )
  1206. );
  1207. $server->wsdl->addComplexType(
  1208. 'results_editUsersPasswordCrypted',
  1209. 'complexType',
  1210. 'array',
  1211. '',
  1212. 'SOAP-ENC:Array',
  1213. array(),
  1214. array(array('ref'=>'SOAP-ENC:arrayType','wsdl:arrayType' => 'tns:result_editUsersPasswordCrypted[]')),'tns:result_editUsersPasswordCrypted'
  1215. );
  1216. // Register the method to expose
  1217. $server->register('DokeosWSEditUsersPasswordCrypted', // method name
  1218. array('editUsersPasswordCrypted' => 'tns:editUsersPasswordCrypted'), // input parameters
  1219. array('return' => 'tns:results_editUsersPasswordCrypted'), // output parameters
  1220. 'urn:WSRegistration', // namespace
  1221. 'urn:WSRegistration#DokeosWSEditUsersPasswordCrypted', // soapaction
  1222. 'rpc', // style
  1223. 'encoded', // use
  1224. 'This service edits a user' // documentation
  1225. );
  1226. // Define the method DokeosWSEditUsersPasswordCrypted
  1227. function DokeosWSEditUsersPasswordCrypted($params)
  1228. {
  1229. global $userPasswordCrypted,$_configuration,$userPasswordCrypted;
  1230. $secret_key = $params['secret_key'];
  1231. $security_key = $_SERVER['REMOTE_ADDR'].$_configuration['security_key'];
  1232. if (!api_is_valid_secret_key($secret_key,$security_key)) {
  1233. return -1; //secret key is incorrect
  1234. }
  1235. // get user id from id of remote system
  1236. $table_user = Database :: get_main_table(TABLE_MAIN_USER);
  1237. $t_uf = Database::get_main_table(TABLE_MAIN_USER_FIELD);
  1238. $t_ufv = Database::get_main_table(TABLE_MAIN_USER_FIELD_VALUES);
  1239. $users_params = $params['users'];
  1240. $results = array();
  1241. $orig_user_id_value = array();
  1242. foreach($users_params as $user_param) {
  1243. $original_user_id_value = $user_param['original_user_id_value'];
  1244. $original_user_id_name = $user_param['original_user_id_name'];
  1245. $orig_user_id_value[] = $original_user_id_value;
  1246. $firstname = $user_param['firstname'];
  1247. $lastname = $user_param['lastname'];
  1248. $username = $user_param['username'];
  1249. $password = null; $auth_source = null;
  1250. $email = $user_param['email']; $status = $user_param['status'];
  1251. $official_code = ''; $phone = $user_param['phone'];
  1252. $picture_uri = ''; $expiration_date = $user_param['expiration_date']; $active = 1;
  1253. $creator_id= null; $hr_dept_id=0; $extra=null;
  1254. $extra_list = $user_param['extra'];
  1255. if (!empty($user_param['password']) && !empty($user_param['encrypt_method'])) {
  1256. $password = $user_param['password'];
  1257. $encrypt_method = $user_param['encrypt_method'];
  1258. if ($userPasswordCrypted === $encrypt_method ) {
  1259. if ($encrypt_method == 'md5' && !preg_match('/^[A-Fa-f0-9]{32}$/',$password)) {
  1260. $msg = "Encryption $encrypt_method is invalid";
  1261. $results[] = $msg;
  1262. continue;
  1263. } else if ($encrypt_method == 'sha1' && !preg_match('/^[A-Fa-f0-9]{40}$/',$password)) {
  1264. $msg = "Encryption $encrypt_method is invalid";
  1265. $results[] = $msg;
  1266. continue;
  1267. }
  1268. } else {
  1269. $msg = "This encryption $encrypt_method is not configured into dokeos ";
  1270. $results[] = $msg;
  1271. continue;
  1272. }
  1273. } else if(!empty($user_param['password']) && empty($user_param['encrypt_method'])){
  1274. $msg = "If password is not empty the encrypt_method param is required ";
  1275. $results[] = $msg;
  1276. continue;
  1277. } else if(empty($user_param['password']) && !empty($user_param['encrypt_method'])){
  1278. $msg = "If encrypt_method is not empty the password param is required ";
  1279. $results[] = $msg;
  1280. continue;
  1281. }
  1282. $sql = "SELECT user_id FROM $t_uf uf,$t_ufv ufv WHERE ufv.field_id=uf.id AND field_variable='$original_user_id_name' AND field_value='$original_user_id_value'";
  1283. $res = api_sql_query($sql,__FILE__,__LINE__);
  1284. $row = Database::fetch_row($res);
  1285. $user_id = $row[0];
  1286. if (empty($user_id)) {
  1287. $results[] = 0; // original_user_id_value doesn't exits
  1288. continue;
  1289. } else {
  1290. $sql = "SELECT user_id FROM $table_user WHERE user_id ='$user_id' AND active= '0'";
  1291. $resu = api_sql_query($sql,__FILE__,__LINE__);
  1292. $r_check_user = Database::fetch_row($resu);
  1293. if (!empty($r_check_user[0])) {
  1294. $results[] = 0; // user_id is not active
  1295. continue;
  1296. }
  1297. }
  1298. // check if username already exits
  1299. $sql = "SELECT username FROM $table_user WHERE username ='$username' AND user_id <> '$user_id'";
  1300. $res_un = api_sql_query($sql,__FILE__,__LINE__);
  1301. $r_username = Database::fetch_row($res_un);
  1302. if (!empty($r_username[0])) {
  1303. $results[] = 0;
  1304. continue; // username already exits
  1305. }
  1306. $sql = "UPDATE $table_user SET
  1307. lastname='".Database::escape_string($lastname)."',
  1308. firstname='".Database::escape_string($firstname)."',
  1309. username='".Database::escape_string($username)."',";
  1310. if(!is_null($password))
  1311. {
  1312. $sql .= " password='".Database::escape_string($password)."',";
  1313. }
  1314. if(!is_null($auth_source))
  1315. {
  1316. $sql .= " auth_source='".Database::escape_string($auth_source)."',";
  1317. }
  1318. $sql .= "
  1319. email='".Database::escape_string($email)."',
  1320. status='".Database::escape_string($status)."',
  1321. official_code='".Database::escape_string($official_code)."',
  1322. phone='".Database::escape_string($phone)."',
  1323. picture_uri='".Database::escape_string($picture_uri)."',
  1324. expiration_date='".Database::escape_string($expiration_date)."',
  1325. active='".Database::escape_string($active)."',
  1326. hr_dept_id=".intval($hr_dept_id);
  1327. if(!is_null($creator_id))
  1328. {
  1329. $sql .= ", creator_id='".Database::escape_string($creator_id)."'";
  1330. }
  1331. $sql .= " WHERE user_id='$user_id'";
  1332. $return = @api_sql_query($sql,__FILE__,__LINE__);
  1333. if (is_array($extra_list) && count($extra_list) > 0) {
  1334. foreach ($extra_list as $extra) {
  1335. $extra_field_name = $extra['field_name'];
  1336. $extra_field_value = $extra['field_value'];
  1337. // save the external system's id into user_field_value table'
  1338. $res = UserManager::update_extra_field_value($user_id,$extra_field_name,$extra_field_value);
  1339. }
  1340. }
  1341. $results[] = $return;
  1342. continue;
  1343. } //end principal foreach
  1344. $count_results = count($results);
  1345. $output = array();
  1346. for($i = 0; $i < $count_results; $i++) {
  1347. $output[] = array('original_user_id_value' =>$orig_user_id_value[$i],'result' => $results[$i]);
  1348. }
  1349. return $output;
  1350. }
  1351. /* Register DokeosWSEditUserPasswordCrypted function */
  1352. // Register the data structures used by the service
  1353. $server->wsdl->addComplexType(
  1354. 'editUserPasswordCrypted',
  1355. 'complexType',
  1356. 'struct',
  1357. 'all',
  1358. '',
  1359. array(
  1360. 'original_user_id_value' => array('name' => 'original_user_id_value', 'type' => 'xsd:string'),
  1361. 'original_user_id_name' => array('name' => 'original_user_id_name', 'type' => 'xsd:string'),
  1362. 'firstname' => array('name' => 'firstname', 'type' => 'xsd:string'),
  1363. 'lastname' => array('name' => 'lastname', 'type' => 'xsd:string'),
  1364. 'username' => array('name' => 'username', 'type' => 'xsd:string'),
  1365. 'password' => array('name' => 'password', 'type' => 'xsd:string'),
  1366. 'encrypt_method' => array('name' => 'encrypt_method', 'type' => 'xsd:string'),
  1367. 'email' => array('name' => 'email', 'type' => 'xsd:string'),
  1368. 'status' => array('name' => 'status', 'type' => 'xsd:string'),
  1369. 'phone' => array('name' => 'phone', 'type' => 'xsd:string'),
  1370. 'expiration_date' => array('name' => 'expiration_date', 'type' => 'xsd:string'),
  1371. 'extra' => array('name' => 'extra', 'type' => 'tns:extrasList'),
  1372. 'secret_key' => array('name' => 'secret_key', 'type' => 'xsd:string')
  1373. )
  1374. );
  1375. // Register the method to expose
  1376. $server->register('DokeosWSEditUserPasswordCrypted', // method name
  1377. array('editUserPasswordCrypted' => 'tns:editUserPasswordCrypted'), // input parameters
  1378. array('return' => 'xsd:string'), // output parameters
  1379. 'urn:WSRegistration', // namespace
  1380. 'urn:WSRegistration#DokeosWSEditUserPasswordCrypted', // soapaction
  1381. 'rpc', // style
  1382. 'encoded', // use
  1383. 'This service edits a user' // documentation
  1384. );
  1385. // Define the method DokeosWSEditUserPasswordCrypted
  1386. function DokeosWSEditUserPasswordCrypted($params)
  1387. {
  1388. global $userPasswordCrypted,$_configuration,$userPasswordCrypted;
  1389. $secret_key = $params['secret_key'];
  1390. $security_key = $_SERVER['REMOTE_ADDR'].$_configuration['security_key'];
  1391. if (!api_is_valid_secret_key($secret_key,$security_key)) {
  1392. return -1; //secret key is incorrect
  1393. }
  1394. // get user id from id of remote system
  1395. $table_user = Database :: get_main_table(TABLE_MAIN_USER);
  1396. $t_uf = Database::get_main_table(TABLE_MAIN_USER_FIELD);
  1397. $t_ufv = Database::get_main_table(TABLE_MAIN_USER_FIELD_VALUES);
  1398. $original_user_id_value = $params['original_user_id_value'];
  1399. $original_user_id_name = $params['original_user_id_name'];
  1400. $firstname = $params['firstname'];
  1401. $lastname = $params['lastname'];
  1402. $username = $params['username'];
  1403. $password = null; $auth_source = null;
  1404. $email = $params['email']; $status = $params['status'];
  1405. $official_code = ''; $phone = $params['phone'];
  1406. $picture_uri = ''; $expiration_date = $params['expiration_date']; $active = 1;
  1407. $creator_id= null; $hr_dept_id=0; $extra=null;
  1408. $extra_list = $params['extra'];
  1409. if (!empty($params['password']) && !empty($params['encrypt_method'])) {
  1410. $password = $params['password'];
  1411. $encrypt_method = $params['encrypt_method'];
  1412. if ($userPasswordCrypted === $encrypt_method ) {
  1413. if ($encrypt_method == 'md5' && !preg_match('/^[A-Fa-f0-9]{32}$/',$password)) {
  1414. $msg = "Encryption $encrypt_method is invalid";
  1415. return $msg;
  1416. } else if ($encrypt_method == 'sha1' && !preg_match('/^[A-Fa-f0-9]{40}$/',$password)) {
  1417. $msg = "Encryption $encrypt_method is invalid";
  1418. return $msg;
  1419. }
  1420. } else {
  1421. $msg = "This encryption $encrypt_method is not configured into dokeos ";
  1422. return $msg;
  1423. }
  1424. } else if(!empty($params['password']) && empty($params['encrypt_method'])){
  1425. $msg = "If password is not empty the encrypt_method param is required ";
  1426. return $msg;
  1427. } else if(empty($params['password']) && !empty($params['encrypt_method'])){
  1428. $msg = "If encrypt_method is not empty the password param is required ";
  1429. return $msg;
  1430. }
  1431. $sql = "SELECT user_id FROM $t_uf uf,$t_ufv ufv WHERE ufv.field_id=uf.id AND field_variable='$original_user_id_name' AND field_value='$original_user_id_value'";
  1432. $res = api_sql_query($sql,__FILE__,__LINE__);
  1433. $row = Database::fetch_row($res);
  1434. $user_id = $row[0];
  1435. if (empty($user_id)) {
  1436. return 0;
  1437. } else {
  1438. $sql = "SELECT user_id FROM $table_user WHERE user_id ='$user_id' AND active= '0'";
  1439. $resu = api_sql_query($sql,__FILE__,__LINE__);
  1440. $r_check_user = Database::fetch_row($resu);
  1441. if (!empty($r_check_user[0])) {
  1442. return 0;
  1443. }
  1444. }
  1445. // check if username already exits
  1446. $sql = "SELECT username FROM $table_user WHERE username ='$username' AND user_id <> '$user_id'";
  1447. $res_un = api_sql_query($sql,__FILE__,__LINE__);
  1448. $r_username = Database::fetch_row($res_un);
  1449. if (!empty($r_username[0])) {
  1450. return 0;
  1451. }
  1452. $sql = "UPDATE $table_user SET
  1453. lastname='".Database::escape_string($lastname)."',
  1454. firstname='".Database::escape_string($firstname)."',
  1455. username='".Database::escape_string($username)."',";
  1456. if(!is_null($password))
  1457. {
  1458. $sql .= " password='".Database::escape_string($password)."',";
  1459. }
  1460. if(!is_null($auth_source))
  1461. {
  1462. $sql .= " auth_source='".Database::escape_string($auth_source)."',";
  1463. }
  1464. $sql .= "
  1465. email='".Database::escape_string($email)."',
  1466. status='".Database::escape_string($status)."',
  1467. official_code='".Database::escape_string($official_code)."',
  1468. phone='".Database::escape_string($phone)."',
  1469. picture_uri='".Database::escape_string($picture_uri)."',
  1470. expiration_date='".Database::escape_string($expiration_date)."',
  1471. active='".Database::escape_string($active)."',
  1472. hr_dept_id=".intval($hr_dept_id);
  1473. if(!is_null($creator_id))
  1474. {
  1475. $sql .= ", creator_id='".Database::escape_string($creator_id)."'";
  1476. }
  1477. $sql .= " WHERE user_id='$user_id'";
  1478. $return = @api_sql_query($sql,__FILE__,__LINE__);
  1479. if (is_array($extra_list) && count($extra_list) > 0) {
  1480. foreach ($extra_list as $extra) {
  1481. $extra_field_name = $extra['field_name'];
  1482. $extra_field_value = $extra['field_value'];
  1483. // save the external system's id into user_field_value table'
  1484. $res = UserManager::update_extra_field_value($user_id,$extra_field_name,$extra_field_value);
  1485. }
  1486. }
  1487. return $return;
  1488. }
  1489. /* Register DokeosWSDeleteUsers function */
  1490. $server->wsdl->addComplexType(
  1491. 'deleteUsersParam',
  1492. 'complexType',
  1493. 'struct',
  1494. 'all',
  1495. '',
  1496. array(
  1497. 'original_user_id_value' => array('name' => 'original_user_id_value', 'type' => 'xsd:string'),
  1498. 'original_user_id_name' => array('name' => 'original_user_id_name', 'type' => 'xsd:string')
  1499. )
  1500. );
  1501. $server->wsdl->addComplexType(
  1502. 'deleteUsersParamList',
  1503. 'complexType',
  1504. 'array',
  1505. '',
  1506. 'SOAP-ENC:Array',
  1507. array(),
  1508. array(array('ref'=>'SOAP-ENC:arrayType','wsdl:arrayType' => 'tns:deleteUsersParam[]')),'tns:deleteUsersParam'
  1509. );
  1510. // Register the data structures used by the service
  1511. $server->wsdl->addComplexType(
  1512. 'deleteUsers',
  1513. 'complexType',
  1514. 'struct',
  1515. 'all',
  1516. '',
  1517. array(
  1518. 'users' => array('name' => 'users', 'type' => 'tns:deleteUsersParamList'),
  1519. 'secret_key' => array('name' => 'secret_key', 'type' => 'xsd:string')
  1520. )
  1521. );
  1522. // Prepare output params, in this case will return an array
  1523. $server->wsdl->addComplexType(
  1524. 'result_deleteUsers',
  1525. 'complexType',
  1526. 'struct',
  1527. 'all',
  1528. '',
  1529. array(
  1530. 'original_user_id_value' => array('name' => 'original_user_id_value', 'type' => 'xsd:string'),
  1531. 'result' => array('name' => 'result', 'type' => 'xsd:string')
  1532. )
  1533. );
  1534. $server->wsdl->addComplexType(
  1535. 'results_deleteUsers',
  1536. 'complexType',
  1537. 'array',
  1538. '',
  1539. 'SOAP-ENC:Array',
  1540. array(),
  1541. array(array('ref'=>'SOAP-ENC:arrayType','wsdl:arrayType' => 'tns:result_deleteUsers[]')),'tns:result_deleteUsers'
  1542. );
  1543. $server->register('DokeosWSDeleteUsers', // method name
  1544. array('deleteUsers'=>'tns:deleteUsers'), // input parameters
  1545. array('return' => 'tns:results_deleteUsers'),// output parameters
  1546. 'urn:WSRegistration', // namespace
  1547. 'urn:WSRegistration#DokeosWSDeleteUsers', // soapaction
  1548. 'rpc', // style
  1549. 'encoded', // use
  1550. 'This service deletes a user ' // documentation
  1551. );
  1552. // Define the method DokeosWSDeleteUsers
  1553. function DokeosWSDeleteUsers($params)
  1554. {
  1555. global $_configuration;
  1556. $secret_key = $params['secret_key'];
  1557. $security_key = $_SERVER['REMOTE_ADDR'].$_configuration['security_key'];
  1558. if (!api_is_valid_secret_key($secret_key,$security_key)) {
  1559. return -1; //secret key is incorrect
  1560. }
  1561. $table_user = Database :: get_main_table(TABLE_MAIN_USER);
  1562. $t_uf = Database::get_main_table(TABLE_MAIN_USER_FIELD);
  1563. $t_ufv = Database::get_main_table(TABLE_MAIN_USER_FIELD_VALUES);
  1564. $users_params = $params['users'];
  1565. $results = array();
  1566. $orig_user_id_value = array();
  1567. foreach($users_params as $user_param) {
  1568. $original_user_id_name = $user_param['original_user_id_name'];
  1569. $original_user_id_value = $user_param['original_user_id_value'];
  1570. $orig_user_id_value[] = $user_param['original_user_id_value'];
  1571. $sql = "SELECT user_id FROM $t_uf uf,$t_ufv ufv WHERE ufv.field_id=uf.id AND field_variable='$original_user_id_name' AND field_value='$original_user_id_value'";
  1572. $res = api_sql_query($sql,__FILE__,__LINE__);
  1573. $row = Database::fetch_row($res);
  1574. $user_id = $row[0];
  1575. if (empty($user_id)) {
  1576. $results[] = 0;
  1577. continue;
  1578. } else {
  1579. $sql = "SELECT user_id FROM $table_user WHERE user_id ='$user_id' AND active= '0'";
  1580. $resu = api_sql_query($sql,__FILE__,__LINE__);
  1581. $r_check_user = Database::fetch_row($resu);
  1582. if (!empty($r_check_user[0])) {
  1583. $results[] = 0;
  1584. continue;
  1585. }
  1586. }
  1587. // update active to 0
  1588. $sql = "UPDATE $table_user SET active='0' WHERE user_id = '$user_id'";
  1589. $res = api_sql_query($sql,__FILE__,__LINE__);
  1590. $results[] = 1;
  1591. continue;
  1592. }
  1593. $count_results = count($results);
  1594. $output = array();
  1595. for($i = 0; $i < $count_results; $i++) {
  1596. $output[] = array('original_user_id_value' =>$orig_user_id_value[$i],'result' => $results[$i]);
  1597. }
  1598. return $output;
  1599. }
  1600. /* Register DokeosWSDeleteUser function */
  1601. $server->wsdl->addComplexType(
  1602. 'deleteUser',
  1603. 'complexType',
  1604. 'struct',
  1605. 'all',
  1606. '',
  1607. array(
  1608. 'original_user_id_value' => array('name' => 'original_user_id_value', 'type' => 'xsd:string'),
  1609. 'original_user_id_name' => array('name' => 'original_user_id_name', 'type' => 'xsd:string'),
  1610. 'secret_key' => array('name' => 'secret_key', 'type' => 'xsd:string')
  1611. )
  1612. );
  1613. $server->register('DokeosWSDeleteUser', // method name
  1614. array('deleteUser'=>'tns:deleteUser'), // input parameters
  1615. array('return' => 'xsd:string'),// output parameters
  1616. 'urn:WSRegistration', // namespace
  1617. 'urn:WSRegistration#DokeosWSDeleteUser', // soapaction
  1618. 'rpc', // style
  1619. 'encoded', // use
  1620. 'This service deletes a user ' // documentation
  1621. );
  1622. // Define the method DokeosWSDeleteUser
  1623. function DokeosWSDeleteUser($params)
  1624. {
  1625. global $_configuration;
  1626. $secret_key = $params['secret_key'];
  1627. $security_key = $_SERVER['REMOTE_ADDR'].$_configuration['security_key'];
  1628. if (!api_is_valid_secret_key($secret_key,$security_key)) {
  1629. return -1; //secret key is incorrect
  1630. }
  1631. $table_user = Database :: get_main_table(TABLE_MAIN_USER);
  1632. $t_uf = Database::get_main_table(TABLE_MAIN_USER_FIELD);
  1633. $t_ufv = Database::get_main_table(TABLE_MAIN_USER_FIELD_VALUES);
  1634. $original_user_id_name = $params['original_user_id_name'];
  1635. $original_user_id_value = $params['original_user_id_value'];
  1636. $sql = "SELECT user_id FROM $t_uf uf,$t_ufv ufv WHERE ufv.field_id=uf.id AND field_variable='$original_user_id_name' AND field_value='$original_user_id_value'";
  1637. $res = api_sql_query($sql,__FILE__,__LINE__);
  1638. $row = Database::fetch_row($res);
  1639. $user_id = $row[0];
  1640. if (empty($user_id)) {
  1641. return 0;
  1642. } else {
  1643. $sql = "SELECT user_id FROM $table_user WHERE user_id ='$user_id' AND active= '0'";
  1644. $resu = api_sql_query($sql,__FILE__,__LINE__);
  1645. $r_check_user = Database::fetch_row($resu);
  1646. if (!empty($r_check_user[0])) {
  1647. return 0;
  1648. }
  1649. }
  1650. // update active to 0
  1651. $sql = "UPDATE $table_user SET active='0' WHERE user_id = '$user_id'";
  1652. $res = api_sql_query($sql,__FILE__,__LINE__);
  1653. return 1;
  1654. }
  1655. /* Register DokeosWSCreateCourse function */
  1656. // Register the data structures used by the service
  1657. $server->wsdl->addComplexType(
  1658. 'createCourseParams',
  1659. 'complexType',
  1660. 'struct',
  1661. 'all',
  1662. '',
  1663. array(
  1664. 'title' => array('name' => 'title', 'type' => 'xsd:string'),
  1665. 'category_code' => array('name' => 'category_code', 'type' => 'xsd:string'),
  1666. 'wanted_code' => array('name' => 'wanted_code', 'type' => 'xsd:string'),
  1667. 'tutor_name' => array('name' => 'tutor_name', 'type' => 'xsd:string'),
  1668. 'course_language' => array('name' => 'course_language', 'type' => 'xsd:string'),
  1669. 'original_course_id_name' => array('name' => 'original_course_id_name', 'type' => 'xsd:string'),
  1670. 'original_course_id_value' => array('name' => 'original_course_id_value', 'type' => 'xsd:string'),
  1671. 'extra' => array('name' => 'extra', 'type' => 'tns:extrasList')
  1672. )
  1673. );
  1674. $server->wsdl->addComplexType(
  1675. 'createCourseParamsList',
  1676. 'complexType',
  1677. 'array',
  1678. '',
  1679. 'SOAP-ENC:Array',
  1680. array(),
  1681. array(array('ref'=>'SOAP-ENC:arrayType','wsdl:arrayType' => 'tns:createCourseParams[]')),'tns:createCourseParams'
  1682. );
  1683. // Register the data structures used by the service
  1684. $server->wsdl->addComplexType(
  1685. 'createCourse',
  1686. 'complexType',
  1687. 'struct',
  1688. 'all',
  1689. '',
  1690. array(
  1691. 'courses' => array('name' => 'courses', 'type' => 'tns:createCourseParamsList'),
  1692. 'secret_key' => array('name' => 'secret_key', 'type' => 'xsd:string')
  1693. )
  1694. );
  1695. // Prepare output params, in this case will return an array
  1696. $server->wsdl->addComplexType(
  1697. 'result_createCourse',
  1698. 'complexType',
  1699. 'struct',
  1700. 'all',
  1701. '',
  1702. array(
  1703. 'original_course_id_value' => array('name' => 'original_course_id_value', 'type' => 'xsd:string'),
  1704. 'result' => array('name' => 'result', 'type' => 'xsd:string')
  1705. )
  1706. );
  1707. $server->wsdl->addComplexType(
  1708. 'results_createCourse',
  1709. 'complexType',
  1710. 'array',
  1711. '',
  1712. 'SOAP-ENC:Array',
  1713. array(),
  1714. array(array('ref'=>'SOAP-ENC:arrayType','wsdl:arrayType' => 'tns:result_createCourse[]')),'tns:result_createCourse'
  1715. );
  1716. // Register the method to expose
  1717. $server->register('DokeosWSCreateCourse', // method name
  1718. array('createCourse' => 'tns:createCourse'), // input parameters
  1719. array('return' => 'tns:results_createCourse'), // output parameters
  1720. 'urn:WSRegistration', // namespace
  1721. 'urn:WSRegistration#DokeosWSCreateCourse', // soapaction
  1722. 'rpc', // style
  1723. 'encoded', // use
  1724. 'This service adds a course into dokeos ' // documentation
  1725. );
  1726. // Define the method DokeosWSCreateCourse
  1727. function DokeosWSCreateCourse($params) {
  1728. global $firstExpirationDelay,$_configuration;
  1729. $secret_key = $params['secret_key'];
  1730. $security_key = $_SERVER['REMOTE_ADDR'].$_configuration['security_key'];
  1731. //return $secret_key;
  1732. if (!api_is_valid_secret_key($secret_key,$security_key)) {
  1733. return -1; //secret key is incorrect
  1734. }
  1735. $t_cfv = Database::get_main_table(TABLE_MAIN_COURSE_FIELD_VALUES);
  1736. $table_field = Database::get_main_table(TABLE_MAIN_COURSE_FIELD);
  1737. $table_course_category = Database :: get_main_table(TABLE_MAIN_CATEGORY);
  1738. $table_course = Database :: get_main_table(TABLE_MAIN_COURSE);
  1739. $courses_params = $params['courses'];
  1740. $results = array();
  1741. $orig_course_id_value = array();
  1742. foreach($courses_params as $course_param) {
  1743. $title=$course_param['title'];
  1744. $category_code=$course_param['category_code'];
  1745. $wanted_code=$course_param['wanted_code'];
  1746. $tutor_name=$course_param['tutor_name'];
  1747. $course_language='english';
  1748. $original_course_id_name= $course_param['original_course_id_name'];
  1749. $original_course_id_value = $course_param['original_course_id_value'];
  1750. $orig_course_id_value[] = $course_param['original_course_id_value'];
  1751. $extra_list = $course_param['extra'];
  1752. // check if exits $x_course_code into user_field_values table
  1753. $sql = "SELECT field_value,course_code FROM $table_field cf,$t_cfv cfv WHERE cfv.field_id=cf.id AND field_variable='$original_course_id_name' AND field_value='$original_course_id_value'";
  1754. $res = api_sql_query($sql,__FILE__,__LINE__);
  1755. $row = Database::fetch_row($res);
  1756. if (!empty($row[0])) {
  1757. // check if user is not active
  1758. $sql = "SELECT code FROM $table_course WHERE code ='".$row[1]."' AND visibility= '0'";
  1759. $resu = api_sql_query($sql,__FILE__,__LINE__);
  1760. $r_check_course = Database::fetch_row($resu);
  1761. if (!empty($r_check_course[0])) {
  1762. $sql = "UPDATE $table_course SET course_language='".Database::escape_string($course_language)."',
  1763. title='".Database::escape_string($title)."',
  1764. category_code='".Database::escape_string($category_code)."',
  1765. tutor_name='".Database::escape_string($tutor_name)."',
  1766. visual_code='".Database::escape_string($wanted_code)."',
  1767. visibility = '3'
  1768. WHERE code='".Database::escape_string($r_check_course[0])."'";
  1769. api_sql_query($sql,__FILE__,__LINE__);
  1770. if (is_array($extra_list) && count($extra_list) > 0) {
  1771. foreach ($extra_list as $extra) {
  1772. $extra_field_name = $extra['field_name'];
  1773. $extra_field_value = $extra['field_value'];
  1774. // save the external system's id into course_field_value table'
  1775. $res = CourseManager::update_course_extra_field_value($r_check_course[0],$extra_field_name,$extra_field_value);
  1776. }
  1777. }
  1778. $results[] = $r_check_course[0];
  1779. continue;
  1780. } else {
  1781. $results[] = 0;
  1782. continue; // original course id already exits
  1783. }
  1784. }
  1785. if (!empty($course_param['course_language'])) {
  1786. $course_language = $course_param['course_language'];
  1787. }
  1788. $dbnamelength = strlen($_configuration['db_prefix']);
  1789. //Ensure the database prefix + database name do not get over 40 characters
  1790. $maxlength = 40 - $dbnamelength;
  1791. // Set default values
  1792. if (isset($_user["language"]) && $_user["language"]!="") {
  1793. $values['course_language'] = $_user["language"];
  1794. } else {
  1795. $values['course_language'] = get_setting('platformLanguage');
  1796. }
  1797. $values['tutor_name'] = $_user['firstName']." ".$_user['lastName'];
  1798. if (trim($wanted_code) == '') {
  1799. $wanted_code = generate_course_code(substr($title,0,$maxlength));
  1800. }
  1801. $keys = define_course_keys($wanted_code, "", $_configuration['db_prefix']);
  1802. $sql_check = sprintf('SELECT * FROM '.$table_course.' WHERE visual_code = "%s"',Database :: escape_string($wanted_code));
  1803. $result_check = api_sql_query($sql_check,__FILE__,__LINE__); //I don't know why this api function doesn't work...
  1804. if ( Database::num_rows($result_check)<1 ) {
  1805. if (sizeof($keys)) {
  1806. $visual_code = $keys["currentCourseCode"];
  1807. $code = $keys["currentCourseId"];
  1808. $db_name = $keys["currentCourseDbName"];
  1809. $directory = $keys["currentCourseRepository"];
  1810. $expiration_date = time() + $firstExpirationDelay;
  1811. prepare_course_repository($directory, $code);
  1812. update_Db_course($db_name);
  1813. $pictures_array=fill_course_repository($directory);
  1814. fill_Db_course($db_name, $directory, $course_language,$pictures_array);
  1815. $return = register_course($code, $visual_code, $directory, $db_name, $tutor_name, $category_code, $title, $course_language, api_get_user_id(), $expiration_date);
  1816. // save new fieldlabel into course_field table
  1817. $field_id = CourseManager::create_course_extra_field($original_course_id_name,1,$original_course_id_name);
  1818. // save the external system's id into user_field_value table'
  1819. $res = CourseManager::update_course_extra_field_value($code,$original_course_id_name,$original_course_id_value);
  1820. if (is_array($extra_list) && count($extra_list) > 0) {
  1821. foreach ($extra_list as $extra) {
  1822. $extra_field_name = $extra['field_name'];
  1823. $extra_field_value = $extra['field_value'];
  1824. // save new fieldlabel into course_field table
  1825. $field_id = CourseManager::create_course_extra_field($extra_field_name,1,$extra_field_name);
  1826. // save the external system's id into course_field_value table'
  1827. $res = CourseManager::update_course_extra_field_value($code,$extra_field_name,$extra_field_value);
  1828. }
  1829. }
  1830. }
  1831. $results[] = $code;
  1832. continue;
  1833. } else {
  1834. $results[] = 0;
  1835. continue;
  1836. }
  1837. }// end principal foreach
  1838. $count_results = count($results);
  1839. $output = array();
  1840. for($i = 0; $i < $count_results; $i++) {
  1841. $output[] = array('original_course_id_value' =>$orig_course_id_value[$i],'result' => $results[$i]);
  1842. }
  1843. return $output;
  1844. }
  1845. /* Register DokeosWSCreateCourseByTitle function */
  1846. // Register the data structures used by the service
  1847. $server->wsdl->addComplexType(
  1848. 'createCourseByTitleParams',
  1849. 'complexType',
  1850. 'struct',
  1851. 'all',
  1852. '',
  1853. array(
  1854. 'title' => array('name' => 'title', 'type' => 'xsd:string'),
  1855. 'tutor_name' => array('name' => 'tutor_name', 'type' => 'xsd:string'),
  1856. 'original_course_id_name' => array('name' => 'original_course_id_name', 'type' => 'xsd:string'),
  1857. 'original_course_id_value' => array('name' => 'original_course_id_value', 'type' => 'xsd:string'),
  1858. 'extra' => array('name' => 'extra', 'type' => 'tns:extrasList')
  1859. )
  1860. );
  1861. $server->wsdl->addComplexType(
  1862. 'createCourseByTitleParamsList',
  1863. 'complexType',
  1864. 'array',
  1865. '',
  1866. 'SOAP-ENC:Array',
  1867. array(),
  1868. array(array('ref'=>'SOAP-ENC:arrayType','wsdl:arrayType' => 'tns:createCourseByTitleParams[]')),'tns:createCourseByTitleParams'
  1869. );
  1870. // Register the data structures used by the service
  1871. $server->wsdl->addComplexType(
  1872. 'createCourseByTitle',
  1873. 'complexType',
  1874. 'struct',
  1875. 'all',
  1876. '',
  1877. array(
  1878. 'courses' => array('name' => 'courses', 'type' => 'tns:createCourseByTitleParamsList'),
  1879. 'secret_key' => array('name' => 'secret_key', 'type' => 'xsd:string')
  1880. )
  1881. );
  1882. // Prepare output params, in this case will return an array
  1883. $server->wsdl->addComplexType(
  1884. 'result_createCourseByTitle',
  1885. 'complexType',
  1886. 'struct',
  1887. 'all',
  1888. '',
  1889. array(
  1890. 'original_course_id_value' => array('name' => 'original_course_id_value', 'type' => 'xsd:string'),
  1891. 'result' => array('name' => 'result', 'type' => 'xsd:string')
  1892. )
  1893. );
  1894. $server->wsdl->addComplexType(
  1895. 'results_createCourseByTitle',
  1896. 'complexType',
  1897. 'array',
  1898. '',
  1899. 'SOAP-ENC:Array',
  1900. array(),
  1901. array(array('ref'=>'SOAP-ENC:arrayType','wsdl:arrayType' => 'tns:result_createCourseByTitle[]')),'tns:result_createCourseByTitle'
  1902. );
  1903. // Register the method to expose
  1904. $server->register('DokeosWSCreateCourseByTitle', // method name
  1905. array('createCourseByTitle' => 'tns:createCourseByTitle'), // input parameters
  1906. array('return' => 'tns:results_createCourseByTitle'), // output parameters
  1907. 'urn:WSRegistration', // namespace
  1908. 'urn:WSRegistration#DokeosWSCreateCourseByTitle', // soapaction
  1909. 'rpc', // style
  1910. 'encoded', // use
  1911. 'This service adds a course by title into dokeos ' // documentation
  1912. );
  1913. // Define the method DokeosWSCreateCourseByTitle
  1914. function DokeosWSCreateCourseByTitle($params) {
  1915. global $firstExpirationDelay,$_configuration;
  1916. $secret_key = $params['secret_key'];
  1917. $security_key = $_SERVER['REMOTE_ADDR'].$_configuration['security_key'];
  1918. if (!api_is_valid_secret_key($secret_key,$security_key)) {
  1919. return -1; //secret key is incorrect
  1920. }
  1921. $t_cfv = Database::get_main_table(TABLE_MAIN_COURSE_FIELD_VALUES);
  1922. $table_field = Database::get_main_table(TABLE_MAIN_COURSE_FIELD);
  1923. $table_course_category = Database::get_main_table(TABLE_MAIN_CATEGORY);
  1924. $table_course = Database::get_main_table(TABLE_MAIN_COURSE);
  1925. $courses_params = $params['courses'];
  1926. $results = array();
  1927. $orig_course_id_value = array();
  1928. foreach($courses_params as $course_param) {
  1929. $title = $course_param['title'];
  1930. $category_code='LANG';
  1931. $wanted_code = '';
  1932. $tutor_firstname = api_get_setting('administratorName');
  1933. $tutor_lastname = api_get_setting('administratorSurname');
  1934. $tutor_name = $tutor_firstname.' '.$tutor_lastname;
  1935. if (!empty($course_param['tutor_name'])) {
  1936. $tutor_name = $course_param['tutor_name'];
  1937. }
  1938. $course_language = 'spanish';
  1939. if (!empty($course_param['course_language'])) {
  1940. $course_language = $course_param['course_language'];
  1941. }
  1942. $original_course_id_name = $course_param['original_course_id_name'];
  1943. $original_course_id_value = $course_param['original_course_id_value'];
  1944. $orig_course_id_value[] = $course_param['original_course_id_value'];
  1945. $extra_list = $course_param['extra'];
  1946. $dbnamelength = strlen($_configuration['db_prefix']);
  1947. //Ensure the database prefix + database name do not get over 40 characters
  1948. $maxlength = 40 - $dbnamelength;
  1949. if (empty($wanted_code)) {
  1950. $wanted_code = generate_course_code(substr($title,0,$maxlength));
  1951. }
  1952. // check if exits $x_course_code into user_field_values table
  1953. $sql = "SELECT field_value,course_code FROM $table_field cf,$t_cfv cfv WHERE cfv.field_id=cf.id AND field_variable='$original_course_id_name' AND field_value='$original_course_id_value'";
  1954. $res = api_sql_query($sql,__FILE__,__LINE__);
  1955. $row = Database::fetch_row($res);
  1956. if (!empty($row[0])) {
  1957. // check if user is not active
  1958. $sql = "SELECT code FROM $table_course WHERE code ='".$row[1]."' AND visibility= '0'";
  1959. $resu = api_sql_query($sql,__FILE__,__LINE__);
  1960. $r_check_course = Database::fetch_row($resu);
  1961. if (!empty($r_check_course[0])) {
  1962. $sql = "UPDATE $table_course SET course_language='".Database::escape_string($course_language)."',
  1963. title='".Database::escape_string($title)."',
  1964. category_code='".Database::escape_string($category_code)."',
  1965. tutor_name='".Database::escape_string($tutor_name)."',
  1966. visual_code='".Database::escape_string($wanted_code)."',
  1967. visibility = '3'
  1968. WHERE code='".Database::escape_string($r_check_course[0])."'";
  1969. api_sql_query($sql,__FILE__,__LINE__);
  1970. $results[] = $r_check_course[0];
  1971. continue;
  1972. } else {
  1973. $results[] = 0;
  1974. continue;
  1975. }
  1976. }
  1977. // Set default values
  1978. if (isset($_user["language"]) && $_user["language"]!="") {
  1979. $values['course_language'] = $_user["language"];
  1980. } else {
  1981. $values['course_language'] = get_setting('platformLanguage');
  1982. }
  1983. $values['tutor_name'] = $_user['firstName']." ".$_user['lastName'];
  1984. $keys = define_course_keys($wanted_code, "", $_configuration['db_prefix']);
  1985. $sql_check = sprintf('SELECT * FROM '.$table_course.' WHERE visual_code = "%s"',Database :: escape_string($wanted_code));
  1986. $result_check = api_sql_query($sql_check,__FILE__,__LINE__); //I don't know why this api function doesn't work...
  1987. if ( Database::num_rows($result_check)<1 ) {
  1988. if (sizeof($keys)) {
  1989. $visual_code = $keys["currentCourseCode"];
  1990. $code = $keys["currentCourseId"];
  1991. $db_name = $keys["currentCourseDbName"];
  1992. $directory = $keys["currentCourseRepository"];
  1993. $expiration_date = time() + $firstExpirationDelay;
  1994. prepare_course_repository($directory, $code);
  1995. update_Db_course($db_name);
  1996. $pictures_array=fill_course_repository($directory);
  1997. fill_Db_course($db_name, $directory, $course_language,$pictures_array);
  1998. $return = register_course($code, $visual_code, $directory, $db_name, $tutor_name, $category_code, $title, $course_language, api_get_user_id(), $expiration_date);
  1999. // save new fieldlabel into course_field table
  2000. $field_id = CourseManager::create_course_extra_field($original_course_id_name,1,$original_course_id_name);
  2001. // save the external system's id into user_field_value table'
  2002. $res = CourseManager::update_course_extra_field_value($code,$original_course_id_name,$original_course_id_value);
  2003. if (is_array($extra_list) && count($extra_list) > 0) {
  2004. foreach ($extra_list as $extra) {
  2005. $extra_field_name = $extra['field_name'];
  2006. $extra_field_value = $extra['field_value'];
  2007. // save new fieldlabel into course_field table
  2008. $field_id = CourseManager::create_course_extra_field($extra_field_name,1,$extra_field_name);
  2009. // save the external system's id into course_field_value table'
  2010. $res = CourseManager::update_course_extra_field_value($code,$extra_field_name,$extra_field_value);
  2011. }
  2012. }
  2013. }
  2014. $results[] = $code;
  2015. continue;
  2016. } else {
  2017. $results[] = 0;
  2018. continue;
  2019. }
  2020. } // end principal foreach
  2021. $count_results = count($results);
  2022. $output = array();
  2023. for($i = 0; $i < $count_results; $i++) {
  2024. $output[] = array('original_course_id_value' =>$orig_course_id_value[$i],'result' => $results[$i]);
  2025. }
  2026. return $output;
  2027. }
  2028. /* Register DokeosWSEditCourse function */
  2029. // Register the data structures used by the service
  2030. $server->wsdl->addComplexType(
  2031. 'editCourseParams',
  2032. 'complexType',
  2033. 'struct',
  2034. 'all',
  2035. '',
  2036. array(
  2037. 'tutor_id' => array('name' => 'tutor_id', 'type' => 'xsd:string'),
  2038. 'title' => array('name' => 'title', 'type' => 'xsd:string'),
  2039. 'category_code' => array('name' => 'category_code', 'type' => 'xsd:string'),
  2040. 'department_name' => array('name' => 'department_name', 'type' => 'xsd:string'),
  2041. 'department_url' => array('name' => 'department_url', 'type' => 'xsd:string'),
  2042. 'course_language' => array('name' => 'course_language', 'type' => 'xsd:string'),
  2043. 'visibility' => array('name' => 'visibility', 'type' => 'xsd:string'),
  2044. 'subscribe' => array('name' => 'subscribe', 'type' => 'xsd:string'),
  2045. 'unsubscribe' => array('name' => 'unsubscribe', 'type' => 'xsd:string'),
  2046. 'visual_code' => array('name' => 'visual_code', 'type' => 'xsd:string'),
  2047. 'original_course_id_name' => array('name' => 'original_course_id_name', 'type' => 'xsd:string'),
  2048. 'original_course_id_value' => array('name' => 'original_course_id_value', 'type' => 'xsd:string'),
  2049. 'extra' => array('name' => 'extra', 'type' => 'tns:extrasList')
  2050. )
  2051. );
  2052. $server->wsdl->addComplexType(
  2053. 'editCourseParamsList',
  2054. 'complexType',
  2055. 'array',
  2056. '',
  2057. 'SOAP-ENC:Array',
  2058. array(),
  2059. array(array('ref'=>'SOAP-ENC:arrayType','wsdl:arrayType' => 'tns:editCourseParams[]')),'tns:editCourseParams'
  2060. );
  2061. $server->wsdl->addComplexType(
  2062. 'editCourse',
  2063. 'complexType',
  2064. 'struct',
  2065. 'all',
  2066. '',
  2067. array(
  2068. 'courses' => array('name' => 'courses', 'type' => 'tns:editCourseParamsList'),
  2069. 'secret_key' => array('name' => 'secret_key', 'type' => 'xsd:string')
  2070. )
  2071. );
  2072. // Prepare output params, in this case will return an array
  2073. $server->wsdl->addComplexType(
  2074. 'result_editCourse',
  2075. 'complexType',
  2076. 'struct',
  2077. 'all',
  2078. '',
  2079. array(
  2080. 'original_course_id_value' => array('name' => 'original_course_id_value', 'type' => 'xsd:string'),
  2081. 'result' => array('name' => 'result', 'type' => 'xsd:string')
  2082. )
  2083. );
  2084. $server->wsdl->addComplexType(
  2085. 'results_editCourse',
  2086. 'complexType',
  2087. 'array',
  2088. '',
  2089. 'SOAP-ENC:Array',
  2090. array(),
  2091. array(array('ref'=>'SOAP-ENC:arrayType','wsdl:arrayType' => 'tns:result_editCourse[]')),'tns:result_editCourse'
  2092. );
  2093. // Register the method to expose
  2094. $server->register('DokeosWSEditCourse', // method name
  2095. array('editCourse' => 'tns:editCourse'), // input parameters
  2096. array('return' => 'tns:results_editCourse'), // output parameters
  2097. 'urn:WSRegistration', // namespace
  2098. 'urn:WSRegistration#DokeosWSEditCourse', // soapaction
  2099. 'rpc', // style
  2100. 'encoded', // use
  2101. 'This service edits a course into dokeos' // documentation
  2102. );
  2103. // Define the method DokeosWSEditCourse
  2104. function DokeosWSEditCourse($params){
  2105. global $_configuration;
  2106. $secret_key = $params['secret_key'];
  2107. $security_key = $_SERVER['REMOTE_ADDR'].$_configuration['security_key'];
  2108. if (!api_is_valid_secret_key($secret_key,$security_key)) {
  2109. return -1; //secret key is incorrect
  2110. }
  2111. $course_table = Database::get_main_table(TABLE_MAIN_COURSE);
  2112. $course_user_table = Database::get_main_table(TABLE_MAIN_COURSE_USER);
  2113. $t_cfv = Database::get_main_table(TABLE_MAIN_COURSE_FIELD_VALUES);
  2114. $table_field = Database::get_main_table(TABLE_MAIN_COURSE_FIELD);
  2115. $courses_params = $params['courses'];
  2116. $results = array();
  2117. $orig_course_id_value = array();
  2118. foreach($courses_params as $course_param) {
  2119. $tutor_id=$course_param['tutor_id'];
  2120. $title=$course_param['title'];
  2121. $category_code =$course_param['category_code'];
  2122. $department_name =$course_param['department_name'];
  2123. $department_url =$course_param['department_url'];
  2124. $course_language =$course_param['course_language'];
  2125. $visibility=$course_param['visibility'];
  2126. $subscribe=$course_param['subscribe'];
  2127. $unsubscribe=$course_param['unsubscribe'];
  2128. $visual_code = $course_param['visual_code'];
  2129. $original_course_id_name = $course_param['original_course_id_name'];
  2130. $original_course_id_value = $course_param['original_course_id_value'];
  2131. $orig_course_id_value[] = $original_course_id_value;
  2132. $extra_list = $course_param['extra'];
  2133. // get course code from id from remote system
  2134. $sql = "SELECT course_code FROM $table_field cf,$t_cfv cfv WHERE cfv.field_id=cf.id AND field_variable='$original_course_id_name' AND field_value='$original_course_id_value'";
  2135. $res = api_sql_query($sql,__FILE__,__LINE__);
  2136. $row = Database::fetch_row($res);
  2137. $course_code=$row[0];
  2138. if (empty($course_code)) {
  2139. $results[] = 0; // original_course_id_value doesn't exits
  2140. continue;
  2141. }
  2142. $table_user = Database :: get_main_table(TABLE_MAIN_USER);
  2143. $sql = "SELECT concat(lastname,'',firstname) as tutor_name FROM $table_user WHERE status='1' AND user_id = '$tutor_id' ORDER BY lastname,firstname";
  2144. $res = api_sql_query($sql,__FILE__,__LINE__);
  2145. $tutor_name = Database::fetch_row($res);
  2146. $dbnamelength = strlen($_configuration['db_prefix']);
  2147. $maxlength = 40 - $dbnamelength;
  2148. if (empty($visual_code)) {
  2149. $visual_code = generate_course_code(substr($title,0,$maxlength));
  2150. }
  2151. $disk_quota = '50000';
  2152. $tutor_name=$tutor_name[0];
  2153. $sql = "UPDATE $course_table SET course_language='".Database::escape_string($course_language)."',
  2154. title='".Database::escape_string($title)."',
  2155. category_code='".Database::escape_string($category_code)."',
  2156. tutor_name='".Database::escape_string($tutor_name)."',
  2157. visual_code='".Database::escape_string($visual_code)."',
  2158. department_name='".Database::escape_string($department_name)."',
  2159. department_url='".Database::escape_string($department_url)."',
  2160. disk_quota='".Database::escape_string($disk_quota)."',
  2161. visibility = '".Database::escape_string($visibility)."',
  2162. subscribe = '".Database::escape_string($subscribe)."',
  2163. unsubscribe='".Database::escape_string($unsubscribe)."'
  2164. WHERE code='".Database::escape_string($course_code)."'";
  2165. $res = api_sql_query($sql, __FILE__, __LINE__);
  2166. if (is_array($extra_list) && count($extra_list) > 0) {
  2167. foreach ($extra_list as $extra) {
  2168. $extra_field_name = $extra['field_name'];
  2169. $extra_field_value = $extra['field_value'];
  2170. // save the external system's id into course_field_value table'
  2171. $res = CourseManager::update_course_extra_field_value($course_code,$extra_field_name,$extra_field_value);
  2172. }
  2173. }
  2174. if ($res) {
  2175. $results[] = 1;
  2176. continue;
  2177. } else {
  2178. $results[] = 0;
  2179. continue;
  2180. }
  2181. }// end principal foreach
  2182. $count_results = count($results);
  2183. $output = array();
  2184. for($i = 0; $i < $count_results; $i++) {
  2185. $output[] = array('original_course_id_value' =>$orig_course_id_value[$i],'result' => $results[$i]);
  2186. }
  2187. return $output;
  2188. }
  2189. /* Register DokeosWSCourseDescription function */
  2190. // Register the data structures used by the service
  2191. $server->wsdl->addComplexType(
  2192. 'courseDescription',
  2193. 'complexType',
  2194. 'struct',
  2195. 'all',
  2196. '',
  2197. array(
  2198. 'original_course_id_name' => array('name' => 'original_course_id_name', 'type' => 'xsd:string'),
  2199. 'original_course_id_value' => array('name' => 'original_course_id_value', 'type' => 'xsd:string'),
  2200. 'secret_key' => array('name' => 'secret_key', 'type' => 'xsd:string')
  2201. )
  2202. );
  2203. // Prepare output params, in this case will return an array
  2204. $server->wsdl->addComplexType(
  2205. 'fields_course_desc',
  2206. 'complexType',
  2207. 'struct',
  2208. 'all',
  2209. '',
  2210. array(
  2211. 'course_desc_id' => array('name' => 'course_desc_id', 'type' => 'xsd:string'),
  2212. 'course_desc_default_title' => array('name' => 'course_desc_default_title', 'type' => 'xsd:string'),
  2213. 'course_desc_title' => array('name' => 'course_desc_title', 'type' => 'xsd:string'),
  2214. 'course_desc_content' => array('name' => 'course_desc_content', 'type' => 'xsd:string')
  2215. )
  2216. );
  2217. $server->wsdl->addComplexType(
  2218. 'fields_course_desc_list',
  2219. 'complexType',
  2220. 'array',
  2221. '',
  2222. 'SOAP-ENC:Array',
  2223. array(),
  2224. array(array('ref'=>'SOAP-ENC:arrayType','wsdl:arrayType' => 'tns:fields_course_desc[]')),'tns:fields_course_desc'
  2225. );
  2226. // Register the method to expose
  2227. $server->register('DokeosWSCourseDescription', // method name
  2228. array('courseDescription' => 'tns:courseDescription'), // input parameters
  2229. array('return' => 'tns:fields_course_desc_list'), // output parameters
  2230. 'urn:WSRegistration', // namespace
  2231. 'urn:WSRegistration#DokeosWSCourseDescription', // soapaction
  2232. 'rpc', // style
  2233. 'encoded', // use
  2234. 'This service edits a course description into dokeos' // documentation
  2235. );
  2236. // Define the method DokeosWSCourseDescription
  2237. function DokeosWSCourseDescription($params){
  2238. global $_configuration,$_course;
  2239. $secret_key = $params['secret_key'];
  2240. $security_key = $_SERVER['REMOTE_ADDR'].$_configuration['security_key'];
  2241. if (!api_is_valid_secret_key($secret_key,$security_key)) {
  2242. return -1; //secret key is incorrect
  2243. }
  2244. $course_table = Database::get_main_table(TABLE_MAIN_COURSE);
  2245. $course_user_table = Database::get_main_table(TABLE_MAIN_COURSE_USER);
  2246. $t_cfv = Database::get_main_table(TABLE_MAIN_COURSE_FIELD_VALUES);
  2247. $table_field = Database::get_main_table(TABLE_MAIN_COURSE_FIELD);
  2248. $array_course_desc_id = array();
  2249. $array_course__desc_default_title = array();
  2250. $array_course_desc_title = array();
  2251. $array_course_desc_content = array();
  2252. $original_course_id_name = $params['original_course_id_name'];
  2253. $original_course_id_value = $params['original_course_id_value'];
  2254. // get course code from id from remote system
  2255. $sql = "SELECT course_code FROM $table_field cf,$t_cfv cfv WHERE cfv.field_id=cf.id AND field_variable='$original_course_id_name' AND field_value='$original_course_id_value'";
  2256. $res = api_sql_query($sql,__FILE__,__LINE__);
  2257. $row = Database::fetch_row($res);
  2258. $course_code=$row[0];
  2259. if (Database::num_rows($res) < 1) {
  2260. return 0;// original_course_id_value doesn't exits
  2261. //continue;
  2262. } else {
  2263. $sql = "SELECT code FROM $course_table WHERE code ='$course_code' AND visibility = '0'";
  2264. $resu = api_sql_query($sql,__FILE__,__LINE__);
  2265. $r_check_code = Database::fetch_row($resu);
  2266. if (Database::num_rows($resu) > 0) {
  2267. return 0; // this code is not active
  2268. //continue;
  2269. }
  2270. }
  2271. $course_ifo = api_get_course_info($course_code);
  2272. $t_course_desc = Database::get_course_table(TABLE_COURSE_DESCRIPTION,$course_ifo['dbName']);
  2273. $sql = "SELECT * FROM $t_course_desc";
  2274. $result = api_sql_query($sql,__FILE__,__LINE__);
  2275. /*$default_titles = array(
  2276. get_lang('GeneralDescription'),
  2277. get_lang('Objectives'),
  2278. get_lang('Topics'),
  2279. get_lang('Methodology'),
  2280. get_lang('CourseMaterial'),
  2281. get_lang('HumanAndTechnicalResources'),
  2282. get_lang('Assessment'),
  2283. get_lang('AddCat'));*/
  2284. $default_titles = array('Descripcion general','Objetivos','Contenidos','Metodologia','Materiales','Recursos humanos y tecnicos','Evaluacion','Apartado');
  2285. for ($x = 1;$x < 9; $x++){
  2286. $array_course_desc_id[$x] = $x;
  2287. $array_course_desc_default_title[$x] = $default_titles[$x-1];
  2288. $array_course_desc_title[$x] = '';
  2289. $array_course_desc_content[$x] = '';
  2290. }
  2291. while ($row = Database::fetch_array($result)) {
  2292. $ind = (int)$row['id'];
  2293. $array_course_desc_title[$ind] = $row['title'];
  2294. $array_course_desc_content[$ind] = $row['content'];
  2295. }
  2296. $count_results = count($default_titles);
  2297. $output = array();
  2298. for($i = 1; $i <=$count_results; $i++) {
  2299. $output[] = array(
  2300. 'course_desc_id' =>$array_course_desc_id[$i],
  2301. 'course_desc_default_title' => $array_course_desc_default_title[$i],
  2302. 'course_desc_title' => $array_course_desc_title[$i],
  2303. 'course_desc_content' => $array_course_desc_content[$i]);
  2304. }
  2305. return $output;
  2306. }
  2307. /* Register DokeosWSEditCourseDescription function */
  2308. // Register the data structures used by the service
  2309. $server->wsdl->addComplexType(
  2310. 'editCourseDescriptionParams',
  2311. 'complexType',
  2312. 'struct',
  2313. 'all',
  2314. '',
  2315. array(
  2316. 'course_desc_id' => array('name' => 'course_desc_id', 'type' => 'xsd:string'),
  2317. 'course_desc_title' => array('name' => 'course_desc_title', 'type' => 'xsd:string'),
  2318. 'course_desc_content' => array('name' => 'course_desc_content', 'type' => 'xsd:string'),
  2319. 'original_course_id_name' => array('name' => 'original_course_id_name', 'type' => 'xsd:string'),
  2320. 'original_course_id_value' => array('name' => 'original_course_id_value', 'type' => 'xsd:string')
  2321. )
  2322. );
  2323. $server->wsdl->addComplexType(
  2324. 'editCourseDescriptionParamsList',
  2325. 'complexType',
  2326. 'array',
  2327. '',
  2328. 'SOAP-ENC:Array',
  2329. array(),
  2330. array(array('ref'=>'SOAP-ENC:arrayType','wsdl:arrayType' => 'tns:editCourseDescriptionParams[]')),'tns:editCourseDescriptionParams'
  2331. );
  2332. $server->wsdl->addComplexType(
  2333. 'editCourseDescription',
  2334. 'complexType',
  2335. 'struct',
  2336. 'all',
  2337. '',
  2338. array(
  2339. 'course_desc' => array('name' => 'course_desc', 'type' => 'tns:editCourseDescriptionParamsList'),
  2340. 'secret_key' => array('name' => 'secret_key', 'type' => 'xsd:string')
  2341. )
  2342. );
  2343. // Prepare output params, in this case will return an array
  2344. $server->wsdl->addComplexType(
  2345. 'result_editCourseDescription',
  2346. 'complexType',
  2347. 'struct',
  2348. 'all',
  2349. '',
  2350. array(
  2351. 'original_course_id_value' => array('name' => 'original_course_id_value', 'type' => 'xsd:string'),
  2352. 'result' => array('name' => 'result', 'type' => 'xsd:string')
  2353. )
  2354. );
  2355. $server->wsdl->addComplexType(
  2356. 'results_editCourseDescription',
  2357. 'complexType',
  2358. 'array',
  2359. '',
  2360. 'SOAP-ENC:Array',
  2361. array(),
  2362. array(array('ref'=>'SOAP-ENC:arrayType','wsdl:arrayType' => 'tns:result_editCourseDescription[]')),'tns:result_editCourseDescription'
  2363. );
  2364. // Register the method to expose
  2365. $server->register('DokeosWSEditCourseDescription', // method name
  2366. array('editCourseDescription' => 'tns:editCourseDescription'), // input parameters
  2367. array('return' => 'tns:results_editCourseDescription'), // output parameters
  2368. 'urn:WSRegistration', // namespace
  2369. 'urn:WSRegistration#DokeosWSEditCourseDescription', // soapaction
  2370. 'rpc', // style
  2371. 'encoded', // use
  2372. 'This service edits a course description into dokeos' // documentation
  2373. );
  2374. // Define the method DokeosWSEditCourseDescription
  2375. function DokeosWSEditCourseDescription($params){
  2376. global $_configuration,$_course;
  2377. $secret_key = $params['secret_key'];
  2378. $security_key = $_SERVER['REMOTE_ADDR'].$_configuration['security_key'];
  2379. if (!api_is_valid_secret_key($secret_key,$security_key)) {
  2380. return -1; //secret key is incorrect
  2381. }
  2382. $course_table = Database::get_main_table(TABLE_MAIN_COURSE);
  2383. $course_user_table = Database::get_main_table(TABLE_MAIN_COURSE_USER);
  2384. $t_cfv = Database::get_main_table(TABLE_MAIN_COURSE_FIELD_VALUES);
  2385. $table_field = Database::get_main_table(TABLE_MAIN_COURSE_FIELD);
  2386. $courses_params = $params['course_desc'];
  2387. $results = array();
  2388. $orig_course_id_value = array();
  2389. foreach($courses_params as $course_param) {
  2390. $original_course_id_name = $course_param['original_course_id_name'];
  2391. $original_course_id_value = $course_param['original_course_id_value'];
  2392. $course_desc_id = $course_param['course_desc_id'];
  2393. $course_desc_title = $course_param['course_desc_title'];
  2394. $course_desc_content = $course_param['course_desc_content'];
  2395. $orig_course_id_value[] = $original_course_id_value;
  2396. // get course code from id from remote system
  2397. $sql = "SELECT course_code FROM $table_field cf,$t_cfv cfv WHERE cfv.field_id=cf.id AND field_variable='$original_course_id_name' AND field_value='$original_course_id_value'";
  2398. $res = api_sql_query($sql,__FILE__,__LINE__);
  2399. $row = Database::fetch_row($res);
  2400. $course_code=$row[0];
  2401. if (Database::num_rows($res) < 1) {
  2402. $results[] = 0;
  2403. continue;// original_course_id_value doesn't exits
  2404. } else {
  2405. $sql = "SELECT code FROM $course_table WHERE code ='$course_code' AND visibility = '0'";
  2406. $resu = api_sql_query($sql,__FILE__,__LINE__);
  2407. $r_check_code = Database::fetch_row($resu);
  2408. if (Database::num_rows($resu) > 0) {
  2409. $results[] = 0;
  2410. continue;
  2411. }
  2412. }
  2413. $course_ifo = api_get_course_info($course_code);
  2414. $t_course_desc = Database::get_course_table(TABLE_COURSE_DESCRIPTION,$course_ifo['dbName']);
  2415. $course_desc_id = Database::escape_string($course_desc_id);
  2416. $course_desc_title = Database::escape_string($course_desc_title);
  2417. $course_desc_content = Database::escape_string($course_desc_content);
  2418. $course_desc_id = (int)$course_desc_id;
  2419. if ($course_desc_id > 8 && $course_desc_id < 1) {
  2420. $results[] = 0; // course_desc_id invalid
  2421. continue;
  2422. }
  2423. //check if data already exits into course_description table
  2424. $sql_check_id = "SELECT * FROM $t_course_desc WHERE id ='$course_desc_id'";
  2425. $res_check_id = api_sql_query($sql_check_id,__FILE__,__LINE__);
  2426. if (Database::num_rows($res_check_id) > 0) {
  2427. $sql = "UPDATE $t_course_desc SET title='$course_desc_title', content = '$course_desc_content' WHERE id = '".$course_desc_id."'";
  2428. api_sql_query($sql,__FILE__,__LINE__);
  2429. } else {
  2430. $sql = "INSERT IGNORE INTO $t_course_desc SET id = '".$course_desc_id."', title = '$course_desc_title', content = '$course_desc_content'";
  2431. api_sql_query($sql, __FILE__, __LINE__);
  2432. }
  2433. $results[] = 1;
  2434. }// end principal foreach
  2435. $count_results = count($results);
  2436. $output = array();
  2437. for($i = 0; $i < $count_results; $i++) {
  2438. $output[] = array('original_course_id_value' =>$orig_course_id_value[$i],'result' => $results[$i]);
  2439. }
  2440. return $output;
  2441. }
  2442. /* Register DokeosWSDeleteCourse function */
  2443. // Register the data structures used by the service
  2444. $server->wsdl->addComplexType(
  2445. 'deleteCourseParams',
  2446. 'complexType',
  2447. 'struct',
  2448. 'all',
  2449. '',
  2450. array(
  2451. 'original_course_id_value' => array('name' => 'original_course_id_value', 'type' => 'xsd:string'),
  2452. 'original_course_id_name' => array('name' => 'original_course_id_name', 'type' => 'xsd:string')
  2453. )
  2454. );
  2455. $server->wsdl->addComplexType(
  2456. 'deleteCourseParamsList',
  2457. 'complexType',
  2458. 'array',
  2459. '',
  2460. 'SOAP-ENC:Array',
  2461. array(),
  2462. array(array('ref'=>'SOAP-ENC:arrayType','wsdl:arrayType' => 'tns:deleteCourseParams[]')),'tns:deleteCourseParams'
  2463. );
  2464. // Register the data structures used by the service
  2465. $server->wsdl->addComplexType(
  2466. 'deleteCourse',
  2467. 'complexType',
  2468. 'struct',
  2469. 'all',
  2470. '',
  2471. array(
  2472. 'courses' => array('name' => 'courses', 'type' => 'tns:deleteCourseParamsList'),
  2473. 'secret_key' => array('name' => 'secret_key', 'type' => 'xsd:string')
  2474. )
  2475. );
  2476. // Prepare output params, in this case will return an array
  2477. $server->wsdl->addComplexType(
  2478. 'result_deleteCourse',
  2479. 'complexType',
  2480. 'struct',
  2481. 'all',
  2482. '',
  2483. array(
  2484. 'original_course_id_value' => array('name' => 'original_course_id_value', 'type' => 'xsd:string'),
  2485. 'result' => array('name' => 'result', 'type' => 'xsd:string')
  2486. )
  2487. );
  2488. $server->wsdl->addComplexType(
  2489. 'results_deleteCourse',
  2490. 'complexType',
  2491. 'array',
  2492. '',
  2493. 'SOAP-ENC:Array',
  2494. array(),
  2495. array(array('ref'=>'SOAP-ENC:arrayType','wsdl:arrayType' => 'tns:result_deleteCourse[]')),'tns:result_deleteCourse'
  2496. );
  2497. $server->register('DokeosWSDeleteCourse', // method name
  2498. array('deleteCourse' => 'tns:deleteCourse'), // input parameters
  2499. array('return' => 'tns:results_deleteCourse'), // output parameters
  2500. 'urn:WSRegistration', // namespace
  2501. 'urn:WSRegistration#DokeosWSDeleteCourse', // soapaction
  2502. 'rpc', // style
  2503. 'encoded', // use
  2504. 'This service deletes a course ' // documentation
  2505. );
  2506. // define the method DokeosWSDeleteCourse
  2507. function DokeosWSDeleteCourse($params) {
  2508. global $_configuration;
  2509. $secret_key = $params['secret_key'];
  2510. $security_key = $_SERVER['REMOTE_ADDR'].$_configuration['security_key'];
  2511. if (!api_is_valid_secret_key($secret_key,$security_key)) {
  2512. return -1; //secret key is incorrect
  2513. }
  2514. $table_course = Database :: get_main_table(TABLE_MAIN_COURSE);
  2515. $t_cfv = Database::get_main_table(TABLE_MAIN_COURSE_FIELD_VALUES);
  2516. $table_field = Database::get_main_table(TABLE_MAIN_COURSE_FIELD);
  2517. $courses_params = $params['courses'];
  2518. $results = array();
  2519. $orig_course_id_value = array();
  2520. foreach($courses_params as $course_param) {
  2521. $original_course_id_value = $course_param['original_course_id_value'];
  2522. $original_course_id_name = $course_param['original_course_id_name'];
  2523. $orig_course_id_value[] = $original_course_id_value;
  2524. // get course code from id from remote system
  2525. $sql_course = "SELECT course_code FROM $table_field cf,$t_cfv cfv WHERE cfv.field_id=cf.id AND field_variable='$original_course_id_name' AND field_value='$original_course_id_value'";
  2526. $res_course = api_sql_query($sql_course,__FILE__,__LINE__);
  2527. $row_course = Database::fetch_row($res_course);
  2528. $code=$row_course[0];
  2529. if (empty($code)) {
  2530. $results[] = 0; // original_course_id_value doesn't exits
  2531. continue;
  2532. } else {
  2533. $sql = "SELECT code FROM $table_course WHERE code ='$code' AND visibility = '0'";
  2534. $resu = api_sql_query($sql,__FILE__,__LINE__);
  2535. $r_check_code = Database::fetch_row($resu);
  2536. if (!empty($r_check_code[0])) {
  2537. $results[] = 0; // this code is not active
  2538. continue;
  2539. }
  2540. }
  2541. $sql= "UPDATE $table_course SET visibility = '0' WHERE code = '$code'";
  2542. $return = api_sql_query($sql,__FILE__,__LINE__);
  2543. $results[] = $return;
  2544. }
  2545. $count_results = count($results);
  2546. $output = array();
  2547. for($i = 0; $i < $count_results; $i++) {
  2548. $output[] = array('original_course_id_value' =>$orig_course_id_value[$i],'result' => $results[$i]);
  2549. }
  2550. return $output;
  2551. }
  2552. /* Register DokeosWSCreateSession function */
  2553. // Register the data structures used by the service
  2554. $server->wsdl->addComplexType(
  2555. 'createSessionParam',
  2556. 'complexType',
  2557. 'struct',
  2558. 'all',
  2559. '',
  2560. array(
  2561. 'name' => array('name' => 'name', 'type' => 'xsd:string'),
  2562. 'year_start' => array('name' => 'year_start', 'type' => 'xsd:string'),
  2563. 'month_start' => array('name' => 'month_start', 'type' => 'xsd:string'),
  2564. 'day_start' => array('name' => 'day_start', 'type' => 'xsd:string'),
  2565. 'year_end' => array('name' => 'year_end', 'type' => 'xsd:string'),
  2566. 'month_end' => array('name' => 'month_end', 'type' => 'xsd:string'),
  2567. 'day_end' => array('name' => 'day_end', 'type' => 'xsd:string'),
  2568. 'nb_days_access_before' => array('name' => 'nb_days_access_before', 'type' => 'xsd:string'),
  2569. 'nb_days_access_after' => array('name' => 'nb_days_access_after', 'type' => 'xsd:string'),
  2570. 'nolimit' => array('name' => 'nolimit', 'type' => 'xsd:string'),
  2571. 'user_id' => array('name' => 'user_id', 'type' => 'xsd:string'),
  2572. 'original_session_id_name' => array('name' => 'original_session_id_name', 'type' => 'xsd:string'),
  2573. 'original_session_id_value' => array('name' => 'original_session_id_value', 'type' => 'xsd:string'),
  2574. 'extra' => array('name' => 'extra', 'type' => 'tns:extrasList')
  2575. )
  2576. );
  2577. $server->wsdl->addComplexType(
  2578. 'createSessionParamList',
  2579. 'complexType',
  2580. 'array',
  2581. '',
  2582. 'SOAP-ENC:Array',
  2583. array(),
  2584. array(array('ref'=>'SOAP-ENC:arrayType','wsdl:arrayType' => 'tns:createSessionParam[]')),'tns:createSessionParam'
  2585. );
  2586. // Register the data structures used by the service
  2587. $server->wsdl->addComplexType(
  2588. 'createSession',
  2589. 'complexType',
  2590. 'struct',
  2591. 'all',
  2592. '',
  2593. array(
  2594. 'sessions' => array('name' => 'sessions', 'type' => 'tns:createSessionParamList'),
  2595. 'secret_key' => array('name' => 'secret_key', 'type' => 'xsd:string')
  2596. )
  2597. );
  2598. // Prepare output params, in this case will return an array
  2599. $server->wsdl->addComplexType(
  2600. 'result_createSession',
  2601. 'complexType',
  2602. 'struct',
  2603. 'all',
  2604. '',
  2605. array(
  2606. 'original_session_id_value' => array('name' => 'original_session_id_value', 'type' => 'xsd:string'),
  2607. 'result' => array('name' => 'result', 'type' => 'xsd:string')
  2608. )
  2609. );
  2610. $server->wsdl->addComplexType(
  2611. 'results_createSession',
  2612. 'complexType',
  2613. 'array',
  2614. '',
  2615. 'SOAP-ENC:Array',
  2616. array(),
  2617. array(array('ref'=>'SOAP-ENC:arrayType','wsdl:arrayType' => 'tns:result_createSession[]')),'tns:result_createSession'
  2618. );
  2619. // Register the method to expose
  2620. $server->register('DokeosWSCreateSession', // method name
  2621. array('createSession' => 'tns:createSession'), // input parameters
  2622. array('return' => 'tns:results_createSession'), // output parameters
  2623. 'urn:WSRegistration', // namespace
  2624. 'urn:WSRegistration#DokeosWSCreateSession', // soapaction
  2625. 'rpc', // style
  2626. 'encoded', // use
  2627. 'This service edits a session' // documentation
  2628. );
  2629. // define the method DokeosWSCreateSession
  2630. function DokeosWSCreateSession($params) {
  2631. global $_user,$_configuration;
  2632. $secret_key = $params['secret_key'];
  2633. $security_key = $_SERVER['REMOTE_ADDR'].$_configuration['security_key'];
  2634. if (!api_is_valid_secret_key($secret_key,$security_key)) {
  2635. return -1; //secret key is incorrect
  2636. }
  2637. $tbl_user = Database::get_main_table(TABLE_MAIN_USER);
  2638. $tbl_session = Database::get_main_table(TABLE_MAIN_SESSION);
  2639. $t_sf = Database::get_main_table(TABLE_MAIN_SESSION_FIELD);
  2640. $t_sfv = Database::get_main_table(TABLE_MAIN_SESSION_FIELD_VALUES);
  2641. $sessions_params = $params['sessions'];
  2642. $results = array();
  2643. $orig_session_id_value = array();
  2644. foreach($sessions_params as $session_param) {
  2645. $name= trim($session_param['name']);
  2646. $year_start= intval($session_param['year_start']);
  2647. $month_start=intval($session_param['month_start']);
  2648. $day_start=intval($session_param['day_start']);
  2649. $year_end=intval($session_param['year_end']);
  2650. $month_end=intval($session_param['month_end']);
  2651. $day_end=intval($session_param['day_end']);
  2652. $nb_days_acess_before = intval($session_param['nb_days_access_before']);
  2653. $nb_days_acess_after = intval($session_param['nb_days_access_after']);
  2654. $id_coach = $session_param['user_id'];
  2655. $nolimit = $session_param['nolimit'];
  2656. $original_session_id_name = $session_param['original_session_id_name'];
  2657. $original_session_id_value = $session_param['original_session_id_value'];
  2658. $orig_session_id_value[] = $session_param['original_session_id_value'];
  2659. $extra_list = $session_param['extra'];
  2660. // check if exits remote system's session id into session_field_values table
  2661. $sql = "SELECT field_value FROM $t_sf sf,$t_sfv sfv WHERE sfv.field_id=sf.id AND field_variable='$original_session_id_name' AND field_value='$original_session_id_value'";
  2662. $res = api_sql_query($sql,__FILE__,__LINE__);
  2663. $row = Database::fetch_row($res);
  2664. if (Database::num_rows($res) > 0) {
  2665. $results[] = 0;
  2666. continue;
  2667. }
  2668. if (empty($nolimit)){
  2669. $date_start="$year_start-".(($month_start < 10)?"0$month_start":$month_start)."-".(($day_start < 10)?"0$day_start":$day_start);
  2670. $date_end="$year_end-".(($month_end < 10)?"0$month_end":$month_end)."-".(($day_end < 10)?"0$day_end":$day_end);
  2671. } else {
  2672. $date_start="000-00-00";
  2673. $date_end="000-00-00";
  2674. }
  2675. if(empty($name)) {
  2676. $results[] = 0;
  2677. continue;
  2678. } elseif(empty($nolimit) && (!$month_start || !$day_start || !$year_start || !checkdate($month_start,$day_start,$year_start))) {
  2679. $results[] = 0;
  2680. continue;
  2681. } elseif(empty($nolimit) && (!$month_end || !$day_end || !$year_end || !checkdate($month_end,$day_end,$year_end))) {
  2682. $results[] = 0;
  2683. continue;
  2684. } elseif(empty($nolimit) && $date_start >= $date_end) {
  2685. $results[] = 0;
  2686. continue;
  2687. }
  2688. else
  2689. {
  2690. $rs = api_sql_query("SELECT 1 FROM $tbl_session WHERE name='".addslashes($name)."'");
  2691. if(Database::num_rows($rs)){
  2692. $results[] = 0;
  2693. continue;
  2694. } else {
  2695. api_sql_query("INSERT INTO $tbl_session(name,date_start,date_end,id_coach,session_admin_id, nb_days_access_before_beginning, nb_days_access_after_end) VALUES('".addslashes($name)."','$date_start','$date_end','$id_coach',".intval($_user['user_id']).",".$nb_days_acess_before.", ".$nb_days_acess_after.")",__FILE__,__LINE__);
  2696. $id_session=Database::get_last_insert_id();
  2697. // save new fieldlabel into course_field table
  2698. $field_id = SessionManager::create_session_extra_field($original_session_id_name,1,$original_session_id_name);
  2699. // save the external system's id into user_field_value table'
  2700. $res = SessionManager::update_session_extra_field_value($id_session,$original_session_id_name,$original_session_id_value);
  2701. if (is_array($extra_list) && count($extra_list) > 0) {
  2702. foreach ($extra_list as $extra) {
  2703. $extra_field_name = $extra['field_name'];
  2704. $extra_field_value = $extra['field_value'];
  2705. // save new fieldlabel into course_field table
  2706. $field_id = SessionManager::create_session_extra_field($extra_field_name,1,$extra_field_name);
  2707. // save the external system's id into course_field_value table'
  2708. $res = SessionManager::update_session_extra_field_value($id_session,$extra_field_name,$extra_field_value);
  2709. }
  2710. }
  2711. $results[] = $id_session;
  2712. continue;
  2713. }
  2714. }
  2715. } // end principal foreach
  2716. $count_results = count($results);
  2717. $output = array();
  2718. for($i = 0; $i < $count_results; $i++) {
  2719. $output[] = array('original_session_id_value' =>$orig_session_id_value[$i],'result' => $results[$i]);
  2720. }
  2721. return $output;
  2722. }
  2723. /* Register DokeosWSEditSession function */
  2724. // Register the data structures used by the service
  2725. $server->wsdl->addComplexType(
  2726. 'editSessionParams',
  2727. 'complexType',
  2728. 'struct',
  2729. 'all',
  2730. '',
  2731. array(
  2732. 'name' => array('name' => 'name', 'type' => 'xsd:string'),
  2733. 'year_start' => array('name' => 'year_start', 'type' => 'xsd:string'),
  2734. 'month_start' => array('name' => 'month_start', 'type' => 'xsd:string'),
  2735. 'day_start' => array('name' => 'day_start', 'type' => 'xsd:string'),
  2736. 'year_end' => array('name' => 'year_end', 'type' => 'xsd:string'),
  2737. 'month_end' => array('name' => 'month_end', 'type' => 'xsd:string'),
  2738. 'day_end' => array('name' => 'day_end', 'type' => 'xsd:string'),
  2739. 'nb_days_access_before' => array('name' => 'nb_days_access_before', 'type' => 'xsd:string'),
  2740. 'nb_days_access_after' => array('name' => 'nb_days_access_after', 'type' => 'xsd:string'),
  2741. 'nolimit' => array('name' => 'nolimit', 'type' => 'xsd:string'),
  2742. 'user_id' => array('name' => 'user_id', 'type' => 'xsd:string'),
  2743. 'original_session_id_name' => array('name' => 'original_session_id_name', 'type' => 'xsd:string'),
  2744. 'original_session_id_value' => array('name' => 'original_session_id_value', 'type' => 'xsd:string'),
  2745. 'extra' => array('name' => 'extra', 'type' => 'tns:extrasList')
  2746. )
  2747. );
  2748. $server->wsdl->addComplexType(
  2749. 'editSessionParamsList',
  2750. 'complexType',
  2751. 'array',
  2752. '',
  2753. 'SOAP-ENC:Array',
  2754. array(),
  2755. array(array('ref'=>'SOAP-ENC:arrayType','wsdl:arrayType' => 'tns:editSessionParams[]')),'tns:editSessionParams'
  2756. );
  2757. $server->wsdl->addComplexType(
  2758. 'editSession',
  2759. 'complexType',
  2760. 'struct',
  2761. 'all',
  2762. '',
  2763. array(
  2764. 'sessions' => array('name' => 'sessions', 'type' => 'tns:editSessionParamsList'),
  2765. 'secret_key' => array('name' => 'secret_key', 'type' => 'xsd:string')
  2766. )
  2767. );
  2768. // Prepare output params, in this case will return an array
  2769. $server->wsdl->addComplexType(
  2770. 'result_editSession',
  2771. 'complexType',
  2772. 'struct',
  2773. 'all',
  2774. '',
  2775. array(
  2776. 'original_session_id_value' => array('name' => 'original_session_id_value', 'type' => 'xsd:string'),
  2777. 'result' => array('name' => 'result', 'type' => 'xsd:string')
  2778. )
  2779. );
  2780. $server->wsdl->addComplexType(
  2781. 'results_editSession',
  2782. 'complexType',
  2783. 'array',
  2784. '',
  2785. 'SOAP-ENC:Array',
  2786. array(),
  2787. array(array('ref'=>'SOAP-ENC:arrayType','wsdl:arrayType' => 'tns:result_editSession[]')),'tns:result_editSession'
  2788. );
  2789. // Register the method to expose
  2790. $server->register('DokeosWSEditSession', // method name
  2791. array('editSession' => 'tns:editSession'), // input parameters
  2792. array('return' => 'tns:results_editSession'), // output parameters
  2793. 'urn:WSRegistration', // namespace
  2794. 'urn:WSRegistration#DokeosWSEditSession', // soapaction
  2795. 'rpc', // style
  2796. 'encoded', // use
  2797. 'This service edits a session' // documentation
  2798. );
  2799. // define the method DokeosWSEditSession
  2800. function DokeosWSEditSession($params) {
  2801. global $_user,$_configuration;
  2802. $secret_key = $params['secret_key'];
  2803. $security_key = $_SERVER['REMOTE_ADDR'].$_configuration['security_key'];
  2804. if (!api_is_valid_secret_key($secret_key,$security_key)) {
  2805. return -1; //secret key is incorrect
  2806. }
  2807. $tbl_user = Database::get_main_table(TABLE_MAIN_USER);
  2808. $tbl_session = Database::get_main_table(TABLE_MAIN_SESSION);
  2809. $t_sf = Database::get_main_table(TABLE_MAIN_SESSION_FIELD);
  2810. $t_sfv = Database::get_main_table(TABLE_MAIN_SESSION_FIELD_VALUES);
  2811. $sessions_params = $params['sessions'];
  2812. $results = array();
  2813. $orig_session_id_value = array();
  2814. foreach($sessions_params as $session_param) {
  2815. $name= trim($session_param['name']);
  2816. $year_start= intval($session_param['year_start']);
  2817. $month_start=intval($session_param['month_start']);
  2818. $day_start=intval($session_param['day_start']);
  2819. $year_end=intval($session_param['year_end']);
  2820. $month_end=intval($session_param['month_end']);
  2821. $day_end=intval($session_param['day_end']);
  2822. $nb_days_acess_before = intval($session_param['nb_days_access_before']);
  2823. $nb_days_acess_after = intval($session_param['nb_days_access_after']);
  2824. $original_session_id_value = $session_param['original_session_id_value'];
  2825. $original_session_id_name = $session_param['original_session_id_name'];
  2826. $orig_session_id_value[] = $original_session_id_value;
  2827. $coach_username = $session_param['coach_username'];
  2828. $nolimit = $session_param['nolimit'];
  2829. $id_coach = $session_param['user_id'];
  2830. $extra_list = $session_param['extra'];
  2831. // get session id from original session id
  2832. $sql = "SELECT session_id FROM $t_sf sf,$t_sfv sfv WHERE sfv.field_id=sf.id AND field_variable='$original_session_id_name' AND field_value='$original_session_id_value'";
  2833. $res = api_sql_query($sql,__FILE__,__LINE__);
  2834. $row = Database::fetch_row($res);
  2835. $id=intval($row[0]);
  2836. if (Database::num_rows($res) < 1) {
  2837. $results[] = 0;
  2838. continue;
  2839. }
  2840. if (empty($nolimit)) {
  2841. $date_start="$year_start-".(($month_start < 10)?"0$month_start":$month_start)."-".(($day_start < 10)?"0$day_start":$day_start);
  2842. $date_end="$year_end-".(($month_end < 10)?"0$month_end":$month_end)."-".(($day_end < 10)?"0$day_end":$day_end);
  2843. } else {
  2844. $date_start="000-00-00";
  2845. $date_end="000-00-00";
  2846. }
  2847. if(empty($name)) {
  2848. $results[] = 0; //SessionNameIsRequired
  2849. continue;
  2850. } else if(empty($nolimit) && (!$month_start || !$day_start || !$year_start || !checkdate($month_start,$day_start,$year_start))) {
  2851. $results[] = 0; //InvalidStartDate
  2852. continue;
  2853. } else if(empty($nolimit) && (!$month_end || !$day_end || !$year_end || !checkdate($month_end,$day_end,$year_end))) {
  2854. $results[] = 0; //InvalidEndDate
  2855. continue;
  2856. } else if(empty($nolimit) && $date_start >= $date_end) {
  2857. $results[] = 0; //StartDateShouldBeBeforeEndDate
  2858. continue;
  2859. } else {
  2860. $sql="UPDATE $tbl_session SET " .
  2861. "name='".addslashes($name)."', " .
  2862. "date_start='".$date_start."', " .
  2863. "date_end='".$date_end."', " .
  2864. "id_coach='". $id_coach."', " .
  2865. "session_admin_id='". intval($_user['user_id'])."', " .
  2866. "nb_days_access_before_beginning='". $nb_days_acess_before."', " .
  2867. "nb_days_access_after_end='". $nb_days_acess_after."'" .
  2868. " WHERE id='".$id."'";
  2869. api_sql_query($sql,__FILE__,__LINE__);
  2870. $id_session=Database::get_last_insert_id();
  2871. if (is_array($extra_list) && count($extra_list) > 0) {
  2872. foreach ($extra_list as $extra) {
  2873. $extra_field_name = $extra['field_name'];
  2874. $extra_field_value = $extra['field_value'];
  2875. // save the external system's id into session_field_value table'
  2876. $res = SessionManager::update_session_extra_field_value($id,$extra_field_name,$extra_field_value);
  2877. }
  2878. }
  2879. $results[] = 1;
  2880. continue;
  2881. }
  2882. } // end principal foreach
  2883. $count_results = count($results);
  2884. $output = array();
  2885. for($i = 0; $i < $count_results; $i++) {
  2886. $output[] = array('original_session_id_value' =>$orig_session_id_value[$i],'result' => $results[$i]);
  2887. }
  2888. return $output;
  2889. }
  2890. /* Register DokeosWSDeleteSession function */
  2891. $server->wsdl->addComplexType(
  2892. 'deleteSessionParams',
  2893. 'complexType',
  2894. 'struct',
  2895. 'all',
  2896. '',
  2897. array(
  2898. 'original_session_id_value' => array('name' => 'original_session_id_value', 'type' => 'xsd:string'),
  2899. 'original_session_id_name' => array('name' => 'original_session_id_name', 'type' => 'xsd:string')
  2900. )
  2901. );
  2902. $server->wsdl->addComplexType(
  2903. 'deleteSessionParamsList',
  2904. 'complexType',
  2905. 'array',
  2906. '',
  2907. 'SOAP-ENC:Array',
  2908. array(),
  2909. array(array('ref'=>'SOAP-ENC:arrayType','wsdl:arrayType' => 'tns:deleteSessionParams[]')),'tns:deleteSessionParams'
  2910. );
  2911. // Register the data structures used by the service
  2912. $server->wsdl->addComplexType(
  2913. 'deleteSession',
  2914. 'complexType',
  2915. 'struct',
  2916. 'all',
  2917. '',
  2918. array(
  2919. 'sessions' => array('name' => 'sessions', 'type' => 'tns:deleteSessionParamsList'),
  2920. 'secret_key' => array('name' => 'secret_key', 'type' => 'xsd:string')
  2921. )
  2922. );
  2923. // Prepare output params, in this case will return an array
  2924. $server->wsdl->addComplexType(
  2925. 'result_deleteSession',
  2926. 'complexType',
  2927. 'struct',
  2928. 'all',
  2929. '',
  2930. array(
  2931. 'original_session_id_value' => array('name' => 'original_session_id_value', 'type' => 'xsd:string'),
  2932. 'result' => array('name' => 'result', 'type' => 'xsd:string')
  2933. )
  2934. );
  2935. $server->wsdl->addComplexType(
  2936. 'results_deleteSession',
  2937. 'complexType',
  2938. 'array',
  2939. '',
  2940. 'SOAP-ENC:Array',
  2941. array(),
  2942. array(array('ref'=>'SOAP-ENC:arrayType','wsdl:arrayType' => 'tns:result_deleteSession[]')),'tns:result_deleteSession'
  2943. );
  2944. $server->register('DokeosWSDeleteSession', // method name
  2945. array('deleteSession' => 'tns:deleteSession'), // input parameters
  2946. array('return' => 'tns:results_deleteSession'), // output parameters
  2947. 'urn:WSRegistration', // namespace
  2948. 'urn:WSRegistration#DokeosWSDeleteSession', // soapaction
  2949. 'rpc', // style
  2950. 'encoded', // use
  2951. 'This service deletes a session ' // documentation
  2952. );
  2953. // define the method DokeosWSDeleteSession
  2954. function DokeosWSDeleteSession($params) {
  2955. global $_configuration;
  2956. $secret_key = $params['secret_key'];
  2957. $security_key = $_SERVER['REMOTE_ADDR'].$_configuration['security_key'];
  2958. if (!api_is_valid_secret_key($secret_key,$security_key)) {
  2959. return -1; //secret key is incorrect
  2960. }
  2961. $t_sf = Database::get_main_table(TABLE_MAIN_SESSION_FIELD);
  2962. $t_sfv = Database::get_main_table(TABLE_MAIN_SESSION_FIELD_VALUES);
  2963. $tbl_session = Database::get_main_table(TABLE_MAIN_SESSION);
  2964. $tbl_session_rel_course = Database::get_main_table(TABLE_MAIN_SESSION_COURSE);
  2965. $tbl_session_rel_course_rel_user = Database::get_main_table(TABLE_MAIN_SESSION_COURSE_USER);
  2966. $tbl_session_rel_user = Database::get_main_table(TABLE_MAIN_SESSION_USER);
  2967. $tbl_user = Database::get_main_table(TABLE_MAIN_USER);
  2968. $session_params = $params['sessions'];
  2969. $results = array();
  2970. $orig_session_id_value = array();
  2971. foreach($session_params as $session_param) {
  2972. $original_session_id_value = $session_param['original_session_id_value'];
  2973. $original_session_id_name = $session_param['original_session_id_name'];
  2974. $orig_session_id_value[] = $original_session_id_name;
  2975. // get session id from original session id
  2976. $sql = "SELECT session_id FROM $t_sf sf,$t_sfv sfv WHERE sfv.field_id=sf.id AND field_variable='$original_session_id_name' AND field_value='$original_session_id_value'";
  2977. $res = @api_sql_query($sql,__FILE__,__LINE__);
  2978. $row = Database::fetch_row($res);
  2979. $idChecked=intval($row[0]);
  2980. if (empty($idChecked)) {
  2981. $results[] = 0;
  2982. continue;
  2983. }
  2984. $session_ids[] = $idChecked;
  2985. $sql_session = "DELETE FROM $tbl_session WHERE id = '$idChecked'";
  2986. @api_sql_query($sql_session,__FILE__,__LINE__);
  2987. $sql_session_rel_course = "DELETE FROM $tbl_session_rel_course WHERE id_session = '$idChecked'";
  2988. @api_sql_query($sql_session_rel_course,__FILE__,__LINE__);
  2989. $sql_session_rel_course_rel_user = "DELETE FROM $tbl_session_rel_course_rel_user WHERE id_session = '$idChecked'";
  2990. @api_sql_query($sql_session_rel_course_rel_user,__FILE__,__LINE__);
  2991. $sql_session_rel_course = "DELETE FROM $tbl_session_rel_user WHERE id_session = '$idChecked'";
  2992. @api_sql_query($sql_session_rel_course,__FILE__,__LINE__);
  2993. $results[] = 1;
  2994. continue;
  2995. }
  2996. // get fields id from all extra fields about a given session id
  2997. $cad_session_ids = implode(",",$session_ids);
  2998. $sql = "SELECT distinct field_id FROM $t_sfv WHERE session_id IN ($cad_session_ids)";
  2999. $res_field_ids = @api_sql_query($sql,__FILE__,__LINE__);
  3000. while($row_field_id = Database::fetch_row($res_field_ids)){
  3001. $field_ids[] = $row_field_id[0];
  3002. }
  3003. //delete from table_session_field_value from a given session_id
  3004. foreach ($session_ids as $session_id) {
  3005. $sql_session_field_value = "DELETE FROM $t_sfv WHERE session_id = '$session_id'";
  3006. @api_sql_query($sql_session_field_value,__FILE__,__LINE__);
  3007. }
  3008. $sql = "SELECT distinct field_id FROM $t_sfv";
  3009. $res_field_all_ids = @api_sql_query($sql,__FILE__,__LINE__);
  3010. while($row_field_all_id = Database::fetch_row($res_field_all_ids)){
  3011. $field_all_ids[] = $row_field_all_id[0];
  3012. }
  3013. foreach($field_ids as $field_id) {
  3014. // check if field id is used into table field value
  3015. if (in_array($field_id,$field_all_ids)) {
  3016. continue;
  3017. } else {
  3018. $sql_session_field = "DELETE FROM $t_sf WHERE id = '$field_id'";
  3019. api_sql_query($sql_session_field,__FILE__,__LINE__);
  3020. }
  3021. }
  3022. // Preparing output
  3023. $count_results = count($results);
  3024. $output = array();
  3025. for($i = 0; $i < $count_results; $i++) {
  3026. $output[] = array('original_session_id_value' =>$orig_session_id_value[$i],'result' => $results[$i]);
  3027. }
  3028. return $output;
  3029. }
  3030. /* Register DokeosWSSubscribeUserToCourse function */
  3031. // Register the data structures used by the service
  3032. $server->wsdl->addComplexType(
  3033. 'originalUsersList',
  3034. 'complexType',
  3035. 'array',
  3036. '',
  3037. 'SOAP-ENC:Array',
  3038. array(),
  3039. array(array('ref'=>'SOAP-ENC:arrayType','wsdl:arrayType' => 'string[]')),'xsd:string'
  3040. );
  3041. $server->wsdl->addComplexType(
  3042. 'subscribeUserToCourseParams',
  3043. 'complexType',
  3044. 'struct',
  3045. 'all',
  3046. '',
  3047. array(
  3048. 'original_user_id_values' => array('name' => 'original_user_id_values', 'type' => 'tns:originalUsersList'),
  3049. 'original_user_id_name' => array('name' => 'original_user_id_name', 'type' => 'xsd:string'),
  3050. 'original_course_id_value' => array('name' => 'original_course_id_value', 'type' => 'xsd:string'),
  3051. 'original_course_id_name' => array('name' => 'original_course_id_value', 'type' => 'xsd:string')
  3052. )
  3053. );
  3054. $server->wsdl->addComplexType(
  3055. 'subscribeUserToCourseParamsList',
  3056. 'complexType',
  3057. 'array',
  3058. '',
  3059. 'SOAP-ENC:Array',
  3060. array(),
  3061. array(array('ref'=>'SOAP-ENC:arrayType','wsdl:arrayType' => 'tns:subscribeUserToCourseParams[]')),'tns:subscribeUserToCourseParams'
  3062. );
  3063. $server->wsdl->addComplexType(
  3064. 'subscribeUserToCourse',
  3065. 'complexType',
  3066. 'struct',
  3067. 'all',
  3068. '',
  3069. array(
  3070. 'userscourses' => array('name' => 'userscourses', 'type' => 'tns:subscribeUserToCourseParamsList'),
  3071. 'secret_key' => array('name' => 'secret_key', 'type' => 'xsd:string')
  3072. )
  3073. );
  3074. // Prepare output params, in this case will return an array
  3075. $server->wsdl->addComplexType(
  3076. 'result_subscribeUserToCourse',
  3077. 'complexType',
  3078. 'struct',
  3079. 'all',
  3080. '',
  3081. array(
  3082. 'original_user_id_value' => array('name' => 'original_user_id_value', 'type' => 'xsd:string'),
  3083. 'original_course_id_value' => array('name' => 'original_course_id_value', 'type' => 'xsd:string'),
  3084. 'result' => array('name' => 'result', 'type' => 'xsd:string')
  3085. )
  3086. );
  3087. $server->wsdl->addComplexType(
  3088. 'results_subscribeUserToCourse',
  3089. 'complexType',
  3090. 'array',
  3091. '',
  3092. 'SOAP-ENC:Array',
  3093. array(),
  3094. array(array('ref'=>'SOAP-ENC:arrayType','wsdl:arrayType' => 'tns:result_subscribeUserToCourse[]')),'tns:result_subscribeUserToCourse'
  3095. );
  3096. // Register the method to expose
  3097. $server->register('DokeosWSSubscribeUserToCourse', // method name
  3098. array('subscribeUserToCourse' => 'tns:subscribeUserToCourse'), // input parameters
  3099. array('return' => 'tns:results_subscribeUserToCourse'), // output parameters
  3100. 'urn:WSRegistration', // namespace
  3101. 'urn:WSRegistration#DokeosWSSubscribeUserToCourse', // soapaction
  3102. 'rpc', // style
  3103. 'encoded', // use
  3104. 'This service subscribes a user to a course' // documentation
  3105. );
  3106. // define the method DokeosWSSubscribeUserToCourse
  3107. function DokeosWSSubscribeUserToCourse($params) {
  3108. global $_configuration;
  3109. $secret_key = $params['secret_key'];
  3110. $security_key = $_SERVER['REMOTE_ADDR'].$_configuration['security_key'];
  3111. if (!api_is_valid_secret_key($secret_key,$security_key)) {
  3112. return -1; //secret key is incorrect
  3113. }
  3114. $user_table = Database :: get_main_table(TABLE_MAIN_USER);
  3115. $t_uf = Database::get_main_table(TABLE_MAIN_USER_FIELD);
  3116. $t_ufv = Database::get_main_table(TABLE_MAIN_USER_FIELD_VALUES);
  3117. $course_table = Database :: get_main_table(TABLE_MAIN_COURSE);
  3118. $t_cfv = Database::get_main_table(TABLE_MAIN_COURSE_FIELD_VALUES);
  3119. $table_field = Database::get_main_table(TABLE_MAIN_COURSE_FIELD);
  3120. $course_user_table = Database :: get_main_table(TABLE_MAIN_COURSE_USER);
  3121. $location_table = Database :: get_main_table(MAIN_LOCATION_TABLE);
  3122. $user_role_table = Database :: get_main_table(MAIN_USER_ROLE_TABLE);
  3123. $tbl_session_rel_course_user = Database::get_main_table(TABLE_MAIN_SESSION_COURSE_USER);
  3124. $tbl_session_rel_user = Database::get_main_table(TABLE_MAIN_SESSION_USER);
  3125. $tbl_session = Database::get_main_table(TABLE_MAIN_SESSION);
  3126. $userscourses_params = $params['userscourses'];
  3127. $results = array();
  3128. $orig_user_id_value = array();
  3129. $orig_course_id_value = array();
  3130. foreach($userscourses_params as $usercourse_param) {
  3131. $original_user_id_values = $usercourse_param['original_user_id_values'];
  3132. $original_user_id_name = $usercourse_param['original_user_id_name'];
  3133. $original_course_id_value = $usercourse_param['original_course_id_value'];
  3134. $original_course_id_name = $usercourse_param['original_course_id_name'];
  3135. $orig_course_id_value[] = $original_course_id_value;
  3136. $status = STUDENT;
  3137. // get user id from original user id
  3138. $usersList = array();
  3139. foreach ($original_user_id_values as $row_original_user_list) {
  3140. $sql_user = "SELECT user_id FROM $t_uf uf,$t_ufv ufv WHERE ufv.field_id=uf.id AND field_variable='$original_user_id_name' AND field_value = '$row_original_user_list'";
  3141. //return $sql_user;
  3142. $res_user = api_sql_query($sql_user,__FILE__,__LINE__);
  3143. $row_user = Database::fetch_row($res_user);
  3144. if (empty($row_user[0])) {
  3145. continue; // user_id don't exist'
  3146. } else {
  3147. $sql = "SELECT user_id FROM $user_table WHERE user_id ='".$row_user[0]."' AND active= '0'";
  3148. $resu = api_sql_query($sql,__FILE__,__LINE__);
  3149. $r_check_user = Database::fetch_row($resu);
  3150. if (!empty($r_check_user[0])) {
  3151. continue; // user_id is not active
  3152. }
  3153. }
  3154. $usersList[] = $row_user[0];
  3155. }
  3156. $orig_user_id_value[] = implode(",",$usersList);
  3157. // get course code from original course id
  3158. $sql_course = "SELECT course_code FROM $table_field cf,$t_cfv cfv WHERE cfv.field_id=cf.id AND field_variable='$original_course_id_name' AND field_value='$original_course_id_value'";
  3159. $res_course = api_sql_query($sql_course,__FILE__,__LINE__);
  3160. $row_course = Database::fetch_row($res_course);
  3161. $course_code=$row_course[0];
  3162. if (empty($course_code)) {
  3163. $results[] = 0; // original_course_id_value doesn't exits
  3164. continue;
  3165. } else {
  3166. $sql = "SELECT code FROM $course_table WHERE code ='$course_code' AND visibility = '0'";
  3167. $resc = api_sql_query($sql,__FILE__,__LINE__);
  3168. $r_check_code = Database::fetch_row($resc);
  3169. if (!empty($r_check_code[0])) {
  3170. $results[] = 0; // this code is not active
  3171. continue;
  3172. }
  3173. }
  3174. $status = ($status == STUDENT || $status == COURSEMANAGER) ? $status : STUDENT;
  3175. $role_id = ($status == COURSEMANAGER) ? COURSE_ADMIN : NORMAL_COURSE_MEMBER;
  3176. $course_code = Database::escape_string($course_code);
  3177. if (empty ($usersList) || empty ($course_code)) {
  3178. $results[] = 0;
  3179. continue;
  3180. } else {
  3181. foreach($usersList as $user_id) {
  3182. // previously check if the user are already registered on the platform
  3183. $handle = @api_sql_query("SELECT status FROM ".$user_table."
  3184. WHERE user_id = '$user_id' ", __FILE__, __LINE__);
  3185. if (Database::num_rows($handle) == 0){
  3186. //$results[] = 7; // the user isn't registered to the platform
  3187. continue;
  3188. } else {
  3189. //check if user isn't already subscribed to the course
  3190. $handle = @api_sql_query("SELECT * FROM ".$course_user_table."
  3191. WHERE user_id = '$user_id'
  3192. AND course_code ='$course_code'", __FILE__, __LINE__);
  3193. if (Database::num_rows($handle) > 0) {
  3194. //$results[] = 8; // the user is already subscribed to the course
  3195. continue;
  3196. } else {
  3197. $course_sort = CourseManager :: userCourseSort($user_id,$course_code);
  3198. $add_course_user_entry_sql = "INSERT INTO ".$course_user_table."
  3199. SET course_code = '$course_code',
  3200. user_id = '$user_id',
  3201. status = '".$status."',
  3202. sort = '". ($course_sort)."'";
  3203. $result = @api_sql_query($add_course_user_entry_sql, __FILE__, __LINE__);
  3204. }
  3205. }
  3206. } // end foreach usersList
  3207. }
  3208. $results[] = 1;
  3209. continue;
  3210. } // end principal foreach
  3211. $count_results = count($results);
  3212. $output = array();
  3213. for($i = 0; $i < $count_results; $i++) {
  3214. $output[] = array('original_user_id_value' =>$orig_user_id_value[$i],'original_course_id_value' =>$orig_course_id_value[$i],'result' => $results[$i]);
  3215. }
  3216. return $output;
  3217. }
  3218. /* Register DokeosWSUnsubscribeUserFromCourse function */
  3219. // Register the data structures used by the service
  3220. $server->wsdl->addComplexType(
  3221. 'unsuscribeUserFromCourseParams',
  3222. 'complexType',
  3223. 'struct',
  3224. 'all',
  3225. '',
  3226. array(
  3227. 'original_user_id_values' => array('name' => 'original_user_id_values', 'type' => 'tns:originalUsersList'),
  3228. 'original_user_id_name' => array('name' => 'original_user_id_name', 'type' => 'xsd:string'),
  3229. 'original_course_id_value' => array('name' => 'original_course_id_value', 'type' => 'xsd:string'),
  3230. 'original_course_id_name' => array('name' => 'original_course_id_name', 'type' => 'xsd:string'),
  3231. )
  3232. );
  3233. $server->wsdl->addComplexType(
  3234. 'unsuscribeUserFromCourseParamsList',
  3235. 'complexType',
  3236. 'array',
  3237. '',
  3238. 'SOAP-ENC:Array',
  3239. array(),
  3240. array(array('ref'=>'SOAP-ENC:arrayType','wsdl:arrayType' => 'tns:unsuscribeUserFromCourseParams[]')),'tns:unsuscribeUserFromCourseParams'
  3241. );
  3242. $server->wsdl->addComplexType(
  3243. 'unsuscribeUserFromCourse',
  3244. 'complexType',
  3245. 'struct',
  3246. 'all',
  3247. '',
  3248. array(
  3249. 'userscourses' => array('name' => 'userscourses', 'type' => 'tns:unsuscribeUserFromCourseParamsList'),
  3250. 'secret_key' => array('name' => 'secret_key', 'type' => 'xsd:string')
  3251. )
  3252. );
  3253. // Prepare output params, in this case will return an array
  3254. $server->wsdl->addComplexType(
  3255. 'result_unsuscribeUserFromCourse',
  3256. 'complexType',
  3257. 'struct',
  3258. 'all',
  3259. '',
  3260. array(
  3261. 'original_user_id_values' => array('name' => 'original_user_id_values', 'type' => 'xsd:string'),
  3262. 'original_course_id_value' => array('name' => 'original_course_id_value', 'type' => 'xsd:string'),
  3263. 'result' => array('name' => 'result', 'type' => 'xsd:string')
  3264. )
  3265. );
  3266. $server->wsdl->addComplexType(
  3267. 'results_unsuscribeUserFromCourse',
  3268. 'complexType',
  3269. 'array',
  3270. '',
  3271. 'SOAP-ENC:Array',
  3272. array(),
  3273. array(array('ref'=>'SOAP-ENC:arrayType','wsdl:arrayType' => 'tns:result_unsuscribeUserFromCourse[]')),'tns:result_unsuscribeUserFromCourse'
  3274. );
  3275. // Register the method to expose
  3276. $server->register('DokeosWSUnsubscribeUserFromCourse', // method name
  3277. array('unsuscribeUserFromCourse' => 'tns:unsuscribeUserFromCourse'),// input parameters
  3278. array('return' => 'tns:results_unsuscribeUserFromCourse'), // output parameters
  3279. 'urn:WSRegistration', // namespace
  3280. 'urn:WSRegistration#DokeosWSUnsubscribeUserFromCourse', // soapaction
  3281. 'rpc', // style
  3282. 'encoded', // use
  3283. 'This service unsubscribes a user from a course' // documentation
  3284. );
  3285. // define the method DokeosWSUnsubscribeUserFromCourse
  3286. function DokeosWSUnsubscribeUserFromCourse($params)
  3287. {
  3288. global $_configuration;
  3289. $secret_key = $params['secret_key'];
  3290. $security_key = $_SERVER['REMOTE_ADDR'].$_configuration['security_key'];
  3291. if (!api_is_valid_secret_key($secret_key,$security_key)) {
  3292. return -1; //secret key is incorrect
  3293. }
  3294. $user_table = Database::get_main_table(TABLE_MAIN_USER);
  3295. $t_uf = Database::get_main_table(TABLE_MAIN_USER_FIELD);
  3296. $t_ufv = Database::get_main_table(TABLE_MAIN_USER_FIELD_VALUES);
  3297. $table_course = Database :: get_main_table(TABLE_MAIN_COURSE);
  3298. $table_course_user = Database :: get_main_table(TABLE_MAIN_COURSE_USER);
  3299. $t_cfv = Database::get_main_table(TABLE_MAIN_COURSE_FIELD_VALUES);
  3300. $table_field = Database::get_main_table(TABLE_MAIN_COURSE_FIELD);
  3301. $userscourses_params = $params['userscourses'];
  3302. $results = array();
  3303. $orig_user_id_value = array();
  3304. $orig_course_id_value = array();
  3305. foreach($userscourses_params as $usercourse_param) {
  3306. $original_user_id_values = $usercourse_param['original_user_id_values'];
  3307. $original_user_id_name = $usercourse_param['original_user_id_name'];
  3308. $original_course_id_value = $usercourse_param['original_course_id_value'];
  3309. $original_course_id_name = $usercourse_param['original_course_id_name'];
  3310. $orig_course_id_value[] = $original_course_id_value;
  3311. // get user id from original user id
  3312. // get user id from original user id
  3313. $usersList = array();
  3314. foreach ($original_user_id_values as $row_original_user_list) {
  3315. $sql_user = "SELECT user_id FROM $t_uf uf,$t_ufv ufv WHERE ufv.field_id=uf.id AND field_variable='$original_user_id_name' AND field_value = '$row_original_user_list'";
  3316. //return $sql_user;
  3317. $res_user = api_sql_query($sql_user,__FILE__,__LINE__);
  3318. $row_user = Database::fetch_row($res_user);
  3319. if (empty($row_user[0])) {
  3320. continue; // user_id don't exist'
  3321. } else {
  3322. $sql = "SELECT user_id FROM $user_table WHERE user_id ='".$row_user[0]."' AND active= '0'";
  3323. $resu = api_sql_query($sql,__FILE__,__LINE__);
  3324. $r_check_user = Database::fetch_row($resu);
  3325. if (!empty($r_check_user[0])) {
  3326. continue; // user_id is not active
  3327. }
  3328. }
  3329. $usersList[] = $row_user[0];
  3330. }
  3331. $orig_user_id_value[] = implode(",",$usersList);
  3332. // get course code from original course id
  3333. $sql_course = "SELECT course_code FROM $table_field cf,$t_cfv cfv WHERE cfv.field_id=cf.id AND field_variable='$original_course_id_name' AND field_value='$original_course_id_value'";
  3334. $res_course = api_sql_query($sql_course,__FILE__,__LINE__);
  3335. $row_course = Database::fetch_row($res_course);
  3336. $course_code = $row_course[0];
  3337. if (empty($course_code)) {
  3338. $results[] = 0;
  3339. continue;
  3340. } else {
  3341. $sql = "SELECT code FROM $table_course WHERE code ='$course_code' AND visibility = '0'";
  3342. $resul = api_sql_query($sql,__FILE__,__LINE__);
  3343. $r_check_code = Database::fetch_row($resul);
  3344. if (!empty($r_check_code[0])) {
  3345. $results[] = 0;
  3346. continue;
  3347. }
  3348. }
  3349. if(count($usersList) == 0) {
  3350. $results[] = 0;
  3351. continue;
  3352. }
  3353. foreach($usersList as $user_id) {
  3354. $course_code = Database::escape_string($course_code);
  3355. $sql = "DELETE FROM $table_course_user WHERE user_id = '$user_id' AND course_code = '".$course_code."'";
  3356. api_sql_query($sql, __FILE__, __LINE__);
  3357. $return = Database::affected_rows();
  3358. }
  3359. $results[] = 1;
  3360. continue;
  3361. } // end principal foreach
  3362. $count_results = count($results);
  3363. $output = array();
  3364. for($i = 0; $i < $count_results; $i++) {
  3365. $output[] = array('original_user_id_values' =>$orig_user_id_value[$i],'original_course_id_value' =>$orig_course_id_value[$i],'result' => $results[$i]);
  3366. }
  3367. return $output;
  3368. }
  3369. /* Register DokeosWSSuscribeUsersToSession function */
  3370. // Register the data structures used by the service
  3371. $server->wsdl->addComplexType(
  3372. 'subscribeUsersToSessionParams',
  3373. 'complexType',
  3374. 'struct',
  3375. 'all',
  3376. '',
  3377. array(
  3378. 'original_user_id_values' => array('name' => 'original_user_id_values', 'type' => 'tns:originalUsersList'),
  3379. 'original_user_id_name' => array('name' => 'original_user_id_name', 'type' => 'xsd:string'),
  3380. 'original_session_id_value' => array('name' => 'original_session_id_value', 'type' => 'xsd:string'),
  3381. 'original_session_id_name' => array('name' => 'original_session_id_name', 'type' => 'xsd:string')
  3382. )
  3383. );
  3384. $server->wsdl->addComplexType(
  3385. 'subscribeUsersToSessionParamsList',
  3386. 'complexType',
  3387. 'array',
  3388. '',
  3389. 'SOAP-ENC:Array',
  3390. array(),
  3391. array(array('ref'=>'SOAP-ENC:arrayType','wsdl:arrayType' => 'tns:subscribeUsersToSessionParams[]')),'tns:subscribeUsersToSessionParams'
  3392. );
  3393. $server->wsdl->addComplexType(
  3394. 'subscribeUsersToSession',
  3395. 'complexType',
  3396. 'struct',
  3397. 'all',
  3398. '',
  3399. array(
  3400. 'userssessions' => array('name' => 'userssessions', 'type' => 'tns:subscribeUsersToSessionParamsList'),
  3401. 'secret_key' => array('name' => 'secret_key', 'type' => 'xsd:string')
  3402. )
  3403. );
  3404. // Prepare output params, in this case will return an array
  3405. $server->wsdl->addComplexType(
  3406. 'result_subscribeUsersToSession',
  3407. 'complexType',
  3408. 'struct',
  3409. 'all',
  3410. '',
  3411. array(
  3412. 'original_user_id_values' => array('name' => 'original_user_id_values', 'type' => 'xsd:string'),
  3413. 'original_session_id_value' => array('name' => 'original_session_id_value', 'type' => 'xsd:string'),
  3414. 'result' => array('name' => 'result', 'type' => 'xsd:string')
  3415. )
  3416. );
  3417. $server->wsdl->addComplexType(
  3418. 'results_subscribeUsersToSession',
  3419. 'complexType',
  3420. 'array',
  3421. '',
  3422. 'SOAP-ENC:Array',
  3423. array(),
  3424. array(array('ref'=>'SOAP-ENC:arrayType','wsdl:arrayType' => 'tns:result_subscribeUsersToSession[]')),'tns:result_subscribeUsersToSession'
  3425. );
  3426. // Register the method to expose
  3427. $server->register('DokeosWSSuscribeUsersToSession', // method name
  3428. array('subscribeUsersToSession' => 'tns:subscribeUsersToSession'), // input parameters
  3429. array('return' => 'tns:results_subscribeUsersToSession'), // output parameters
  3430. 'urn:WSRegistration', // namespace
  3431. 'urn:WSRegistration#DokeosWSSuscribeUsersToSession', // soapaction
  3432. 'rpc', // style
  3433. 'encoded', // use
  3434. 'This service subscribes a user to a session' // documentation
  3435. );
  3436. // define the method DokeosWSSuscribeUsersToSession
  3437. function DokeosWSSuscribeUsersToSession($params){
  3438. global $_configuration;
  3439. $secret_key = $params['secret_key'];
  3440. $security_key = $_SERVER['REMOTE_ADDR'].$_configuration['security_key'];
  3441. if (!api_is_valid_secret_key($secret_key,$security_key)) {
  3442. return -1; //secret key is incorrect
  3443. }
  3444. $user_table = Database::get_main_table(TABLE_MAIN_USER);
  3445. $t_uf = Database::get_main_table(TABLE_MAIN_USER_FIELD);
  3446. $t_ufv = Database::get_main_table(TABLE_MAIN_USER_FIELD_VALUES);
  3447. $t_sf = Database::get_main_table(TABLE_MAIN_SESSION_FIELD);
  3448. $t_sfv = Database::get_main_table(TABLE_MAIN_SESSION_FIELD_VALUES);
  3449. $tbl_session_rel_course = Database::get_main_table(TABLE_MAIN_SESSION_COURSE);
  3450. $tbl_session_rel_course_rel_user = Database::get_main_table(TABLE_MAIN_SESSION_COURSE_USER);
  3451. $tbl_session_rel_user = Database::get_main_table(TABLE_MAIN_SESSION_USER);
  3452. $tbl_session = Database::get_main_table(TABLE_MAIN_SESSION);
  3453. $userssessions_params = $params['userssessions'];
  3454. $results = array();
  3455. $orig_user_id_value = array();
  3456. $orig_session_id_value = array();
  3457. foreach($userssessions_params as $usersession_params) {
  3458. $original_session_id_value = $usersession_params['original_session_id_value'];
  3459. $original_session_id_name = $usersession_params['original_session_id_name'];
  3460. $original_user_id_name = $usersession_params['original_user_id_name'];
  3461. $original_user_id_values = $usersession_params['original_user_id_values'];
  3462. $orig_session_id_value[] = $original_session_id_value;
  3463. // get session id from original session id
  3464. $sql_session = "SELECT session_id FROM $t_sf sf,$t_sfv sfv WHERE sfv.field_id=sf.id AND field_variable='$original_session_id_name' AND field_value='$original_session_id_value'";
  3465. $res_session = api_sql_query($sql_session,__FILE__,__LINE__);
  3466. $row_session = Database::fetch_row($res_session);
  3467. $id_session = $row_session[0];
  3468. if (Database::num_rows($res_session) < 1) {
  3469. $results[] = 0;
  3470. continue;
  3471. }
  3472. $usersList = array();
  3473. foreach ($original_user_id_values as $row_original_user_list) {
  3474. $sql_user = "SELECT user_id FROM $t_uf uf,$t_ufv ufv WHERE ufv.field_id=uf.id AND field_variable='$original_user_id_name' AND field_value = '$row_original_user_list'";
  3475. $res_user = api_sql_query($sql_user,__FILE__,__LINE__);
  3476. $row_user = Database::fetch_row($res_user);
  3477. if (empty($row_user[0])) {
  3478. continue; // user_id don't exist'
  3479. } else {
  3480. $sql = "SELECT user_id FROM $user_table WHERE user_id ='".$row_user[0]."' AND active= '0'";
  3481. $resu = api_sql_query($sql,__FILE__,__LINE__);
  3482. $r_check_user = Database::fetch_row($resu);
  3483. if (!empty($r_check_user[0])) {
  3484. continue; // user_id is not active
  3485. }
  3486. }
  3487. $usersList[] = $row_user[0];
  3488. }
  3489. if (empty($usersList)) {
  3490. $results[] = 0;
  3491. continue;
  3492. }
  3493. $orig_user_id_value[] = implode(",",$usersList);
  3494. if ($id_session!= strval(intval($id_session))) {
  3495. $results[] = 0;
  3496. continue;
  3497. }
  3498. $sql = "SELECT id_user FROM $tbl_session_rel_user WHERE id_session='$id_session'";
  3499. $result = api_sql_query($sql,__FILE__,__LINE__);
  3500. $existingUsers = array();
  3501. while($row = Database::fetch_array($result)){
  3502. $existingUsers[] = $row['id_user'];
  3503. }
  3504. $sql = "SELECT course_code FROM $tbl_session_rel_course WHERE id_session='$id_session'";
  3505. $result=api_sql_query($sql,__FILE__,__LINE__);
  3506. $CourseList=array();
  3507. while($row=Database::fetch_array($result)) {
  3508. $CourseList[]=$row['course_code'];
  3509. }
  3510. foreach ($CourseList as $enreg_course) {
  3511. // for each course in the session
  3512. $nbr_users=0;
  3513. $enreg_course = Database::escape_string($enreg_course);
  3514. // insert new users into session_rel_course_rel_user and ignore if they already exist
  3515. foreach ($usersList as $enreg_user) {
  3516. if(!in_array($enreg_user, $existingUsers)) {
  3517. $enreg_user = Database::escape_string($enreg_user);
  3518. $insert_sql = "INSERT IGNORE INTO $tbl_session_rel_course_rel_user(id_session,course_code,id_user) VALUES('$id_session','$enreg_course','$enreg_user')";
  3519. api_sql_query($insert_sql,__FILE__,__LINE__);
  3520. if(Database::affected_rows()) {
  3521. $nbr_users++;
  3522. }
  3523. }
  3524. }
  3525. // count users in this session-course relation
  3526. $sql = "SELECT COUNT(id_user) as nbUsers FROM $tbl_session_rel_course_rel_user WHERE id_session='$id_session' AND course_code='$enreg_course'";
  3527. $rs = api_sql_query($sql, __FILE__, __LINE__);
  3528. list($nbr_users) = Database::fetch_array($rs);
  3529. // update the session-course relation to add the users total
  3530. $update_sql = "UPDATE $tbl_session_rel_course SET nbr_users=$nbr_users WHERE id_session='$id_session' AND course_code='$enreg_course'";
  3531. api_sql_query($update_sql,__FILE__,__LINE__);
  3532. }
  3533. // insert missing users into session
  3534. $nbr_users = 0;
  3535. foreach ($usersList as $enreg_user) {
  3536. $enreg_user = Database::escape_string($enreg_user);
  3537. $nbr_users++;
  3538. $insert_sql = "INSERT IGNORE INTO $tbl_session_rel_user(id_session, id_user) VALUES('$id_session','$enreg_user')";
  3539. api_sql_query($insert_sql,__FILE__,__LINE__);
  3540. }
  3541. // update number of users in the session
  3542. $nbr_users = count($usersList);
  3543. $update_sql = "UPDATE $tbl_session SET nbr_users= $nbr_users WHERE id='$id_session' ";
  3544. api_sql_query($update_sql,__FILE__,__LINE__);
  3545. $return = Database::affected_rows();
  3546. $results[] = 1;
  3547. continue;
  3548. } // end principal foreach
  3549. $count_results = count($results);
  3550. $output = array();
  3551. for($i = 0; $i < $count_results; $i++) {
  3552. $output[] = array('original_user_id_values' =>$orig_user_id_value[$i],'original_session_id_value' =>$orig_session_id_value[$i],'result' => $results[$i]);
  3553. }
  3554. return $output;
  3555. }
  3556. /* Register DokeosWSUnsuscribeUsersFromSession function */
  3557. // Register the data structures used by the service
  3558. $server->wsdl->addComplexType(
  3559. 'unsubscribeUsersFromSessionParams',
  3560. 'complexType',
  3561. 'struct',
  3562. 'all',
  3563. '',
  3564. array(
  3565. 'original_user_id_values' => array('name' => 'original_user_id_values', 'type' => 'tns:originalUsersList'),
  3566. 'original_user_id_name' => array('name' => 'original_user_id_name', 'type' => 'xsd:string'),
  3567. 'original_session_id_value' => array('name' => 'original_session_id_value', 'type' => 'xsd:string'),
  3568. 'original_session_id_name' => array('name' => 'original_session_id_name', 'type' => 'xsd:string')
  3569. )
  3570. );
  3571. $server->wsdl->addComplexType(
  3572. 'unsubscribeUsersFromSessionParamsList',
  3573. 'complexType',
  3574. 'array',
  3575. '',
  3576. 'SOAP-ENC:Array',
  3577. array(),
  3578. array(array('ref'=>'SOAP-ENC:arrayType','wsdl:arrayType' => 'tns:unsubscribeUsersFromSessionParams[]')),'tns:unsubscribeUsersFromSessionParams'
  3579. );
  3580. $server->wsdl->addComplexType(
  3581. 'unsubscribeUsersFromSession',
  3582. 'complexType',
  3583. 'struct',
  3584. 'all',
  3585. '',
  3586. array(
  3587. 'userssessions' => array('name' => 'userssessions', 'type' => 'tns:subscribeUsersToSessionParamsList'),
  3588. 'secret_key' => array('name' => 'secret_key', 'type' => 'xsd:string')
  3589. )
  3590. );
  3591. // Prepare output params, in this case will return an array
  3592. $server->wsdl->addComplexType(
  3593. 'result_unsubscribeUsersFromSession',
  3594. 'complexType',
  3595. 'struct',
  3596. 'all',
  3597. '',
  3598. array(
  3599. 'original_user_id_values' => array('name' => 'original_user_id_values', 'type' => 'xsd:string'),
  3600. 'original_session_id_value' => array('name' => 'original_session_id_value', 'type' => 'xsd:string'),
  3601. 'result' => array('name' => 'result', 'type' => 'xsd:string')
  3602. )
  3603. );
  3604. $server->wsdl->addComplexType(
  3605. 'results_unsubscribeUsersFromSession',
  3606. 'complexType',
  3607. 'array',
  3608. '',
  3609. 'SOAP-ENC:Array',
  3610. array(),
  3611. array(array('ref'=>'SOAP-ENC:arrayType','wsdl:arrayType' => 'tns:result_unsubscribeUsersFromSession[]')),'tns:result_unsubscribeUsersFromSession'
  3612. );
  3613. // Register the method to expose
  3614. $server->register('DokeosWSUnsuscribeUsersFromSession', // method name
  3615. array('unsubscribeUsersFromSession' => 'tns:unsubscribeUsersFromSession'), // input parameters
  3616. array('return' => 'tns:results_unsubscribeUsersFromSession'), // output parameters
  3617. 'urn:WSRegistration', // namespace
  3618. 'urn:WSRegistration#DokeosWSUnsuscribeUsersFromSession', // soapaction
  3619. 'rpc', // style
  3620. 'encoded', // use
  3621. 'This service unsubscribes a user to a session' // documentation
  3622. );
  3623. // define the method DokeosWSUnsuscribeUsersFromSession
  3624. function DokeosWSUnsuscribeUsersFromSession($params){
  3625. global $_configuration;
  3626. $secret_key = $params['secret_key'];
  3627. $security_key = $_SERVER['REMOTE_ADDR'].$_configuration['security_key'];
  3628. if (!api_is_valid_secret_key($secret_key,$security_key)) {
  3629. return -1; //secret key is incorrect
  3630. }
  3631. $user_table = Database::get_main_table(TABLE_MAIN_USER);
  3632. $t_uf = Database::get_main_table(TABLE_MAIN_USER_FIELD);
  3633. $t_ufv = Database::get_main_table(TABLE_MAIN_USER_FIELD_VALUES);
  3634. $t_sf = Database::get_main_table(TABLE_MAIN_SESSION_FIELD);
  3635. $t_sfv = Database::get_main_table(TABLE_MAIN_SESSION_FIELD_VALUES);
  3636. $tbl_session_rel_course = Database::get_main_table(TABLE_MAIN_SESSION_COURSE);
  3637. $tbl_session_rel_course_rel_user = Database::get_main_table(TABLE_MAIN_SESSION_COURSE_USER);
  3638. $tbl_session_rel_user = Database::get_main_table(TABLE_MAIN_SESSION_USER);
  3639. $tbl_session = Database::get_main_table(TABLE_MAIN_SESSION);
  3640. $userssessions_params = $params['userssessions'];
  3641. $results = array();
  3642. $orig_user_id_value = array();
  3643. $orig_session_id_value = array();
  3644. foreach($userssessions_params as $usersession_params) {
  3645. $original_session_id_value = $usersession_params['original_session_id_value'];
  3646. $original_session_id_name = $usersession_params['original_session_id_name'];
  3647. $original_user_id_name = $usersession_params['original_user_id_name'];
  3648. $original_user_id_values = $usersession_params['original_user_id_values'];
  3649. $orig_session_id_value[] = $original_session_id_value;
  3650. // get session id from original session id
  3651. $sql_session = "SELECT session_id FROM $t_sf sf,$t_sfv sfv WHERE sfv.field_id=sf.id AND field_variable='$original_session_id_name' AND field_value='$original_session_id_value'";
  3652. $res_session = api_sql_query($sql_session,__FILE__,__LINE__);
  3653. $row_session = Database::fetch_row($res_session);
  3654. $id_session = $row_session[0];
  3655. if (Database::num_rows($res_session) < 1) {
  3656. $results[] = 0;
  3657. continue;
  3658. }
  3659. $usersList = array();
  3660. foreach ($original_user_id_values as $row_original_user_list) {
  3661. $sql_user = "SELECT user_id FROM $t_uf uf,$t_ufv ufv WHERE ufv.field_id=uf.id AND field_variable='$original_user_id_name' AND field_value = '$row_original_user_list'";
  3662. $res_user = api_sql_query($sql_user,__FILE__,__LINE__);
  3663. $row_user = Database::fetch_row($res_user);
  3664. if (empty($row_user[0])) {
  3665. continue; // user_id don't exist'
  3666. } else {
  3667. $sql = "SELECT user_id FROM $user_table WHERE user_id ='".$row_user[0]."' AND active= '0'";
  3668. $resu = api_sql_query($sql,__FILE__,__LINE__);
  3669. $r_check_user = Database::fetch_row($resu);
  3670. if (!empty($r_check_user[0])) {
  3671. continue; // user_id is not active
  3672. }
  3673. }
  3674. $usersList[] = $row_user[0];
  3675. }
  3676. if (empty($usersList)) {
  3677. $results[] = 0;
  3678. continue;
  3679. }
  3680. $orig_user_id_value[] = implode(",",$usersList);
  3681. if ($id_session!= strval(intval($id_session))) {
  3682. $results[] = 0;
  3683. continue;
  3684. }
  3685. $sql = "SELECT id_user FROM $tbl_session_rel_user WHERE id_session='$id_session'";
  3686. $result = api_sql_query($sql,__FILE__,__LINE__);
  3687. $existingUsers = array();
  3688. while($row = Database::fetch_array($result)){
  3689. $existingUsers[] = $row['id_user'];
  3690. }
  3691. $sql = "SELECT course_code FROM $tbl_session_rel_course WHERE id_session='$id_session'";
  3692. $result=api_sql_query($sql,__FILE__,__LINE__);
  3693. $CourseList=array();
  3694. while($row=Database::fetch_array($result)) {
  3695. $CourseList[]=$row['course_code'];
  3696. }
  3697. foreach ($CourseList as $enreg_course) {
  3698. // for each course in the session
  3699. $nbr_users=0;
  3700. $enreg_course = Database::escape_string($enreg_course);
  3701. foreach ($existingUsers as $existing_user) {
  3702. if(!in_array($existing_user, $usersList)) {
  3703. $sql = "DELETE FROM $tbl_session_rel_course_rel_user WHERE id_session='$id_session' AND course_code='$enreg_course' AND id_user='$existing_user'";
  3704. api_sql_query($sql,__FILE__,__LINE__);
  3705. if(Database::affected_rows()) {
  3706. $nbr_users--;
  3707. }
  3708. }
  3709. }
  3710. // count users in this session-course relation
  3711. $sql = "SELECT COUNT(id_user) as nbUsers FROM $tbl_session_rel_course_rel_user WHERE id_session='$id_session' AND course_code='$enreg_course'";
  3712. $rs = api_sql_query($sql, __FILE__, __LINE__);
  3713. list($nbr_users) = Database::fetch_array($rs);
  3714. // update the session-course relation to add the users total
  3715. $update_sql = "UPDATE $tbl_session_rel_course SET nbr_users=$nbr_users WHERE id_session='$id_session' AND course_code='$enreg_course'";
  3716. api_sql_query($update_sql,__FILE__,__LINE__);
  3717. }
  3718. // insert missing users into session
  3719. foreach ($usersList as $enreg_user) {
  3720. $enreg_user = Database::escape_string($enreg_user);
  3721. $delete_sql = "DELETE FROM $tbl_session_rel_user WHERE id_session = '$id_session' AND id_user ='$enreg_user'";
  3722. api_sql_query($delete_sql,__FILE__,__LINE__);
  3723. $return = Database::affected_rows();
  3724. }
  3725. $nbr_users = 0;
  3726. $sql = "SELECT nbr_users FROM $tbl_session WHERE id = '$id_session'";
  3727. $res_nbr_users = api_sql_query($sql,__FILE__,__LINE__);
  3728. $row_nbr_users = Database::fetch_row($res_nbr_users);
  3729. if (Database::num_rows($res_nbr_users) > 0) {
  3730. $nbr_users = ($row_nbr_users[0] - $return);
  3731. }
  3732. // update number of users in the session
  3733. $update_sql = "UPDATE $tbl_session SET nbr_users= $nbr_users WHERE id='$id_session' ";
  3734. api_sql_query($update_sql,__FILE__,__LINE__);
  3735. $return = Database::affected_rows();
  3736. $results[] = 1;
  3737. continue;
  3738. } // end principal foreach
  3739. $count_results = count($results);
  3740. $output = array();
  3741. for($i = 0; $i < $count_results; $i++) {
  3742. $output[] = array('original_user_id_values' =>$orig_user_id_value[$i],'original_session_id_value' =>$orig_session_id_value[$i],'result' => $results[$i]);
  3743. }
  3744. return $output;
  3745. }
  3746. /* Register DokeosWSSuscribeCoursesToSession function */
  3747. // Register the data structures used by the service
  3748. $server->wsdl->addComplexType(
  3749. 'originalCoursesList',
  3750. 'complexType',
  3751. 'array',
  3752. '',
  3753. 'SOAP-ENC:Array',
  3754. array(),
  3755. array(array('ref'=>'SOAP-ENC:arrayType','wsdl:arrayType' => 'string[]')),'xsd:string'
  3756. );
  3757. $server->wsdl->addComplexType(
  3758. 'subscribeCoursesToSessionParams',
  3759. 'complexType',
  3760. 'struct',
  3761. 'all',
  3762. '',
  3763. array(
  3764. 'original_course_id_values' => array('name' => 'original_course_id_values', 'type' => 'tns:originalCoursesList'),
  3765. 'original_course_id_name' => array('name' => 'original_course_id_name', 'type' => 'xsd:string'),
  3766. 'original_session_id_value' => array('name' => 'original_session_id_value', 'type' => 'xsd:string'),
  3767. 'original_session_id_name' => array('name' => 'original_session_id_name', 'type' => 'xsd:string')
  3768. )
  3769. );
  3770. $server->wsdl->addComplexType(
  3771. 'subscribeCoursesToSessionParamsList',
  3772. 'complexType',
  3773. 'array',
  3774. '',
  3775. 'SOAP-ENC:Array',
  3776. array(),
  3777. array(array('ref'=>'SOAP-ENC:arrayType','wsdl:arrayType' => 'tns:subscribeCoursesToSessionParams[]')),'tns:subscribeCoursesToSessionParams'
  3778. );
  3779. $server->wsdl->addComplexType(
  3780. 'subscribeCoursesToSession',
  3781. 'complexType',
  3782. 'struct',
  3783. 'all',
  3784. '',
  3785. array(
  3786. 'coursessessions' => array('name' => 'coursessessions', 'type' => 'tns:subscribeCoursesToSessionParamsList'),
  3787. 'secret_key' => array('name' => 'secret_key', 'type' => 'xsd:string')
  3788. )
  3789. );
  3790. // Prepare output params, in this case will return an array
  3791. $server->wsdl->addComplexType(
  3792. 'result_subscribeCoursesToSession',
  3793. 'complexType',
  3794. 'struct',
  3795. 'all',
  3796. '',
  3797. array(
  3798. 'original_course_id_values' => array('name' => 'original_course_id_values', 'type' => 'xsd:string'),
  3799. 'original_session_id_value' => array('name' => 'original_session_id_value', 'type' => 'xsd:string'),
  3800. 'result' => array('name' => 'result', 'type' => 'xsd:string')
  3801. )
  3802. );
  3803. $server->wsdl->addComplexType(
  3804. 'results_subscribeCoursesToSession',
  3805. 'complexType',
  3806. 'array',
  3807. '',
  3808. 'SOAP-ENC:Array',
  3809. array(),
  3810. array(array('ref'=>'SOAP-ENC:arrayType','wsdl:arrayType' => 'tns:result_subscribeCoursesToSession[]')),'tns:result_subscribeCoursesToSession'
  3811. );
  3812. // Register the method to expose
  3813. $server->register('DokeosWSSuscribeCoursesToSession', // method name
  3814. array('subscribeCoursesToSession' => 'tns:subscribeCoursesToSession'), // input parameters
  3815. array('return' => 'tns:results_subscribeCoursesToSession'), // output parameters
  3816. 'urn:WSRegistration', // namespace
  3817. 'urn:WSRegistration#DokeosWSSuscribeCoursesToSession', // soapaction
  3818. 'rpc', // style
  3819. 'encoded', // use
  3820. 'This service subscribes a course to a session' // documentation
  3821. );
  3822. // define the method DokeosWSSuscribeCoursesToSession
  3823. function DokeosWSSuscribeCoursesToSession($params) {
  3824. global $_configuration;
  3825. $secret_key = $params['secret_key'];
  3826. $security_key = $_SERVER['REMOTE_ADDR'].$_configuration['security_key'];
  3827. if (!api_is_valid_secret_key($secret_key,$security_key)) {
  3828. return -1; //secret key is incorrect
  3829. }
  3830. // initialisation
  3831. $tbl_session_rel_course_rel_user = Database::get_main_table(TABLE_MAIN_SESSION_COURSE_USER);
  3832. $tbl_session = Database::get_main_table(TABLE_MAIN_SESSION);
  3833. $tbl_session_rel_user = Database::get_main_table(TABLE_MAIN_SESSION_USER);
  3834. $tbl_session_rel_course = Database::get_main_table(TABLE_MAIN_SESSION_COURSE);
  3835. $tbl_course = Database::get_main_table(TABLE_MAIN_COURSE);
  3836. $t_sf = Database::get_main_table(TABLE_MAIN_SESSION_FIELD);
  3837. $t_sfv = Database::get_main_table(TABLE_MAIN_SESSION_FIELD_VALUES);
  3838. $t_cfv = Database::get_main_table(TABLE_MAIN_COURSE_FIELD_VALUES);
  3839. $t_cf = Database::get_main_table(TABLE_MAIN_COURSE_FIELD);
  3840. $coursessessions_params = $params['coursessessions'];
  3841. $results = array();
  3842. $orig_course_id_value = array();
  3843. $orig_session_id_value = array();
  3844. foreach($coursessessions_params as $coursesession_param) {
  3845. $original_session_id_value = $coursesession_param['original_session_id_value'];
  3846. $original_session_id_name = $coursesession_param['original_session_id_name'];
  3847. $original_course_id_name = $coursesession_param['original_course_id_name'];
  3848. $original_course_id_values = $coursesession_param['original_course_id_values'];
  3849. $orig_session_id_value[] = $original_session_id_value;
  3850. // get session id from original session id
  3851. $sql_session = "SELECT session_id FROM $t_sf sf,$t_sfv sfv WHERE sfv.field_id=sf.id AND field_variable='$original_session_id_name' AND field_value='$original_session_id_value'";
  3852. $res_session = api_sql_query($sql_session,__FILE__,__LINE__);
  3853. $row_session = Database::fetch_row($res_session);
  3854. $id_session = $row_session[0];
  3855. if (empty($id_session)) {
  3856. $results[] = 0;
  3857. continue;
  3858. }
  3859. // get courses list from row_original_course_id_values
  3860. $course_list = array();
  3861. foreach ($original_course_id_values as $row_original_course_list) {
  3862. $sql_course = "SELECT course_code FROM $t_cf cf,$t_cfv cfv WHERE cfv.field_id=cf.id AND field_variable='$original_course_id_name' AND field_value = '$row_original_course_list'";
  3863. $res_course = api_sql_query($sql_course,__FILE__,__LINE__);
  3864. $row_course = Database::fetch_row($res_course);
  3865. if (empty($row_course[0])) {
  3866. continue; // course_code don't exist'
  3867. } else {
  3868. $sql = "SELECT code FROM $tbl_course WHERE code ='".$row_course[0]."' AND visibility = '0'";
  3869. $resu = api_sql_query($sql,__FILE__,__LINE__);
  3870. $r_check_course = Database::fetch_row($resu);
  3871. if (!empty($r_check_course[0])) {
  3872. continue; // user_id is not active
  3873. }
  3874. }
  3875. $course_list[] = $row_course[0];
  3876. }
  3877. if (empty($course_list)) {
  3878. $results[] = 0;
  3879. continue;
  3880. }
  3881. $orig_course_id_value[] = implode(",",$course_list);
  3882. // get general coach ID
  3883. $sql = "SELECT id_coach FROM $tbl_session WHERE id='$id_session'";
  3884. $id_coach = api_sql_query($sql,__FILE__,__LINE__);
  3885. $id_coach = Database::fetch_array($id_coach);
  3886. $id_coach = $id_coach[0];
  3887. // get list of courses subscribed to this session
  3888. $sql = "SELECT course_code FROM $tbl_session_rel_course WHERE id_session='$id_session'";
  3889. $rs = api_sql_query($sql,__FILE__,__LINE__);
  3890. $existingCourses = api_store_result($rs);
  3891. $nbr_courses=count($existingCourses);
  3892. // get list of users subscribed to this session
  3893. $sql="SELECT id_user
  3894. FROM $tbl_session_rel_user
  3895. WHERE id_session = '$id_session'";
  3896. $result=api_sql_query($sql,__FILE__,__LINE__);
  3897. $user_list=api_store_result($result);
  3898. $course_directory= array();
  3899. // Pass through the courses list we want to add to the session
  3900. foreach ($course_list as $enreg_course) {
  3901. $enreg_course = Database::escape_string($enreg_course);
  3902. $exists = false;
  3903. // check if the course we want to add is already subscribed
  3904. foreach ($existingCourses as $existingCourse) {
  3905. if ($enreg_course == $existingCourse['course_code']) {
  3906. $exists=true;
  3907. }
  3908. }
  3909. if (!$exists) {
  3910. //if the course isn't subscribed yet
  3911. $sql_insert_rel_course= "INSERT INTO $tbl_session_rel_course (id_session,course_code, id_coach) VALUES ('$id_session','$enreg_course','$id_coach')";
  3912. api_sql_query($sql_insert_rel_course ,__FILE__,__LINE__);
  3913. //We add the current course in the existing courses array, to avoid adding another time the current course
  3914. $existingCourses[]=array('course_code'=>$enreg_course);
  3915. $nbr_courses++;
  3916. // subscribe all the users from the session to this course inside the session
  3917. $nbr_users=0;
  3918. foreach ($user_list as $enreg_user) {
  3919. $enreg_user_id = Database::escape_string($enreg_user['id_user']);
  3920. $sql_insert = "INSERT IGNORE INTO $tbl_session_rel_course_rel_user (id_session,course_code,id_user) VALUES ('$id_session','$enreg_course','$enreg_user_id')";
  3921. api_sql_query($sql_insert,__FILE__,__LINE__);
  3922. if (Database::affected_rows()) {
  3923. $nbr_users++;
  3924. }
  3925. }
  3926. api_sql_query("UPDATE $tbl_session_rel_course SET nbr_users=$nbr_users WHERE id_session='$id_session' AND course_code='$enreg_course'",__FILE__,__LINE__);
  3927. $sql_directory = "SELECT directory FROM $tbl_course WHERE code = '$enreg_course'";
  3928. $res_directory = api_sql_query($sql_directory,__FILE__,__LINE__);
  3929. $row_directory = Database::fetch_row($res_directory);
  3930. $course_directory[] = $row_directory[0];
  3931. }
  3932. }
  3933. api_sql_query("UPDATE $tbl_session SET nbr_courses=$nbr_courses WHERE id='$id_session'",__FILE__,__LINE__);
  3934. $course_directory[]=$id_session;
  3935. $cad_course_directory = implode(",",$course_directory);
  3936. $results[] = $cad_course_directory;
  3937. continue;
  3938. }
  3939. $count_results = count($results);
  3940. $output = array();
  3941. for($i = 0; $i < $count_results; $i++) {
  3942. $output[] = array('original_course_id_values' =>$orig_course_id_value[$i],'original_session_id_value' =>$orig_session_id_value[$i],'result' => $results[$i]);
  3943. }
  3944. return $output;
  3945. }
  3946. /* Register DokeosWSUnsuscribeCoursesFromSession function */
  3947. // Register the data structures used by the service
  3948. $server->wsdl->addComplexType(
  3949. 'unsubscribeCoursesFromSessionParams',
  3950. 'complexType',
  3951. 'struct',
  3952. 'all',
  3953. '',
  3954. array(
  3955. 'original_course_id_values' => array('name' => 'original_course_id_values', 'type' => 'tns:originalCoursesList'),
  3956. 'original_course_id_name' => array('name' => 'original_course_id_name', 'type' => 'xsd:string'),
  3957. 'original_session_id_value' => array('name' => 'original_session_id_value', 'type' => 'xsd:string'),
  3958. 'original_session_id_name' => array('name' => 'original_session_id_name', 'type' => 'xsd:string')
  3959. )
  3960. );
  3961. $server->wsdl->addComplexType(
  3962. 'unsubscribeCoursesFromSessionParamsList',
  3963. 'complexType',
  3964. 'array',
  3965. '',
  3966. 'SOAP-ENC:Array',
  3967. array(),
  3968. array(array('ref'=>'SOAP-ENC:arrayType','wsdl:arrayType' => 'tns:unsubscribeCoursesFromSessionParams[]')),'tns:unsubscribeCoursesFromSessionParams'
  3969. );
  3970. $server->wsdl->addComplexType(
  3971. 'unsubscribeCoursesFromSession',
  3972. 'complexType',
  3973. 'struct',
  3974. 'all',
  3975. '',
  3976. array(
  3977. 'coursessessions' => array('name' => 'coursessessions', 'type' => 'tns:unsubscribeCoursesFromSessionParamsList'),
  3978. 'secret_key' => array('name' => 'secret_key', 'type' => 'xsd:string')
  3979. )
  3980. );
  3981. // Prepare output params, in this case will return an array
  3982. $server->wsdl->addComplexType(
  3983. 'result_unsubscribeCoursesFromSession',
  3984. 'complexType',
  3985. 'struct',
  3986. 'all',
  3987. '',
  3988. array(
  3989. 'original_course_id_values' => array('name' => 'original_course_id_values', 'type' => 'xsd:string'),
  3990. 'original_session_id_value' => array('name' => 'original_session_id_value', 'type' => 'xsd:string'),
  3991. 'result' => array('name' => 'result', 'type' => 'xsd:string')
  3992. )
  3993. );
  3994. $server->wsdl->addComplexType(
  3995. 'results_unsubscribeCoursesFromSession',
  3996. 'complexType',
  3997. 'array',
  3998. '',
  3999. 'SOAP-ENC:Array',
  4000. array(),
  4001. array(array('ref'=>'SOAP-ENC:arrayType','wsdl:arrayType' => 'tns:result_unsubscribeCoursesFromSession[]')),'tns:result_unsubscribeCoursesFromSession'
  4002. );
  4003. // Register the method to expose
  4004. $server->register('DokeosWSUnsuscribeCoursesFromSession', // method name
  4005. array('unsubscribeCoursesFromSession' => 'tns:unsubscribeCoursesFromSession'), // input parameters
  4006. array('return' => 'tns:results_unsubscribeCoursesFromSession'), // output parameters
  4007. 'urn:WSRegistration', // namespace
  4008. 'urn:WSRegistration#DokeosWSUnsuscribeCoursesFromSession', // soapaction
  4009. 'rpc', // style
  4010. 'encoded', // use
  4011. 'This service subscribes a course to a session' // documentation
  4012. );
  4013. // define the method DokeosWSUnsuscribeCoursesFromSession
  4014. function DokeosWSUnsuscribeCoursesFromSession($params) {
  4015. global $_configuration;
  4016. $secret_key = $params['secret_key'];
  4017. $security_key = $_SERVER['REMOTE_ADDR'].$_configuration['security_key'];
  4018. if (!api_is_valid_secret_key($secret_key,$security_key)) {
  4019. return -1; //secret key is incorrect
  4020. }
  4021. // initialisation
  4022. $tbl_session_rel_course_rel_user = Database::get_main_table(TABLE_MAIN_SESSION_COURSE_USER);
  4023. $tbl_session = Database::get_main_table(TABLE_MAIN_SESSION);
  4024. $tbl_session_rel_user = Database::get_main_table(TABLE_MAIN_SESSION_USER);
  4025. $tbl_session_rel_course = Database::get_main_table(TABLE_MAIN_SESSION_COURSE);
  4026. $tbl_course = Database::get_main_table(TABLE_MAIN_COURSE);
  4027. $t_sf = Database::get_main_table(TABLE_MAIN_SESSION_FIELD);
  4028. $t_sfv = Database::get_main_table(TABLE_MAIN_SESSION_FIELD_VALUES);
  4029. $t_cfv = Database::get_main_table(TABLE_MAIN_COURSE_FIELD_VALUES);
  4030. $t_cf = Database::get_main_table(TABLE_MAIN_COURSE_FIELD);
  4031. $coursessessions_params = $params['coursessessions'];
  4032. $results = array();
  4033. $orig_course_id_value = array();
  4034. $orig_session_id_value = array();
  4035. foreach($coursessessions_params as $coursesession_param) {
  4036. $original_session_id_value = $coursesession_param['original_session_id_value'];
  4037. $original_session_id_name = $coursesession_param['original_session_id_name'];
  4038. $original_course_id_name = $coursesession_param['original_course_id_name'];
  4039. $original_course_id_values = $coursesession_param['original_course_id_values'];
  4040. $orig_session_id_value[] = $original_session_id_value;
  4041. // get session id from original session id
  4042. $sql_session = "SELECT session_id FROM $t_sf sf,$t_sfv sfv WHERE sfv.field_id=sf.id AND field_variable='$original_session_id_name' AND field_value='$original_session_id_value'";
  4043. $res_session = api_sql_query($sql_session,__FILE__,__LINE__);
  4044. $row_session = Database::fetch_row($res_session);
  4045. $id_session = $row_session[0];
  4046. if (empty($id_session)) {
  4047. $results[] = 0;
  4048. continue;
  4049. }
  4050. // get courses list from row_original_course_id_values
  4051. $course_list = array();
  4052. foreach ($original_course_id_values as $row_original_course_list) {
  4053. $sql_course = "SELECT course_code FROM $t_cf cf,$t_cfv cfv WHERE cfv.field_id=cf.id AND field_variable='$original_course_id_name' AND field_value = '$row_original_course_list'";
  4054. $res_course = api_sql_query($sql_course,__FILE__,__LINE__);
  4055. $row_course = Database::fetch_row($res_course);
  4056. if (empty($row_course[0])) {
  4057. continue; // course_code don't exist'
  4058. } else {
  4059. $sql = "SELECT code FROM $tbl_course WHERE code ='".$row_course[0]."' AND visibility = '0'";
  4060. $resu = api_sql_query($sql,__FILE__,__LINE__);
  4061. $r_check_course = Database::fetch_row($resu);
  4062. if (!empty($r_check_course[0])) {
  4063. continue; // user_id is not active
  4064. }
  4065. }
  4066. $course_list[] = $row_course[0];
  4067. }
  4068. if (empty($course_list)) {
  4069. $results[] = 0;
  4070. continue;
  4071. }
  4072. $orig_course_id_value[] = implode(",",$course_list);
  4073. foreach ($course_list as $enreg_course) {
  4074. $enreg_course = Database::escape_string($enreg_course);
  4075. api_sql_query("DELETE FROM $tbl_session_rel_course WHERE course_code='$enreg_course' AND id_session='$id_session'");
  4076. api_sql_query("DELETE FROM $tbl_session_rel_course_rel_user WHERE course_code='$enreg_course' AND id_session='$id_session'");
  4077. $return = Database::affected_rows();
  4078. }
  4079. $nbr_courses = 0;
  4080. $sql = "SELECT nbr_courses FROM $tbl_session WHERE id = '$id_session'";
  4081. $res_nbr_courses = api_sql_query($sql,__FILE__,__LINE__);
  4082. $row_nbr_courses = Database::fetch_row($res_nbr_courses);
  4083. if (Database::num_rows($res_nbr_courses) > 0) {
  4084. $nbr_users = ($row_nbr_courses[0] - $return);
  4085. }
  4086. // update number of users in the session
  4087. $update_sql = "UPDATE $tbl_session SET nbr_courses= $nbr_courses WHERE id='$id_session' ";
  4088. api_sql_query($update_sql,__FILE__,__LINE__);
  4089. $results[] = 1;
  4090. continue;
  4091. }
  4092. $count_results = count($results);
  4093. $output = array();
  4094. for($i = 0; $i < $count_results; $i++) {
  4095. $output[] = array('original_course_id_values' =>$orig_course_id_value[$i],'original_session_id_value' =>$orig_session_id_value[$i],'result' => $results[$i]);
  4096. }
  4097. return $output;
  4098. }
  4099. // Use the request to (try to) invoke the service
  4100. $HTTP_RAW_POST_DATA = isset($HTTP_RAW_POST_DATA) ? $HTTP_RAW_POST_DATA : '';
  4101. $server->service($HTTP_RAW_POST_DATA);